oracle 数据导入导出

来源：互联网发布：大数据对贵州的影响编辑：程序博客网时间：2024/05/29 15:13

GSMARKETCREDIT
gsxyjg
gsxyjg

sqlplus / as sysdba

alter tablespace GSMARKETCREDIT offline
drop tablespace GSMARKETCREDIT including contents and datafiles
drop user gsxyjg cascade

创建表空间
create tablespace GSMARKETCREDIT
datafile 'GSMARKETCREDIT.DBF' size 250m autoextend on next 10m maxsize unlimited
permanent
default storage(initial 64K minextents 1 maxextents 2147483645)
minimum extent 64k
logging
online

创建用户
create user gsxyjg identified by gsxyjg default tablespace GSMARKETCREDIT temporary tablespace temp profile default
/
grant connect to gsxyjg with admin option
/
grant dba to gsxyjg with admin option
/
grant unlimited tablespace to gsxyjg with admin option

//不是在sql下
导入用户下的表空间
imp gsxyjg/gsxyjg@orcl file=F:\oracle_log\LJXYJG.DMP log=F:\oracle_log\LJXYJGIMP.LOG full=y
导出用户下的表空间
本地：
exp gsxyjg/gsxyjg@orcl file=F:\oracle_log\LJXYJG.DMP log=F:\oracle_log\LJXYJGIMP.LOG
异地：
exp gsxyjg/gsxyjg@192.168.110.238:1521/orcl file=F:\oracle_log\LJXYJG.DMP log=F:\oracle_log\LJXYJGIMP.LOG
导出部分表
exp gsxyjg/gsxyjg@orcl file=F:\oracle_log\LJXYJG02150611W.DMP log=F:\oracle_log\LJXYJGIMP20150611W.LOG tables=(SYS_USERS,KEY_ENTITY_INFO)

0 0