I'm searching info about that commands (imp and exp).
I have guessed something,but I wonder if I can import one database from one tablespace to another one.Because I got it,in a different schema,but the refered tablespace is the original one...
In the command prompt type:
Thanks,but what I want to find out is how can I import the objects to a new tablespace,in my new schema...
If you have the export of the first schema, then:
1. Assign the new tablespace as default to the new user, then just:
imp user/password file=your_file.dmp log=file_log fromuser=old_user touser=new_user indexes=no
After run the same command with the parameter indexfile=file_you_want
This generate a file with the DLL to create the indexes. Change the tablespace where the indexes were created for the new tablespace you want. Connect as the new user and run the .sql
Hope that helps
Thanks very much...I thought there was another way more direct to do that.Because if you have a huge database,you have to change many times tablespace name in the log file.
Click Here to Expand Forum to Full Width