Oracle user-based backup and recovery

Source: Internet
Author: User
To execute the exp or imp command, first: 1.check that there are no exp.exeand imp.exe files in the bindirectory of the oracleinstallation directory. Otherwise, the command may fail to be executed.

To execute the exp or imp command, first: 1. check whether there are exp.exe and imp.exe files in the bin directory of the Oracle installation directory. Otherwise, the command may fail to be executed.

To execute the exp or imp command, first:

1. Check whether exp.exe and imp.exe files exist in the bin directory of the Oracle installation directory. Otherwise, the command may fail to be executed.

2. Alternatively, you can directly enterIn the bin directory of the dos oracle installation directory>EXPUsername/pwd BUFFER = 64000 FILE = D: \ orcldata \ test_full201110241059.dmp OWNER = username
Check whether the file can be executed. If yes, the two files are not required. I don't have imp.exe, And I can export it.

Exp, imp

Basic syntax and example:
1. EXP:
There are three main methods (complete, user, table)
1. Complete:
Exp system/manager buffer = 64000 FILE =/oracle/ora10/backup/FULL. dmp full = Y
To perform full export, you must have special permissions.Here, I tried to use sys and system users and reported an error (however, sys and system users can log on as DBAs in pl/SQL, which is unknown for the moment ):

Username: sys
Password:

EXP-00056: ORACLE error 28009
ORA-28009: connection as SYS shocould be as SYSDBA or SYSOPER
User name: system
Password:

EXP-00056: ORACLE error 1017
ORA-01017: invalid username/password; logon denied

2. User Mode: (generally, you can use the user mode)
EXP username/pwd BUFFER = 64000 FILE = D: \ orcldata \ test_full201110241059.dmp OWNER = username
In this way, all user username objects are output to the file. (Note: use relative path/and absolute path \)
3. Table mode:

Exp sonic/sonic buffer = 64000 FILE =/oracle/ora10/backup/SONIC. dmp owner = sonic tables = (SONIC)
In this way, the SONIC table is exported.
2. IMP:
Three modes are available (full, user, and table)
1. Complete:
Imp system/manager buffer = 64000 FILE =/oracle/ora10/backup/FULL. dmp full = Y
2. User Mode:
Imp sonic/sonic buffer = 64000 FILE =/oracle/ora10/backup/SONIC. dmp fromuser = sonic touser = SONIC
In this way, all the SONIC objects are imported into the file. You must specify the FROMUSER and TOUSER parameters to import data.
3. Table mode:
Exp sonic/sonic buffer = 64000 FILE =/oracle/ora10/backup/SONIC. dmp owner = sonic tables = (SONIC)

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.