DB基本操作（oracle）

建立用户 drop user lztest4 cascade; create user lztest4 identified by lztest123; alter user lztest4 default tablespace COMMON_CABLE; grant connect ,resource,dba to lztest4;   drop user lztest3 cascade; create user lztest3 identified by lztest123; alter user lztest3 default tablespace COMMON_CABLE; grant connect ,resource,dba to lztest3;   建立用户 drop user lztest8 cascade; create user lztest8 identified by lztest123; alter user lztest8 default tablespace COMMON_CABLE; grant connect ,resource,dba to lztest8;     drop tablespace common_cable INCLUDING CONTENTS AND DATAFILES;   建立表空间 create tablespace COMMON_CABLE datafile ‘E:/COMMON_CABLE.dbf‘    size 1500M    autoextend on next 5M maxsize 3000M;     导出数据库 exp lztest/lztest123@ora11 file=lztest.dmp grants=y; exp lztest7/lztest123@ora11 file=lztest7.dmp grants=y; exp lztest6/lztest123@ora11 file=lztest6.dmp grants=y; exp lztest5/lztest123@ora11 file=lztest5.dmp grants=y;   exp lztest6/lztest123@xgll123 file=f:\lztest6.dmp grants=y;     imp lztest3/lztest123@orcl file=f:\lztest6.dmp tablespaces=common_cable full=y;     导入数据库 不需要到文件的目录，使用默认的目录 imp lztest1/lztest123@orall file=f:/li/lztest.dmp full=y; imp lztest4/lztest123@ygsyt file=f:\bak.dmp tablespaces=common_cable full=y; imp lztest8/lztest123@orall file=f:\bak.dmp tablespaces=common_cable full=y; imp lztest21/lztest123@xgll123 file=f:\lztesty.dmp tablespaces=common_cable full=y; imp lztest21/lztest123@orcl file=f:\lztesty.dmp tablespaces=common_cable full=y;   Microsoft Windows [版本 6.1.7600] 版权所有 (c) 2009 Microsoft Corporation。保留所有权利。   C:\Users\Administrator> imp lzcable/lztest123@ora11 file=f:/lztestBAK.dmp tablespaces=common_cable full=y imp lztest8/lztest123@ora11 file=f:/bak.dmp tablespaces=common_cable full=y imp lztest7/lztest123@ora11 file=f:/bak.dmp tablespaces=common_cable full=y imp lztest6/lztest123@ora11 file=f:/bak.dmp tablespaces=common_cable full=y imp lztest9/lztest123@ora11 file=f:/bak.dmp tablespaces=common_cable full=y imp lztest5/lztest123@ora11 file=f:/bak.dmp tablespaces=common_cable full=y   imp lztest4/lztest123@ygsyt file=f:/bak.dmp tablespaces=common_cable full=y imp lztest5/lztest123@ygsyt file=f:/bak.dmp tablespaces=common_cable full=y imp lztest8/lztest123@ygsyt file=lztest7.dmp tablespaces=common_cable full=y imp lztest6/lztest123@ygsyt file=lztest6.dmp tablespaces=common_cable full=y       exp lztest/lztest123@xgll123 file=f:\lztest6.dmp grants=y; exp lztestorcl/lztest123@xgll123 file=f:\lztest6.dmp grants=y;     exp lztest/lztest123@orcl file=f:\lztest6.dmp grants=y; exp lztestorcl/lztest123@orcl file=f:\lztest6.dmp grants=y;     exp lztz/lztz123@xgll123 file=f:\lztz.160314.2.dmp grants=y; exp lztest50/lztest123@xgll123 file=f:\lztest50.dmp grants=y; imp lztest1/lztest123@orall file=f:/li/lztest.dmp full=y; imp lztest50/lztest123@1112 file=e:/lztest12345.dmp full=y;   exp lztest50/lztest123@123 file=E:\lztest50.dmp grants=y; imp lztest51/lztest123@316 file=E:\lztest50.dmp  full=y; imp lztz51/lztz123@316 file=E:\lztz50.dmp  full=y;   imp lztz52/lztz123@316 file=E:\lztz50.dmp  full=y;     imp lztest53/lztest123@316 file=E:\lztest50.dmp  full=y; imp lztest55/lztest123@316 file=E:\lztest50.dmp  full=y;   imp lztest55/lztest123@orcl file=F:\lztest123456.dmp  full=y; imp lztest88/lztest123@orcl file=F:\lztest320.dmp  full=y;   imp gas_lztz/gas123@316 file=D:\lztz54.dmp  full=y;     create user lztest88 identified by lztest123; grant connect ,resource,dba to lztest88;   alter user lztest88 default tablespace COMMON_CABLE; exp lztz50/lztz123@orcl file=/home/oracle/lztz320.dmp grants=y; exp lztz50/lztz123@ORA123 file=f:\lztz321.dmp grants=y;   exp lztz50/lztz123@orcl file=/home/oracle/lztz321.dmp grants=y;

DB基本操作（oracle）

标签：