Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

previledge is needed to execute a ddl command...

520501Aug 2 2006 — edited Aug 3 2006
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2006
Added on Aug 2 2006
18 comments
647 views