creating tables on remote database
Posted
by raj
on Server Fault
See other posts from Server Fault
or by raj
Published on 2010-04-08T06:43:03Z
Indexed on
2010/04/08
6:53 UTC
Read the original article
Hit count: 286
I created a database link using database link.
create public database link REMOTEDB connect to REMOTEUSER identified by REMOTEPWD using 'REMOTEDB';
then i create a table in remote db like,
create table MYTABLE@REMOTEDB (name varchar2(20)));
It says, ORA-02021 DDL operations are not allowed on| a remote database..
Will this Not work on any cost, or am i just missing some permissions to create ?
© Server Fault or respective owner
