DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: export/import

  1. #1
    Join Date
    Feb 2002
    i have a full database export dump.
    Now i want to import it into a newly created database.

    How should i go about;
    Should i create all the tablespaces in advance ?

    How abt the dictionary objects ?


  2. #2
    Join Date
    Sep 2000
    No you need not to do any any thing just import that dmp file

    imp username/password full=y

    You have to create the database and the data dictionary else everything it will do from import file.


  3. #3
    Join Date
    Apr 2001
    Brisbane, Queensland, Australia
    Hmmm, I don't know what version of Oracle you are running, but you may need to create the Tablespaces prior to importing. I've performed FULL imports on 8.1.6 and 8.1.7 and the process will fail on tables in which are NOT in default tablespaces. Personally, I'd be wanting to create them prior, gives you a little more control of the process. To determine which tablespaces you require, run the import with SHOW=Y, this is run a 'fake' import i.e. spool what the IMPORT process would do to the .log file you specify.
    OCP 8i, 9i DBA
    Brisbane Australia

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