将一个数据库文件中的所有用户及数据复制到另一个数据库中的方法:
数据库文件导出:cmd -> exp system/neusoft@orcl file=e:\temp.dmp owner=(scott,sys,epsa)
数据库文件导入:cmd -> imp system/neusoft@orcl file="e:\temp.dmp" full = y
一、表空间创建(可自定义表空间的位置,适用于数据量比较大的文件):
CREATE TABLESPACE "EPSA"
LOGGING
DATAFILE '(任选文件夹路径,如e:\epsa)\EPSA.DBF'
SIZE 1024M AUTOEXTEND
ON NEXT 50M MAXSIZE 5120M;
二、创建oracle用户
--创建epsa用户(此用户数据放在EPSA表空间下)
-- Create the user
create user EPSA
identified by "密码"
default tablespace EPSA
temporary tablespace TEMP
profile DEFAULT
quota unlimited on epsa
-- Grant/Revoke role privileges
grant connect to EPSA;
grant resource to EPSA;
-- Grant/Revoke system privileges
grant create any synonym to EPSA;
grant create any view to EPSA;
grant create session to EPSA;
grant debug any procedure to EPSA;
grant debug connect session to EPSA;
grant select any dictionary to EPSA;
grant unlimited tablespace to EPSA;