importing data script question

[imose]

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

[marist89]

imp help=y

[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

[imose]

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?