offline表空间迁移数据库
offline表空间迁移数据库–查看表空间的存放地址Select * from dba_data_files t,–查看所有用户Select * from dba_users t2Offline表空间–1. offline表空间alter tablespace CPGX_GL_ZTZR offline;–2.复制表空间文件到新目录cp -a /u01/app/oracle/product/11.2.0/dbhome_1/dbs/ZTZR.dbf /media/newdisk/orac
原创
2020-08-19 18:02:49 ·
73 阅读 ·
0 评论