[Transferred from: http://space.itpub.net/519536/viewspace-631445]
When impdp is used to import a database, if a table already exists, Oracle provides the following four processing methods:A. Ignore (Skip, default Act );B. Add (append) based on the
Problem phenomenon:recently a user is ready to build a test environment, because the user's official library is the Aix small machine, the test environment is X86 platform, so only through the EXPDP for data export, but in the export, found that
1 table_exists_action parameter descriptionWhen importing data using IMP, if the table already exists, drop the table before importing.When using IMPDP to complete the database import, if the table already exists, there are four kinds of processing
1. Use expdp and impdp
Oracle Database 10 Gb introduces the latest data pump technology, the role of Data Pump Export Import (expdp and impdp)
1) implement logical backup and logical recovery.2) move objects between database users.3) move objects
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,
Use the Sample parameter of DataPump for data sampling.
Data Pump Datapump is a convenient data logical backup and restoration tool launched by Oracle. Compared with the traditional Exp/Imp, Datapump provides many advantages in both performance and
Use the copy function of DB_LINK to remotely back up and restore Data Using expdp and impdp. Delete the dept and emp of scott user on server B before testing.
Use the copy function of DB_LINK to remotely back up and restore Data Using expdp and
EXPDP and IMPDP are the newly added export and import capabilities of Oracle starting from 10g. Name is called data pump.
Expdp:data Pump ExportImpdp:data Pump Import
The difference between EXPDP, IMPDP and exp, imp
EXPDP, IMPDP:1, you can import
12c has launched a pluggable database with multiple database PDB in the form of multiple tenants in a single container cdb. The data pump import and export for the PDB is slightly different from the traditional database. 1, need to add tansnames for
Sometimes, in Django model, an ORM object that is queried directly to the JSON will have an error:
TypeError is not JSON serializable
def convert_to_builtin_type (obj):# print ' Default (', repr (obj), ') '# Convert objects to a dictionary of
After the VS 2008 is installed, in the background code, the ReSharper plugin prompts suggestions for all local variables in the background, displaying the need for "use implicitly typed variable declaration", and using the code to modify the
Array
In ECMAScript5, Array.isarray is the primary method of judging arrays, IE9 and above support. With compatibility in mind, in browsers without this method, you can use Object.prototype.toString.call (obj) = = ' [Object Array] ' instead.
Objects: Type, length
A. View type
1. Guess Trial and error
Is.fun form, return True or False
You can also judge the second level
2. Direct view
Class View the first level category, mode view the second level category, TypeOf view the
2. Implementation of DefineProperty and Definebinaryproperty methods
These two methods are virtual methods, which are abstract methods in Tfiler and have specific implementations in Treader and Twriter objects.
They are implemented in Treader as
2. Implementation of Twriter method
The realization of ⑴writelistbegin and writelistend
Both of these methods are used to write a number of consecutive values of the same type. Writelistbegin writes the VALIST flag, Writelistend writes to the
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.