imp/exp commands
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: imp/exp commands

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    152
    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

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    In the command prompt type:

    exp help=yes
    imp help=yes

    Cheers

    Angel

  3. #3
    Join Date
    Jan 2002
    Posts
    152
    Thanks,but what I want to find out is how can I import the objects to a new tablespace,in my new schema...
    Thanks

  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    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

  5. #5
    Join Date
    Jan 2002
    Posts
    152
    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
  •  


Click Here to Expand Forum to Full Width