删除用户中的所有表,创建 pdb代码

select 'drop table "'||table_name||'";'
from cat 
where table_type='TABLE'

– 删除用户中的所有表
将运行出来的结果放到上面执行

CREATE PLUGGABLE DATABASE notrthwind
admin user huzi_NH identified by 123 roles=(connect,resource,dba)
file_name_convert = (‘D:\dahuzi\or_an\oradata\XE\pdbseed’,‘D:\oracle_biao\Notwind\pdb’);

alter session set container = notrthwind;

alter pluggable database close immediate;

alter pluggable database open = alter database open;

grant restricted session to huzi_NH ;

connect NWAdmin/AdminNW@Northwind;

Create TableSpace nw_tablespace01 datafile ‘C:\app\OracleHomeUser\oradata\orcl\nwindorcl\datafile01.dbf’ size 20m;

Alter User NWAdmin default tablespace nw_tablespace01;

Alter User NWAdmin quota unlimited on nw_tablespace01;