You have two choices - neither of them nice:
a) Create the tablespace with the same name in the new database then
move the objects across after the import.
b) Create all the tables and indices first and just import the data
(set ignore = y).
To get a list of tables run within a schema run in SQLPlus:
exec dbms_metadata.get_ddl('TABLE',tablename,schema);
(You can just run
SELECT ' exec
dbms_metadata.get_ddl(''TABLE'','||table_name||','||owner||');' from
dba_tables where owner = .....
then execute the output if you like)
The change the DDL outputted to change the tablespace.
Repeat for indices
Neither way is nice...
>>> "Ryan_Froman"
<oracledba-ezmlmshield-x68593164.[Email address protected] 30/07/2004
9:56:03 am >>>
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