---创建新的表空间 CREATE TABLESPACE tablespace_name DATAFILE '/path/filename.ora' SIZE 500M AUTOEXTEND ON NEXT 1280 K ONLINE EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING; /---创建数据库用户 CREATE USER username PROFILE DEFAULT IDENTIFIED BY "******" DEFAULT TABLESPACE tablespace_name TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK; GRANT CONNECT TO username; GRANT RESOURCE TO username; ALTER USER username DEFAULT ROLE CONNECT,RESOURCE; /-- 导出 exp username/pswd@rm_sid FILE=expdat.dmp--导入 imp username/pswd@lc_sid
2,从服务器上倒出你所需要的数据 建议用exp 全库导出数据文件,和日志文件 *.dmp *.log
3 将倒出的数据文件*.dmp,*.log 导入到你建立的数据库指定的用户 即可.
CREATE TABLESPACE tablespace_name
DATAFILE
'/path/filename.ora' SIZE 500M
AUTOEXTEND ON NEXT 1280 K
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
LOGGING;
/---创建数据库用户
CREATE USER username
PROFILE DEFAULT
IDENTIFIED BY "******"
DEFAULT TABLESPACE tablespace_name
TEMPORARY TABLESPACE TEMP
ACCOUNT UNLOCK;
GRANT CONNECT TO username;
GRANT RESOURCE TO username;
ALTER USER username DEFAULT ROLE
CONNECT,RESOURCE;
/-- 导出
exp username/pswd@rm_sid FILE=expdat.dmp--导入
imp username/pswd@lc_sid