Results 1 to 4 of 4

Thread: import

  1. #1
    Join Date
    Sep 2003
    Posts
    218

    Unanswered: import

    I am running Oracle v8i on win2k server.

    I need to export list of tables from the source database into target(test) database.

    I have done a export into a dump file.

    I am importing it into a test database and we get a list of tables that are imported on the screen. My question is: Is there a way to see list of tables that still need to be imported from the dump file? If so, could you please let us know how can this be achieved?

    Many thanks in advance.

  2. #2
    Join Date
    Nov 2003
    Location
    Rotterdam, Netherlands
    Posts
    127
    Its not possible to list the remaining tables

    But the tables are imported in alphabetical order
    So if u know the pattern of the last set of tables, u can just have an approximation of how many more are there!!!

  3. #3
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120
    The .dmp file can be opened in a text editor.
    If it is of any size be prepared to have your memory used up!
    all of the tables and tablespaces can be seen in a format that resembles DDL.

  4. #4
    Join Date
    Sep 2003
    Location
    Washington, DC
    Posts
    13
    It would be easier to read the log file than the dmp file. It's a lot smaller, too. As for the tables being listed in alphabetical order, this is true. However, remember that one schema is imported/exported at a time, so the order is by schema, then alphabetical.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •