Importing one table from dump
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Importing one table from dump

Hybrid View

  1. #1
    Join Date
    Aug 2001
    Location
    Philadelphia, NJ
    Posts
    44

    Angry

    Does anyone know how to import just one table from a dump file. Iam using the following syntax:

    imp73 SYS/sys@SMT file="C:\PDTBefore.dmp" log="pdtbefore.log" indexfile="C:\PDTBefore.idx" buffer=512000 ignore=Y commit=y FROMUSER=sbprod26e4 TOUSER=sbtest26e4 tables = "DMDOCDATA"

    I have also done the same command with the " " around DMDOCDATA to no avail. The imp73 utility says 'skipping DMDOCDATA' which is what iam trying to import without importing all tables in the dump. Any suggestions? Also will this overwrite the whole table or just insert records. I do not want it overwritten. Thanks!
    EJC

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    I think you need to truncate that table, this way the structure will stay and only the rows will be inserted. Be sure to back up that table first!!. Also, are the two databases on the same version of Oracle? The Import/Export utilities have to jive.

    MH

  3. #3
    Join Date
    Aug 2001
    Location
    Philadelphia, NJ
    Posts
    44

    Cool Fixed

    I didscovered that the problem was with the index feature. It doesnt import just create some kind of log file. Thanks for the help though.
    EJC

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