OraFAQ Forum: Server Administration » Question about datafiles assigned to tablespace

Home » RDBMS Server » Server Administration » Question about datafiles assigned to tablespace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Question about datafiles assigned to tablespace [message #58504]

Wed, 03 September 2003 13:39

Rizwan Qazi
Messages: 135
Registered: August 2002

Senior Member

I have data files assigned to tablespace. Is it possible for me to drop or reassign or resize these datafiles for this tablspace ? If so how would I able to do it

Here is a query I used to add datafiles

alter tablespace DW add datafile 'E:ORACLEORADATADWTDWTDWAB07.DBF' SIZE 1000M REUSE;

and here is the query I used to find out information about the datafiles for this tablespace

select SUBSTR(file_name,1,50) FILE_NAME, bytes, status, RELATIVE_FNO from dba_data_files where tablespace_name='DW'

FILE_NAME BYTES STATUS RELATIVE_FNO
-------------------------------------------------- ---------- --------- ------------
E:ORACLEORADATADWTDWTDWAB01.DBF 1048576000 AVAILABLE 8
E:ORACLEORADATADWTDWTDWAB02.DBF 1048576000 AVAILABLE 12
E:ORACLEORADATADWTDWTDWAB03.DBF 1048576000 AVAILABLE 14
E:ORACLEORADATADWTDWTDWAB04.DBF 1048576000 AVAILABLE 16
E:ORACLEORADATADWTDWTDWAB05.DBF 1048576000 AVAILABLE 17
E:ORACLEORADATADWTDWTDWAB06.DBF 1048576000 AVAILABLE 18
E:ORACLEORADATADWTDWTDWAB07.DBF 1048576000 AVAILABLE 20

Thanks very much

Riz

Report message to a moderator

Re: Question about datafiles assigned to tablespace [message #58507 is a reply to message #58504]

Wed, 03 September 2003 18:33

Navneet
Messages: 12
Registered: August 2003

Junior Member

ALTER DATABASE DATAFILE 'file' RESIZE 'size' ;
will resize your your datafile.Be watchfull if you are reducing the size if this datafile contains segments or extents owned by database objects.

Report message to a moderator

Re: Question about datafiles assigned to tablespace [message #58523 is a reply to message #58507]

Thu, 04 September 2003 11:26

Rizwan Qazi
Messages: 135
Registered: August 2002

Senior Member

How do I determine if a certain datafile contains segments? Thanks

Riz

Report message to a moderator

Previous Topic:	Parallel Query
Next Topic:	ORA-03232 in Oracle 8i 8.1.7

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:30:00 CDT 2024