|
-
importing data script question
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|