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

Thread: Import

  1. #1
    Join Date
    Aug 2001
    Location
    cuddapah
    Posts
    145

    Red face

    !hi

    Iam with Export utility . I exported full database.

    When try to improt it i am receiving a error . how to import fulldatabase . but i now the command .
    what are the step's i have to follow .
    import will work only on new database or existing one also.

  2. #2
    Join Date
    Mar 2002
    Posts
    4
    If you dump of your full database then in import command syntax you have to give Full=Y and specify path for your exported dump file. Thru this you should be able to import full database.
    imp username/passwd Full=Y Ignore=Y Commit=Y file=

  3. #3
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    For import the full database:

    1. Drop all files associated to the database;
    2. Create a new database with the same database name,sid ...
    3. Run catalog.sql catproc.sql ...
    4. Run import with parameter full=yes. This will create for you all tablespaces in the database, but it is better to create it before running the import.

    Hope that helps

    Angel

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