Printable View
import documentation script
• Unzip the export file
• Disable constraints before importing the data
drop the indexes
truncate the table
• Create a script file (create_nmtabledata.sql) using the information below
imp userid=system/manager fromuser=scott tables=(emp,dept)
file=exp_scott.dmp log=imp_scott.log indexes=n ignore=y b
recreate the indexes
reenable the constraints
my question is when will you include buffer=64000 and commit=y
imp help=y
I would create a parfile not a sql file.
file=exp_scott.dmp
log=imp_scott.log
userid=system (Never put a password in a parfile!!)
fromuser=scott
touser=?????
tables=(emp,dept)
indexes=n
ignore=y
Buffer=4000000
commit=y
The buffer and commit are only used for large tables, if you are dealing with small tables you don't really need it.
MH
if you dont remove the indexes and recreate them after the import what would happen to the data when trying to insert to an indexed table aside from the import going slowly?Quote:
Originally posted by Mr.Hanky
I would create a parfile not a sql file.
file=exp_scott.dmp
log=imp_scott.log
userid=system (Never put a password in a parfile!!)
fromuser=scott
touser=?????
tables=(emp,dept)
indexes=n
ignore=y
Buffer=4000000
commit=y
The buffer and commit are only used for large tables, if you are dealing with small tables you don't really need it.
MH