Oracle database Import and Export 09192255

1 , Import Database (DMP )

In Linux systems:

1. Log in to the server with the root account and switch to the Oracle account (the account used to install the Oracle database)

2. Switch to Oralce under the bin under the installation directory

3, enter:./sqlplus/nolog

4. Input: Conn Iflytek/iflytek as Sysdba

5. CREATE TABLE space:

Create tablespace mobileserver datafile '/opt/oracle/app/oradata/orcl/mobileserver.dbf ' size 80m autoextend on next 10m m Axsize 5000m;

Where Tablespace Mobileserver is required for the database to be imported and can be viewed in the DMP package

6. Create user and authorize:

Create user xingnengtest identified by Iflytek default Tablespace mobileserver;

Grant Dba,connect,resource Xingnengtest;

Grant Connect,resource to Xingnengtest;

Grant unlimited tablespace to Xingnengtest;

Grant CREATE database link to xingnengtest;

Grant Select any sequence,create materialized view to Xingnengtest;

Note: If the permissions are insufficient, the import will prompt, specific needs those permissions, I do not have one by one authentication

7. Import DMP

? Input: Quit, disconnect Oracle connection

? Input: Imp

? Input account: Xingnengtest

? Enter Password: Iflytek

? Enter the command and enter the DMP address

? Tips when you are done

8, Plsql Connection database view

? Configuring monitoring

? Enter your account password

? View table, which is the imported tables and data

Oracle database Import and Export 09192255