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
--数据
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