export list of tables only
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: export list of tables only

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    exp system parfile=foo.par

    -------foo.par-----
    file=foo.dmp
    tables=owner.foo1, owner.foo2, owner.foo3
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    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.

  4. #4
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150
    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

  5. #5
    Join Date
    Oct 2000
    Posts
    449
    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
  •  


Click Here to Expand Forum to Full Width