-
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
Jeff Hunter
-
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
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
|