Set quota zero on all other tablespace for that user.


Thanks and Regards
KempegowdA....
Cognizant Technology Solutions
Ph : 91 44 2811 3063 Ext:-2249
Vnet -- 42249
Discipline is the bridge between goals and accomplishment..- Jim Rohn


-----Original Message-----
From: Vikas Sharma [mailto:[Email Address Removed]
Sent: Friday, January 30, 2004 3:59 PM
To: LazyDBA.com Discussion
Subject: RE: Importing data into a different tablespace

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








--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these terms:http://www.lazydba.com/legal.html

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.

Visit us at http://www.cognizant.com
Oracle LazyDBA home page