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

1:新建个数据库实例
2：执行 C:\>netca（若数据库实例没有监听的话）
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