-
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
-
-
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
I remember when this place was cool.
-
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
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?
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
|