Oracle table partitioning, table analysis, and Oracle data Pump file Import and Export Happy edition

1, first say the Oracle table partition is what it, so we come to raise a peach, chestnut is too small, we do not lift, we come to give a peach.

You have 5 million documents, you're going to put him on disk, okay, we'll just have a folder, and a 5 million-point file is there, we want to find the one that opens, hey, we have to find out when.

At this point, a person tells you that you have files in different folders according to the specific rules, so you will find a lot.

Wow, suddenly you are enlightened, you say, yes, you are so good, why didn't I think of it? After the separation I am looking for the words will be much faster, so you are very happy, also very much to serve him. So you started to do it.

--This different folder is different partition, the file is certainly not the table data, how can the file be data?

Back to the text, so you just follow his words to start to set up folders, but you suddenly find out what the meaning Ah, I how to build folders (table partition) Ah, in fact, very simple, more simple than the query SQL.

It is important that you understand his concept and meaning.

Now let's talk about how to create it, and we need to build the partitions so that the data is automatically entered into the corresponding partition.

Then we generally build partitions are divided by the time partition, divided well, such as June data, we go to the June partition to find, rather than in all the table to find a piece of data, efficiency will improve a lot.

Partition statements are simple,

2. Table Analysis

3, Oracle data Pump file Export Import

Login to the Linux system, log in with the root user, su-oracle switch to Oracle user, orac;e do not need to switch.

Input SQLPLUS/ASSYSDBA Switch SQL window

SQL>SF dba_directories;--Query Path command

Sq>create or replace directory datapump as '/homeoracle/datapimp ' creates or replaces the backup path command

Determine if write permission is not available chmod 777

Export command: EXPDP \ '/as sysdba\ ' directory = datapump schemas=*** dumpfile=***.dmp content=all parallel=2 logfile = export.log--Whole Backup of a library

Oracle table partitioning, table analysis, and Oracle data Pump file Import and Export Happy edition