Database Import
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 22

Thread: Database Import

  1. #1
    Join Date
    Mar 2001
    Posts
    131
    Hi friends,

    In my windowsNT box there was one database, now due to disk crash the database is not there. I have installed windowsNT and Oracle. Now i want to restore whole DB with export backup(latest one), but i don't know the structure of earlier DB (datafiles path and all) so How do i proceed with import ??

    I don't have anyother backup except EXPORT.

    Thnaks,

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Hi,
    datafiles paths are not important here.
    You have to create all tablespaces that were in the old database.
    In order to find out their names you may directly look in the dumpfile with an editor or use
    Code:
    imp user/pwd full=y indexfile=schema.sql
    In the schema.sql you'll see the create statements for all objects with tablespace names.
    HTH
    Ales
    The whole difference between a little boy and an adult man is the price of toys

  3. #3
    Join Date
    Jun 2001
    Posts
    316

    Question

    mebbe replacing IMP with EXP would work!!

  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Originally posted by helpme
    mebbe replacing IMP with EXP would work!!
    Sleep a bit and try again helpme

    Cheers

    Angel

  5. #5
    Join Date
    Mar 2001
    Posts
    131
    Hi Ales

    *************************************************
    imp user/pwd full=y indexfile=schema.sql

    In the schema.sql you'll see the create statements for all objects with tablespace names
    *************************************************
    where to give this command, I think it will start importing data. How can i know the tablespace names and size from export.dmp file ??

    Any other way.....? any other suggestions ??

  6. #6
    Join Date
    Jun 2001
    Posts
    316

    lol....aarroyob

    yeah..i deff need those..or mebbe need to read more books!!!*rolling eyes*

    using the indexfile option doesnt import data,,..just creates a file with the deff!!!

  7. #7
    Join Date
    Mar 2001
    Posts
    144
    Ales is correct:

    http://metalink.oracle.com/metalink/...1&p_showHelp=1

    This may make it a little clearer.

  8. #8
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Upeshp
    -----------------------------------------
    where to give this command, I think it will start importing data. How can i know the tablespace names and size from export.dmp file ??
    -----------------------------------------

    You can not find the tablespace related info from the export dump. Simply write IMP command on the C:\ .

    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

  9. #9
    Join Date
    Oct 2001
    Posts
    126
    Upeshp:

    If you open your export dump file, you will find at the very beginning of the tablespace structure you are looking for.

    Susan

  10. #10
    Join Date
    Mar 2001
    Posts
    131
    Dear Susan,

    Please tell me How to open export dump file, I really don't know.....

    Thanks

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