Home » RDBMS Server » Server Administration » Moving data across datafiles
Moving data across datafiles [message #223986] Mon, 12 March 2007 09:48 Go to next message
shyamsundar.ga
Messages: 1
Registered: March 2007
Junior Member
Hi All

I want know how to move the contents of one dbf file to another

The scenario is , i have 8 table spaces with each of them having 4-5 datafiles . i want to create one unified datafile out of 4-5 datafiles for better manageability

Regards
Shyam
Re: Moving data across datafiles [message #224000 is a reply to message #223986] Mon, 12 March 2007 10:48 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
try below procedure
select distinct object_type,owner
from dba_segments
where tablespace_name='&TABLESPACE_NAME';
create tablespace with BIGFILE datafile.
AND MAKE IT DEFAULT DATABASE TABLESPACE.
through expdp export tablespace.
expdp userid/pwd DIRECTORY=data DUMPFILE=user TABLESPACES=users
DROP TABLESPACE TBS_NAME INCLUDING CONTENTS AND DATAFILES
impdp userid/pwd DIRECTORY=DATA DUMPFILE=USER [B]REMAP_TABLESPACE=OLD_TBS_NAME:NEW_TBS_NAME
select distinct object_type,owner
from dba_segments
where tablespace_name='&TABLESPACE_NAME';


hope this helps
Taj
Previous Topic: Shrinking database
Next Topic: Unable to execute sqlplus command.
Goto Forum:
  


Current Time: Thu Dec 08 14:25:33 CST 2016

Total time taken to generate the page: 0.09500 seconds