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!
Click Here to Expand Forum to Full Width