tablespace in the tablespace or its index is moved, an error message is displayed. when it is set to N, the export function only checks single-ended dependencies. If the index's tablespace is moved but the table's tablespace is not moved, the error message is displayed. If the table's tablespace is moved, if the tablespace where the index is not moved, no error message is displayed.
26. TRANSPORT_TABLESPACESSpecify the execution tablespace mode for export
27. VERSIONSpecifies the database versi
The data pump is a server tool, and the exported files are stored on the server where the database is located. Of course, we know that the files can be controlled through directory objects. The directory object has four levels by default. Of course, there is a priority order. The priority is from top to bottom 1. specify a specific directory for each file. when expdp is exported, the specified DIRECTORY parameter 3. the directory specified by the user
The following is an example, modified according to the actual situation--The following is the format of the date timeEXPDP Ha_soar/[email protected] Schemas=wyzj directory=data_pump_dir dumpfile=wyzj%date:~0,4%%date:~5,2%%date:~8,2% %time:~0,2%%time:~3,2%.dmp Logfile=wyzj%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%.log--Date formatEXPDP System/[email protected] schemas=wyzj directory=data_pump_dir dumpfile=wyzj_%date%.dmp logfile=WYZJ_%DATE%.logData
According to Oracle's documentation, the data pump in different ways to export imports, performance can be significantly different, this time just have the opportunity to test, migration table space, direct path, external table, and database chain export, import performance differences.
First check that the table space of the source database satisfies the self contained condition:
Sql> EXEC Dbms_tts. Transport_set_check (' tjsq,tjsq_tmp ')
Pl/sql p
.
Dumpfile=temp. DMP:TEMP.DMP is the data pump file you want to import.
Reuse_dumpfiles=y: This parameter is removed when imported.
Schemas= (bfb2c,trans_user,bfcrm,bfstatuser): The database instance to import, now I just import the first one, so
Schemas= (BFB2C) is OK.
If the export and import is not the same database, to use the REMAP_SCHEMA=A:B parameter, when you export data from a user, want to import to B users, use this: Remap_schema=a:b.
Logfi
For data pump EXPDP/IMPDP, the function is much stronger than the ordinary exp/imp function, so it is difficult to accomplish some common export import tools.
For example, the problem that comes up today is to export some tables, but the individual tables only export the structure without exporting the data.
Sql> Conn Test/test
Connected.
Sql> Set Pages Lines 120
Sql> Select COUNT (*) from T;
COUNT (*)
----------
23
Sql> Select COUNT (*) from
Tags: OracleFirst, prepare the target database1. Ensure that the target database's character set Nls_characterset and the source database are consistentSELECT * FROM Nls_database_parameters2. Create a database table space to migrateSelect Tablespace_name from Dba_tablespacesCreate tablespace bbgodb datafile ' +data_vg ' size 300m autoextend on3, create the corresponding schemaCreate user bbgo identified by bbgo default Tablespace bbgodbGrant Connect,resource to Bbgo4. Create a directory and auth
User: EXPDP system/[emailprotected] directory= Expdp_dir dumpfile=0526netobdc.dmp logfile=0526netobdc.log SCHEMAS=NETOBDC 2) Export by table name: EXPDP system/[email Protected] Directory=expdp_dir dumpfile=0526netobdc.dmp logfile=0526netobdc.log tables=emp,dept 3) export entire database: EXPDP System/[emailprotected] Directory=expdp_dir dumpfile=0526netobdc.dmp logfile=0526netobdc.log FULL=y Iv. Import1. Create a logical directory that does not create a real directory in the operating system
-production on Mon Jan 5 10:26:09 2015Copyright (c) 1982, the Oracle and/or its affiliates. All rights reserved.Connected to:oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production with the partitioning, OLAP, Da Ta Mining and Real Application testing optionsOra-39001:invalid argument valueOra-39000:bad dump file specificationOra-39142:incompatible version number 4.1 in dump file "/home/oracle/desktop/test/expiirspublish20141117.dmp "Source-side database version 12c, target da
1, export the name of a table (here will export sequences and function and other content)EXPDP Test/test@orcl schemas=Test DumpFile=test.dmp DIRECTORY=Db_bak EXCLUDE=TABLE: \ "not in \ (\'a\') \"2, export the name is not a table (remove not and we are accustomed to the exact opposite)EXPDP Test/test@orcl schemas=Test DumpFile=test.dmp DIRECTORY=Db_bak EXCLUDE=TABLE: \ "in \ (\'a\') \"3, import the name of a table (here will import sequences and function and other content)IMPDP Test/test@orcl DIR
Tags: command line file space log using view import parameter HTTP--Reference http://www.lanstonwu.com/using-datapump-export-and-import-data/ First, pre-preparation 1. telnet to the server in SSH and locate the intermediate file (. DMP) stored in the directory: /*rmdir/home/oracle/pump_dir--Delete Empty directory */ 2. Create a logical directory with Administrator Sys Create or replace directory Pump_dir as '/home/oracle/pump_dir '; 3. Give user users permission to operate in the specified dire
-----------------------------------------------BttestSql>--use EXPDP to export the remote database to a local folder D:\oracle\bfzg0828.dmpC:\USERS\ADMINISTRATORGT;EXPDP Bfzg0828/[email protected] directory=dir_exp dumpfile=bfzg0828.dmp logfile= Bfzg0828.log network_link=test113--After successful export, import to local library using IMPDP--Here is the new user Bfzg user, has the Connect,resouce role permission, Table_exists_action=replace said, assuming the table exists is replaced, IMP has no
Label:From a library user UA guide data to B library user UB1. ExportEXPDP ua/[email protected]/orcl schemas=ua directory=data_pump_dir dumpfile=ua.dmp logfile=ua.logSchemas the list of scenarios to export, unspecified Shime considers the current logged on user scenarioDefault in Data_pump_dir When directory is not specified, can be queried by select * from Dba_directoriesThis machine has the installation of Oracle, can be executed directly in CMD, the command executes after the DMP file is gene
According to Oracle's documentation, the data pump in different ways to export imports, performance can be significantly different, this time just have the opportunity to test, migration table space, direct path, external table, and database chain export, import performance differences.
This test network_link how to import.
First clear the user and tablespace imported from the previous article, and re-establish the test user and tablespace.
sql> DR
written in front of the words:
See the title so long may be a little crazy, yes, I just learned this article when there are some do not understand, what is the layout of the pump? Edit each template then what is a custom adapter? Below we begin to learn the content of this article
Preferred previous picture to achieve effect:
Logical parsing:
First of all, the above diagram is the final implementation of the effect, a bit like our contacts cont
Tags: des c code TAR ext aSituations in which Direct Path Load are not usedIf any of the following conditions exist for a table, then Data Pump uses external tables rather than direct path to load The data for that table:
A global index on multipartition tables exists during a single-partition load. This includes object tables is partitioned.
A domain index exists for a LOB column.
A table is in a cluster.
There is an active trigger on a
as needed, in the format of Expcases_nn.dmp, where nn starts from 01 and then increases as needed.In parallel mode, the status screen displays four worker processes. (In the default mode, only one process is visible) all the worker processes synchronize the data out and display their progress on the status screen.It is important to separate the input/output channels that access the data files and dump the directory file system. Otherwise, the overhead associated with maintaining the data
Tags: process operations Database related methods Import Export error scheme IMPDPUsed to import and export data with IMP/EXP, now let's get a data pump import and export method. It is better than the imp/exp of the advantages of the way to say---faster!Unfortunately, I exported the data when the error, I wipe, this special is embarrassing. So, divine skill at first glance, brother Hong is good at solving the problem have wood?Yes? At first glance thi
Reprint Please specify source: http://blog.csdn.net/dongdong9223/article/details/47448751This article is from "I'm a fish-hook blog."
When importing data using the IMPDP data pump in Oracle, it is assumed that the user was created before the import, prompting the error: "ORA-31684: Object type already exists." Such as:In fact, this problem is not serious, can not create a user first, import when you specify a Super user import:impdp system/123456
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.