oracle11g服务端和客户端请务必使用 11203版或11204版本的oracle服务端!!!
安装前,请确保系统已经安装 .Net 3.5
CREATE TABLESPACE "DATA01"
LOGGING
DATAFILE 'C:\ora_ts\DATA01_1.dbf' SIZE 256M AUTOEXTEND ON NEXT 8192K MAXSIZE UNLIMITED,
'C:\ora_ts\DATA01_2.dbf' SIZE 256M AUTOEXTEND ON NEXT 8192K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "DATA02"
LOGGING
DATAFILE 'C:\ora_ts\DATA02_1.dbf' SIZE 256M AUTOEXTEND ON NEXT 8192K MAXSIZE UNLIMITED,
'C:\ora_ts\DATA02_2.dbf' SIZE 256M AUTOEXTEND ON NEXT 8192K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "INDEX01"
LOGGING
DATAFILE 'C:\ora_ts\INDEX01_1.dbf' SIZE 256M AUTOEXTEND ON NEXT 8192K MAXSIZE UNLIMITED,
'C:\ora_ts\INDEX01_2.dbf' SIZE 256M AUTOEXTEND ON NEXT 8192K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
以上语句意思是:在C:\ora_ts文件夹里,创建初始空间大小为256M的数据表空间及索引
create user MD61 identified by MD61
default tablespace data01
temporary tablespace temp
quota 0 on system
quota unlimited on data01
quota unlimited on data02
quota unlimited on index01;
Grant CONNECT,RESOURCE,dba TO MD61;
以上语句意思是:创建数据库用户 MD61,并授予其CONNECT,RESOURCE,dba 权限!
Imp MD61/MD61@172.31.13.211:1521/MD61 file=D:\home\MD61.DMP log=D:\home\MD61.LOG fromuser=MD61 touser=MD61 grants=N ROWS=y commit=y
以上语句意思是:用MD61用户访问172.31.13.211:1521/MD61数据库,并导入D:\home文件夹下MD61.DMP 数据库数据 到MD61用户下!!!