Shulou(Shulou.com)05/31 Report--

Editor to share with you how to achieve oracle database import .dmp script sql statements, I believe that most people do not know much, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Change the sys/system password of the database administrator

1. Run to the root directory of C disk

Enter: SET ORACLE_SID = your SID name

3. Input: sqlplus / nolog

4. Input: connect / as sysdba

5. Input: altre user sys identified by sys

6. Input: altre user system identified by system

After completion, the password of system is system.

Import database (.dmp)

(run under sqlplus)

1. Create a tablespace

Create tablespace bjshelldb datafile'D:\ app\ Administrator\ oradata\ orcl\ bjshell01.dbf' size 3000m autoextend on

2. Create a user

Create user BJSHELL identified by 111111 default tablespace bjshelldb

3. User authorization

Grant connect,resource,create view to BJSHELL;grant dba to BJSHELL;grant imp_full_database to BJSHELL;grant connect,resource to BJSHELL

4. Import: (run under cmd)

Imp BJSHELL/111111 file=E:\ db\ CRM-20160921.dmp log=E:\ db\ CRM-20160921.log buffer=8000000 commit=y full=y

5. Delete a user

Drop user BJSHELL cascade

6. Delete tablespace

DROP TABLESPACE bjshelldb INCLUDING CONTENTS AND DATAFILES

7. Export oracle database (.dmp) remotely

Exp username / password @ IP of remote oralce database: Port number / instance file= location:\ file name. Dmp full = y

The above is all the contents of the article "how to import the sql statement of .dmp script into oracle database". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.