从数据库新建到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
页:
[1]