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_CABLEdatafile ‘E:/COMMON_CABLE.dbf‘   size 1500M   autoextend on next 5M maxsize 3000M;  匯出資料庫exp lztest/[email protected] file=lztest.dmp grants=y;exp lztest7/[email protected] file=lztest7.dmp grants=y;exp lztest6/[email protected] file=lztest6.dmp grants=y;exp lztest5/[email protected] file=lztest5.dmp grants=y; exp lztest6/[email protected] file=f:\lztest6.dmp grants=y;  imp lztest3/[email protected] file=f:\lztest6.dmp tablespaces=common_cable full=y;  匯入資料庫不需要到檔案的目錄，使用預設的目錄imp lztest1/[email protected] file=f:/li/lztest.dmp full=y;imp lztest4/[email protected] file=f:\bak.dmp tablespaces=common_cable full=y;imp lztest8/[email protected] file=f:\bak.dmp tablespaces=common_cable full=y;imp lztest21/[email protected] file=f:\lztesty.dmp tablespaces=common_cable full=y;imp lztest21/[email protected] file=f:\lztesty.dmp tablespaces=common_cable full=y; Microsoft Windows [版本 6.1.7600]著作權 (c) 2009 Microsoft Corporation。著作權所有，並保留一切權利。 C:\Users\Administrator>imp lzcable/[email protected] file=f:/lztestBAK.dmp tablespaces=common_cable full=yimp lztest8/[email protected] file=f:/bak.dmp tablespaces=common_cable full=yimp lztest7/[email protected] file=f:/bak.dmp tablespaces=common_cable full=yimp lztest6/[email protected] file=f:/bak.dmp tablespaces=common_cable full=yimp lztest9/[email protected] file=f:/bak.dmp tablespaces=common_cable full=yimp lztest5/[email protected] file=f:/bak.dmp tablespaces=common_cable full=y imp lztest4/[email protected] file=f:/bak.dmp tablespaces=common_cable full=yimp lztest5/[email protected] file=f:/bak.dmp tablespaces=common_cable full=yimp lztest8/[email protected] file=lztest7.dmp tablespaces=common_cable full=yimp lztest6/[email protected] file=lztest6.dmp tablespaces=common_cable full=y   exp lztest/[email protected] file=f:\lztest6.dmp grants=y;exp lztestorcl/[email protected] file=f:\lztest6.dmp grants=y;  exp lztest/[email protected] file=f:\lztest6.dmp grants=y;exp lztestorcl/[email protected] file=f:\lztest6.dmp grants=y;  exp lztz/[email protected] file=f:\lztz.160314.2.dmp grants=y;exp lztest50/[email protected] file=f:\lztest50.dmp grants=y;imp lztest1/[email protected] file=f:/li/lztest.dmp full=y;imp lztest50/[email protected] file=e:/lztest12345.dmp full=y; exp lztest50/[email protected] file=E:\lztest50.dmp grants=y;imp lztest51/[email protected] file=E:\lztest50.dmp  full=y;imp lztz51/[email protected] file=E:\lztz50.dmp  full=y; imp lztz52/[email protected] file=E:\lztz50.dmp  full=y;  imp lztest53/[email protected] file=E:\lztest50.dmp  full=y;imp lztest55/[email protected] file=E:\lztest50.dmp  full=y; imp lztest55/[email protected] file=F:\lztest123456.dmp  full=y;imp lztest88/[email protected] file=F:\lztest320.dmp  full=y; imp gas_lztz/[email protected] 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/[email protected] file=/home/oracle/lztz320.dmp grants=y;exp lztz50/[email protected] file=f:\lztz321.dmp grants=y; exp lztz50/[email protected] file=/home/oracle/lztz321.dmp grants=y;

DB基本操作（oracle）