Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating remote table thru a DB Link
"Dan" <daniel.ostertag_at_visaer.com> a écrit dans le message de news: 1146242891.400839.84040_at_y43g2000cwc.googlegroups.com...
|I am trying to do a 'create table as select' to create a remote table,
| but I am getting the error "ORA-02021 DDL operations are not allowed on
| a remote database". Is this operation at all possible? The error
| seems to say no but I've read and been told that you just need the
| privs to do this on the remote database but I don't know the privs.
|
| For example, this is what I need to do:
| - have a dblink from instance 1 (local) to instance 2 (remote)
| - create table XXX on the local database
| - create table on the remote database using the statement:
| create table XXX_at_remote_db as select * from XXX;
|
| The database link is logging on to the remote db as a user that has the
| privs to create tables. Is there something I need to do to make this
| work or is the operation just not possible?
|
| Thanks,
| Dan
|
As the error message states, you can't do it.
Regards
Michel Cadot
Received on Fri Apr 28 2006 - 12:09:19 CDT