-
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
-
The only thing I can think of is to export only the tables in the schema. Confirm this with someone.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|