|
-
Another approach would be ...
connect accounts_owner/password
create table ACCOUNTS_28112002 as select * from accounts where rownum < 1;
grant insert ,select on ACCOUNTS_28112002 to accounts_importer;
connect accounts_importer
create view accounts as select * from accounts_owner.ACCOUNTS_28112002;
... then import ACCOUNTS into the accounts_importer schema with IGNORE=Y.
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
|