DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: export

  1. #1
    Join Date
    Apr 2001
    Posts
    60
    Hi

    Can we able to export the USER leaving packages & package bodies? I have around 4000 packages which i dont want to
    export each and everytime.
    rammi

  2. #2
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    The only thing I can think of is to export only the tables in the schema. Confirm this with someone.

  3. #3
    Join Date
    Nov 2000
    Posts
    89
    Halo is correct (again) ...

    I could add a couple of comments to make life easier. That is download or write a script that dumps the names of the users tables and place those names in either a series of exp commands or a listing in the export command that lists the tables to export- that is a comma seperated list:

    %exp file=filename.dmp log=logname.log tables=(xxx.xxx,xxx.yyy,xxx.ggg)

    So forth and so on ...

    -Roger

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