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

healthandbeauty

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