Oracle Import and Export data dmp

Source: Internet
Author: User
Tags dba sqlplus

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.