-
Export from a user to another
Hi all,
I want to understand why when I export all the objects of a user to another user, I have always some triggers which have the old schema as table owner. What can I do to avoid this problem
Thanks in advance
NED
-
You should post your import and export commands.
However this should work:
exp system/pwd@aliasa owner=schema-a
imp system/pwd@aliasb fromuser=schema-a touser=schema-b ignore=y commit=y buffer=102400
schema-b should already exist. and it should have the basic grants connect, resource.
I have done this before and it does work unless there is something different about your database it should work.
-
That exactly what I always do Gandolf
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
|