从数据库新建到dmp导入汗了一天

最新推荐文章于 2022-06-09 16:55:35 发布

healthandbeauty

最新推荐文章于 2022-06-09 16:55:35 发布

阅读量104

点赞数

分类专栏： oracle 文章标签： SSH Oracle Java C C++

本文链接：https://blog.csdn.net/healthandbeauty/article/details/83907344

版权

oracle 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

1:新建个数据库实例
2：执行 C:\>netca[color=red]（若数据库实例没有监听的话）[/color]
3：创建表临时表空间

create temporary tablespace ssh_temp   

tempfile 'D:\oracle\product\10.2.0\oradata\ssh\ssh_temp.dbf'  

size 50m   

autoextend on   

next 50m maxsize 20480m   

extent management local;

4：创建表空间

create tablespace ssh_data   

logging   

datafile 'D:\oracle\product\10.2.0\oradata\ssh\ssh_data.dbf'  

size 50m   

autoextend on   

next 50m maxsize 20480m   

extent management local;

5：创建用户

create user netinvoice12 identified by password   

default tablespace ssh_data   

temporary tablespace ssh_temp;

6：分配权限

GRANT CONNECT TO netinvoice;
  GRANT DBA TO netinvoice;
  GRANT RESOURCE TO netinvoice;
  GRANT UNLIMITED TABLESPACE TO netinvoice;

7:导入dump

imp netinvoice/netinvoice@ssh file=C:/Users/forrest/Desktop/requet/netinvoice_20110412最后库.dmp full=y

总结：

create temporary tablespace ssh_temp   

tempfile 'D:\oracle\product\10.2.0\oradata\ssh\ssh_temp.dbf'  

size 50m   

autoextend on   

next 50m maxsize 20480m   

extent management local;   


create tablespace ssh_data   

logging   

datafile 'D:\oracle\product\10.2.0\oradata\ssh\ssh_data.dbf'  

size 50m   

autoextend on   

next 50m maxsize 20480m   

extent management local;  


create user netinvoice12 identified by password   

default tablespace ssh_data   

temporary tablespace ssh_temp;  


GRANT CONNECT TO netinvoice;
  GRANT DBA TO netinvoice;
  GRANT RESOURCE TO netinvoice;
  GRANT UNLIMITED TABLESPACE TO netinvoice;


imp netinvoice/netinvoice@ssh file=C:/Users/forrest/Desktop/requet/netinvoice_20110412最后库.dmp full=y