1、创建表空间 --数据 CREATE SMALLFILE TABLESPACE "MYNAME_DATA" DATAFILE 'H:\ora_data\MYNAME_data.ora' SIZE 10M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; --索引 CREATE SMALLFILE TABLESPACE "MYNAME_IDX" DATAFILE 'H:\ora_data\MYNAME_idx.ora' SIZE 10M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; 2、创建用户 CREATE USER "MYNAME" PROFILE "DEFAULT" IDENTIFIED BY "1" DEFAULT TABLESPACE "MYNAME_DATA" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK; GRANT "CONNECT" TO "MYNAME"; 3、授权 grant "CONNECT","RESOURCE" to "MYNAME"; grant "DBA" to "MYNAME"; 4、备份 exp dbo_user01/1@orcl01 file='c:\data.dmp' exp dbo_user01/1@127.0.0.1/orcl file='c:\data.dmp' owner=dbo_user01 5、恢复 imp dbo_user02/1@orcl01 file='c:\data.dmp' full=y imp dbo_user02/1@127.0.0.1/orcl fromuser=dbo_user01 touser=dbo_user02 file='c:\data.dmp' 参考资料 [1] CREATE TABLESPACE. oracle. http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7003.htm [2] CREATE USER. oracle. http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8003.htm [3] Export Utilities. oracle. http://docs.oracle.com/cd/B10501_01/server.920/a96652/ch01.htm [4] Import Utilities. oracle. http://docs.oracle.com/cd/B10501_01/server.920/a96652/ch02.htm [5] oracle create tablespace. cnblogs. http://www.cnblogs.com/mopmoq/archive/2009/05/28/1491384.html [6] ORACLE CREATE USER 命令. csdn. http://blog.csdn.net/cheungjustin/article/details/5441962 [7] oracle数据库拷贝. baidu zhidao. http://zhidao.baidu.com/question/408409174.html
oracle 恢复用户表空间,Oracle 创建表空间、用户、备份恢复
最新推荐文章于 2021-04-08 22:50:31 发布