previledge is needed to execute a ddl command...
520501Aug 2 2006 — edited Aug 3 2006I am getting an error saying i do not have previledge to execute ddl at remote database.
dmls are executed sucessfully.
I need to know which grant should be given to me by the sysdba of remote db so that i can execute ddls too.
Tried to find the solution on net.It says "need proper priviledge" can i know exectly which grant do i need?
SQL> conn dushyant/dushyant@orcl;
Connected.
SQL> select * from tab@dvd;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
CLASSES TABLE
SQL> create table temp@dvd (a number);
create table temp@dvd (a number)
*
ERROR at line 1:
ORA-02021: DDL operations are not allowed on a remote database