Ritesh Raj Singh

• Jul 12th, 2006

 

Yes you can decrease the size of the datafile to the place where the extents are deallocated in to it by resizing the datafiles to something smaller than current. If the data in the datafile is scattered than reorg the object in the tablespace to deallocate the extent and decrease the filesize

for furthure queries send it to

Priteshrajsingh1984 @ yahoo.com

Ritesh Raj Singh

Oracle DBA

ICICI Infotech

Mumbai

cmanne

 Profile Answers by cmanne 

• Jul 29th, 2006

 

According to me its not at all advisable to decrease the size of database objects which may have adverse effects on database. If one needs to dedcrease the size of a datafile in a tablespace, First take an export with tablespace option, then delete all the datafiles by taking the tablespace offline and then start adding the datafiles according to your need and finally import the tablespace objects exported during intial steps.

ugender

• Sep 18th, 2006

 

hai sir,please give me the details how to identify the oracle data files in the secondary memory i.e. in hard disk, for example the location of the emp table in hard disk.yours friendly,ugender

Ritesh Raj Singh

• Oct 8th, 2006

 

tables are allocated in terms of segments and segments are collection of extents which in terms collection of blocks...all segments are part of tablespace which is physically a collection of one or more datafiles..when u create a table, it is created in the tablespace which can be defined in the storage clause or if not mentioned than it would be in the default tablespace of the user.so if u want to find out that a table physically resides on which location...than look for dba extents it has a column called segment_name which u should compare it with ur table_name and than look for file_id match it with dba_data_files and u will be able to find out that table resides physically on which location..and one more thing a table can exist on more than one datafile...

select file_name from dba_data_files where file_id in(select distinct file_id from dba_extents where segment_name='&table_name');

Regards

Ritesh Singh

Oracle DBA ICICI Infotech Mumbai

Vishv Verma

• Oct 16th, 2006

 

alter database resize ;