Skip to content

Insight and analysis of technology and business strategy

Errors in a puggable dtabase?

Fahd Mirza Photo Fahd Mirza date icon
Tags: , , ,
  There might be a situation where executing some DDL in pluggable database may cause the following error: ORA-65040: operation not allowed from within a pluggable database This error could occur if a tablespace is being dropped from within PDB and this tablespace is a former default tablespace having some of the system objects. Even system objects cannot be moved with simple alter statements from within PDBs. So in order to move these objects from within PDBs, you should be using procedure dbms_pdb.exec_as_oracle_script which is undocumented so far. For example: exec dbms_pdb.exec_as_oracle_script('alter table <owner>.<table_name> move tablespace <tablespace name>'); From My Oracle Support, Doc ID 1943303.1 lists: -- This procedure enables execution of certain restricted statements (most DDLs) on metadata-linked objects, from within a PDB.   Discover more about our expertise in the world of Oracle.
Fahd Mirza Photo Fahd Mirza

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

Top Categories

  • There are no suggestions because the search field is empty.

Tell us how we can help!
dba-cloud-services
Upcoming-Events-banner