CODEWITHSUNDEEP
oracle-database
prashanth
prashanth

Reputation: 17

tablespace thru dblinks

How can one create an tablespace using dblinks? Is there any way how do we create a tablespace in this fashion? what are the pre-requisities.

Upvotes: 1

Views: 323

Answers (1)

Rob van Laarhoven
Rob van Laarhoven

Reputation: 8905

You can not, you should not perform DDL over a database link. DDL does an implicit commit and a commit on the remote site is not allowed. 

ORA-02021: DDL operations are not allowed on a remote database

You can use the job queues - so that a transaction is performed on the remote system, eg: 

dbms_job.submit@remote( l_job, 'execute immediate ''create table t ( x int )''' ); 
commit;

Ask Tom

Upvotes: 3

Related Questions