u use transport tablespace export and transport tablespace import.

Transportable tablespaces let you move a set of tablespaces from one Oracle
database to another.


To do this, you must make the tablespaces read-only, copy the datafiles of
these tablespaces, and use Export/Import to move the database information
(metadata) stored in the data dictionary. Both the datafiles and the
metadata export file must be copied to the target database. The transport
of these files can be done using any facility for copying flat, binary
files, such as the operating system copying facility, binary-mode FTP, or
publishing on CD-ROMs.


After copying the datafiles and importing the metadata, you can optionally
put the tablespaces in read/write mode.


Import provides the following parameters to enable import of transportable
tablespaces metadata.
TRANSPORT_TABLESPACE
TABLESPACES
DATAFILES
TTS_OWNERS
Deepa Kale -DBA
Jyoti Structures - Nasik(IT)



"Vikas Sharma"
<[Email Address Removed] To: "Deepa S. Kale" <[Email Address Removed]
.co.in> cc: <[Email Address Removed]
Subject: RE: Importing data into a different tablespace
01/30/2004 03:58
PM






I've done that. And the Default Tablespace for the user A
has also been set to XYZ.

Even then, the data gets imported into ABC tablespace.

What do I do?



-----Original Message-----
From: Deepa S. Kale [mailto:[Email Address Removed] Friday, January 30, 2004 4:06 PM
To: Vikas Sharma
Cc: [Email Address Removed] Re: Importing data into a different tablespace


first create user A in diff. database and the give import command.

Deepa Kale -DBA
Jyoti Structures - Nasik(IT)




"Vikas Sharma"

<[Email Address Removed] To: "LazyDBA.com
Discussion" <[Email Address Removed] .co.in> cc:

Subject: Importing data
into a different tablespace
01/30/2004 01:36

PM









I have exported the data of USER A from tablespace ABC.

Now I want to import the data into tablespace XYZ in a different
database.

How can I do it?



Please help.



Regards,

Vikas Sharma












Oracle LazyDBA home page