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]
Sent: 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