Ryan-
Make the target tablespace the default tablespace for that user.


-----Original Message-----
From: Ryan_Froman
[mailto:oracledba-ezmlmshield-x68593164.[Email address protected]
Sent: Thursday, July 29, 2004 4:56 PM
To: LazyDBA Discussion
Subject: Import



Hi,

Quick question.

I need to import a user into a different Database and into a different
user. Now I know I use the FROMUSER TOUSER but, the from users TableSpace
does not exists in the TOUSERS Database. What would be the easiest way
around this so the import wont fail.

Thanks,


Ryan Froman

Database Administrator
Support and Development Services
Information Technology Division

Telephone: (08) 9449 XXXX





____________________________________________________________________________
___
Unencrypted electronic mail is not secure and may not be authentic.
If you have any doubts as to the contents please telephone to confirm.

This electronic transmission is intended only for those to whom it is
addressed. It may contain information that is confidential, privileged
or exempt from disclosure by law. Any claim to privilege is not waived
or lost by reason of mistaken transmission of this information.
If you are not the intended recipient you must not distribute or copy this
transmission and should please notify the sender. Your costs for doing
this will be reimbursed by the sender.
____________________________________________________________________________
___



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page