oracle导入本地dmp文件

最新推荐文章于 2023-10-09 14:40:39 发布

Weakal

最新推荐文章于 2023-10-09 14:40:39 发布

阅读量640

点赞数

文章标签： oracle 数据库 sql

本文链接：https://blog.csdn.net/weixin_45223024/article/details/121227563

版权

C:\Users\hqbhonker>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 20 12:28:25 2013

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create tablespace QDII datafile ‘d:\1_workspace\QDHuaiTai.dbf’ size 2000m autoextend on next 100m extent management local;

Tablespace created.

SQL> create user huaitai identified by “1” default tablespace QDII;

User created.

SQL> grant resource,connect,dba to huaitai;

Grant succeeded.

SQL> connect huaitai/1
Connected.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

C:\Users\hqbhonker>imp huaitai/1 file=‘C:\Users\hqbhonker\Desktop\qdiifull20130909.dmp’ full=y