expdb And exp The exported data is different ,exp Unable to export null table , For clients ,expdb Only for the server side . The backup data can be transferred to another remote station linux Realize remote backup !

One   About expdp and impdp     Use EXPDP and IMPDP What should be paid attention to when :
EXP and IMP Is a client utility , They can be used on the client side , It can also be used on the server .

EXPDP and IMPDP It is the tool program of the server , They can only be in ORACLE Server use , Can't use... On the client side .

IMP Only applicable to EXP Exported files , Do not apply to EXPDP export file ;IMPDP Only applicable to EXPDP Exported files , Not applicable to EXP export file .

expdp or impdp On command , Don't indicate the user name for the moment / password @ Instance name as identity , And then type... According to the prompt , Such as :
expdp schemas=scott dumpfile=expdp.dmp DIRECTORY=dpdata1;

One 、 Create a logical Directory , This command does not create a real directory on the operating system , Best to system Wait for the administrator to create .
create directory dpdata1 as 'd:\dump';

Two 、 Check the administrator Directory ( At the same time, check whether the operating system exists , because Oracle It doesn't matter if the directory exists , If it doesn't exist , You make a mistake )
select * from dba_directories;

3、 ... and 、 to scott The user gives the operation authority in the specified directory , Best to system Wait for the administrator to give .
grant read,write on directory dpdata1 to scott;

Four 、 Derived data
1) According to the user guide
expdp scott/[email protected] schemas=scott dumpfile=expdp.dmp DIRECTORY=dpdata1;

2) Import the entire database
expdp system/manager DIRECTORY=dpdata1 DUMPFILE=full.dmp FULL=y;

5、 ... and 、 Restore data
1) Import to the specified user
impdp scott/tiger DIRECTORY=dpdata1 DUMPFILE=expdp.dmp SCHEMAS=scott;

notes : If there are already expdb Derived dmp file ( This file is exported from other server data ), To import a database on your own server , You need to set up a database on your own server first directory( Catalog ), After the directory is created, there is no real folder. You need to create this folder manually , After creating this folder, put expdb Lead out dmp Put the files in this folder , Re execution   dos command ------   impdp hecv/000000 schemas=hecv directory=dphecv dumpfile=hecvdata.DMP     You can import the data to the server database

2) Import database
impdb system/manager DIRECTORY=dump_dir DUMPFILE=full.dmp FULL=y;

Additional content :

0. Connect to remote server
1. export
expdp rdyslw/rdyslw directory=expdp_dir dumpfile=rdyslw.dmp logfile=rdyslw_1018.log schemas=rdyslw
2. Sign in sqlplus / as sysdba;
Create folder create or replace directory expdp_dir as 'e:\';-- In the future, we have to pass expdp_dir To visit e: Files on disk
3. Create tablespace
create tablespace rdyslw --[ also rdjddb]
datafile 'C:\oraclexe\app\oracle\oradata\XE\rdyslw.dbf' 
size 50m 
autoextend on 
next 50m maxsize 20480m 
extent management local; 
4. Create user create user rdyslw identified by rdyslw 
default tablespace rdyslw;
5. to grant authorization grant connect,resource,dba to rdyslw; Folder Access grant read,write on directory expdp_dir to rdyslw;

5. Import impdp rdyslw/rdyslw directory=expdp_dir dumpfile=RDYSLW.DMP logfile=rdyslw.log schemas=rdyslw table_exists_action=replace

oracle database Export and import expdb and impdb Usage method ( Server local ) More articles about

  1. utilize PL/SQL from Oracle Database export and import data

    from :https://www.jb51.net/article/109768.htm This article is an example for you to share PL/SQL from Oracle How to export and import data from database , For your reference , The details are as follows 1. Derived number ...

  2. oracle Database export and import

    One . Query the character set of the exported Library 3 individual 1. Inquire about oracle server Character set at the end SQL>select userenv('language') from dual; USERENV('LANGUAGE ...

  3. oracle How to export and import database tables

    oracle How to export and import database tables oracle How to export a table in a project and import it into your own database , This is a complete operation , For database backup or local view of data, verify the data , I usually use it dos Black window operation , Jane ...

  4. oracle How to export and import database / surface

    oracle How to export and import database / surface oracle How to export a table in a project and import it into your own database , This is a complete operation , For database backup or local view of data, verify the data , I usually use it dos Black window operation , ...

  5. Case scenario -- In a Oracle Database export EXP-00008;ORA-00904:EXP-00000: oracle Different versions of import and export rules

    Case scenario -- In a Oracle Database export : C:\Documents and Settings\Administrator>exp lsxy/[email protected]_db file=E:\lsx ...

  6. take Oracle The database is exported to txt Format

    take Oracle The database is exported to txt Format : Method 1: about Windows System , It can be done in the following ways : Select the control panel --> Management tools --> data source (ODBC), Add a new data source ( System or user DSN All possible ) ...

  7. mysql Database and oracle Databases import and backup each other

    Take from Oracle The data exported from the database is imported into MySql In the database 1. Use the default end symbol to import into MySql In the database :    LOAD DATA LOCAL INFILE 'd:/oracle.txt' IGNO ...

  8. oracle Import and export of database tables cmd The command of

    In the actual project development, we often encounter import and export oracle Tables in the database , Here are some of the common cmd command : One . Export of data table 1 Will database TEST Completely export , user name system password manager Export to D:daoch ...

  9. oracle Database simple import and export operation

    One . Database export 1. Export user name / password ,, The export user name is test_expdp. The default export path is oracle Medium dpdump In file expdp test_expdp/[email protected] direc ...

Random recommendation

  1. How to be in java In this paper, we discuss the fitting normal distribution

    Preface Recently, we need to fit Gaussian curve in our work , stay python Can be used in scipy, The relevant code is as follows : #!/usr/bin/env python # -*- coding=utf-8 -*- %matplotli ...

  2. start-up MFC Error in the program :0xC0000005: Read location 0x00000000 Access conflict occurred when

    The structure of this program is MouseCap.h #pragma once #include <afxwin.h> class MouseCapApp : public CWinApp { publi ...

  3. DOM4J Read XML Configuration file for database connection

        introduce DOM4J.     It's said to be very good, very good Java XML  API(Dom4j is an easy to use, open source library for working ...

  4. Minimum cost and maximum flow MCMF zkw Cost stream

    The sparse graph is so slow ... But the dense image is still very good struct MCMF{ struct tedge{int x,y,cap,w,next;}adj[maxm];int ms,fch[maxn]; int ...

  5. Java The way to learn :jdk Environment variable configuration method

    JDK(Java Development Kit) As a whole Java At the heart of , Contains Java execution environment .Java Tools and Java Base class library .JDK As JAVA Development environment , Whether it's doing JAVA Development or Android development , Must be ...

  6. Embrace the big family ,nodejs go thrift

    Embrace the big family ,nodejs go thrift. The cheapest example ,nodejs And nodejs Go between thrift To pass on . 1, Download from the official website http://mirrors.cnnic.cn/apache/thrift/0.9 ...

  7. Remember a Spring aop The problems we're having

    origin The project needs to realize the function of pushing an order to a third party after its status changes , Because the item in the changed state and the pushed item are not the same item , So in order not to change the code of the original project , We are thinking about using spring Of aop To achieve . The project uses spring ...

  8. python Basic course ( Ten )

    Magic methods . attribute ------------------------ preparation To make sure the class is new , Should put the  _metaclass_=type  Go to the beginning of your module . class NewType(Objec ...

  9. sentence 、 Variable etc. js The most basic knowledge

    JavaScript The most basic knowledge of 1 grammar js It's case sensitive : An identifier is a variable . function . The name of the property or the parameter , The identifier can be a letter , Underline , Dollar symbol , Numbers , Note that the first one can't be a number :js It's hump size format : ...

  10. use Markdown Write a front-end resume

    1. essential information full name :xxx Phone number :1380000xxxx School : Nanchang University Education : University degree / master / Doctor Work experience :3 In the above Web front end E-mail :[email protected] 2. Employment intention Work ...