I have a file that has only tablenames called step12.lst. I want to export only these tables.. I am having problems when i do this.. How should my parfile look like.
Thanks ST2000
Printable View
I have a file that has only tablenames called step12.lst. I want to export only these tables.. I am having problems when i do this.. How should my parfile look like.
Thanks ST2000
exp system parfile=foo.par
-------foo.par-----
file=foo.dmp
tables=owner.foo1, owner.foo2, owner.foo3
Wrap the other parameters in your parfile around the table names, clean up the text in the table names, name this edited file something else, and set parfile=new_file_you_just_made.
It should look someting like this
file=file.dmp
log=file.log
indexes=n
constraints=n
grants=n
consistent=y
rows=y
compress=n
triggers=n
tables=
OWNER.TABLE_NAME,
..,
..,
OWNER.TABLE_NAME
Thanks guys.. for an instant reply...
ST2000