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 p开发者_如何学Pythonre-requisities.

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