-
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...
Thanks
-
In the command prompt type:
exp help=yes
imp help=yes
Cheers
Angel
-
Thanks,but what I want to find out is how can I import the objects to a new tablespace,in my new schema...
Thanks
-
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
Angel
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|