DB Basic Operations (Oracle)

Create user drop users lztest4 cascade;create user Lztest4 identified by lztest123;alter user Lztest4 default Tablespace common_cab Le;grant Connect, resource,dba to Lztest4; drop user lztest3 cascade;create user lztest3 identified by Lztest123;alte R user lztest3 default tablespace common_cable;grant Connect, resource,dba to lztest3;  set up users 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 table space Create tablespace Common_cabledatafile ' e:/common_cable.dbf '   size 1500M   autoextend on next 5M maxsize 3000M;    Export Database 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;   Import Database does not need to the directory of files, use the default directory 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 [version 6.1.7600] Copyright (c) Microsoft Corporation. All rights reserved.  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.dmpTablespaces=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&Nbsp;protected] file=f:\lztz321.dmp grants=y; exp lztz50/[email protected] File=/home/oracle/lztz321.dmp Grants=y;

DB Basic Operations (Oracle)