Imp testwms3/[email protected] file=c:\zkgl_201407012334.dmp ignore=y FROMUSER=GMMCZKGL touser=testwms tables= ( GMMCZKGL.T_KDTTRCKTZ)
Imp testapar/[email protected] file=c:\cwysyf_201511292330.dmp ignore=y FROMUSER=GMMCCWYSYF touser=testapar tables= ( Gmmccwysyf.t_chnpartspay)
Imp gmmczk/[email protected] file=c:\zkgl_201407012334.dmp ignore=y fromuser=gmmczkgl touser=gmmczk tables= (GMMCZKGL. Xxxx,gmmczkgl. XXXX)
Exp Gmmccwysyf/[email protected] file=gmmcfm.dmp log=exp.log OWNER=GMMCCWYSYF
Exp Gmmccwysyf/[email protected] file=cwysyf_201307022330.dmp log=exp.log OWNER=GMMCCWYSYF
Create user TESTWMS3 identified by ISC default Tablespace USR_TBLSP;
Grant CONNECT,RESOURCE,DBA to Testwms3;
Alter user TESTWMS3 account unlock;
Oracle Import and Export command
Sqlplus Gmmccwysyf/[email protected]
Exp Gmmccwysyf/[email protected] file=gmmccw_banfan_20130311.dmp OWNER=GMMCCWYSYF
Imp testapar/[email protected] file=cwysyf_201307022330.dmp FROMUSER=GMMCCWYSYF touser=testapar commit=y
EXPDP Testpoi2/[email protected] file=mytestpoi2dp.dmp Owner=testpoi2
IMPDP Testpoi2/[email protected] file=mytestpoi2dp.dmp fromuser=testpoi2 touser=testpoi2 commit=y
Exp Gmmczkgl/[email protected] file=gmmczk_banfan_20130618.dmp OWNER=GMMCZKGL
Imp gmmczk/[email protected] file=gmmczk_banfan_20121126.dmp FROMUSER=GMMCZKGL TOUSER=GMMCZK commit=y
Sqlplus Sys/[email protected] as SYSDBA
Sqlplus login
Sqlplus sys/[email protected] as SYSDBA
Create users
Create user Testpoi3 identified by ISC
account unlock;
Grant Dba,advisor to Testpoi2;
Delete users
drop user DJCFW cascade;
Data export
Exp testwms2/[email protected] OWNER=TESTWMS2 FILE=D:\TEMP\TESTWMS2.DMP
Exp testapar/[email Protected] Owner=testapar file=d:\testwms2.dmp tables=dept
Instance:
nohup exp parfile=xxxx.par &
Xxxx.par (command too long with file)
Exp testwms2/[email protected] buffer=409600 file=d:\temp\testwms2.dmp,d:\temp\ Testwms3.dmp direct=y tables=**,**,** (Guide table) filesize=30g (file size, single file too large to affect import performance) Log=d:\temp\111.log
Data import
Imp Testapar/[email protected] File=d:\dbbackup\cwysyf_201501260938.dmp ignore=y FROMUSER=GMMCCWYSYF touser= Testapar
Imp test/isc file=d:\ job related \ Work history \ Daily work \ 20,150,601 weeks \dbbackup\ddzs_201502052320.dmp direct=y table=order_info Ignore=y Fromuser=gmmcddzs touser=test
The object that will export FM ...
Sqlplus "/as sysdba"
Conn/as SYSDBA
Confirm Oracle Installation Status: Select Status from V$instance; (dynamic table)
Close: Shutdown immedate
Open: Startup;
View database name: Show parameter (view parameters) db_name
Select USERNAME from dba_users where username= ' SCOTT ';
Oracle Import and Export data dmp