oracle数据库表空间复制,Oracle 数据库复制

---1.0 查询存在的用户

Select * From Dba_Users

---2.0 获取表空间的路径

Select File#, Name From V$datafile;

---3.0 创建表空间 和新增表空间

Select Distinct 'CREATE SMALLFILE TABLESPACE "' || a.Tablespace_Name ||

'" DATAFILE ' || '''' || 'C:\app\Administrator\oradata' ||

a.Tablespace_Name || '01' || '''' ||

' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 8G LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;' 创建表空间,

'ALTER TABLESPACE "' || a.Tablespace_Name || '" DATAFILE ' || '''' ||

'C:\app\Administrator\oradata' || a.Tablespace_Name || '02' || '''' ||

' SIZE 100M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 1G;' 增加表空间

From Dba_Data_Files a, Dba_Users b

Where a.Tablespace_Name = b.Default_Tablespace

And b.Account_Status = 'OPEN';

---4.0 创建用户

Select Distinct 'CREATE USER "' || b.Username ||

'" PROFILE "DEFAULT" IDENTIFIED BY "' || b.Username ||

'" DEFAULT TABLESPACE "' || a.Tablespace_Name ||

'" TEMPORARY TABLESPACE.........