一般来说,用脚本比较好。 简单说说 1、表空间创建.sql 如CREATE TABLESPACE "YD_BLOB" LOGGING DATAFILE 'D:\oracle\oradata\aaa\YD_BLOB01.dbf' SIZE 500M REUSE AUTOEXTEND ON NEXT 500M MAXSIZE 16383M EXTENT MANAGEMENT LOCAL / 2、用户创建.sql CREATE USER "DBO" PROFILE "DEFAULT" IDENTIFIED BY "ORACLE" DEFAULT TABLESPACE "YD_DATA" TEMPORARY TABLESPACE "YD_TEMP" ACCOUNT UNLOCK;GRANT "DBA" TO "DBO"; GRANT "EXP_FULL_DATABASE" TO "DBO"; GRANT "IMP_FULL_DATABASE" TO "DBO"; GRANT "RESOURCE" TO "DBO"; ALTER USER "DBO" DEFAULT ROLE ALL;…… 3、用户授权.sql 4、建表。
http://blog.csdn.net/kinglht
简单说说
1、表空间创建.sql
如CREATE TABLESPACE "YD_BLOB"
LOGGING
DATAFILE 'D:\oracle\oradata\aaa\YD_BLOB01.dbf' SIZE 500M REUSE
AUTOEXTEND
ON NEXT 500M MAXSIZE 16383M EXTENT MANAGEMENT LOCAL
/
2、用户创建.sql
CREATE USER "DBO" PROFILE "DEFAULT"
IDENTIFIED BY "ORACLE" DEFAULT TABLESPACE "YD_DATA"
TEMPORARY TABLESPACE "YD_TEMP"
ACCOUNT UNLOCK;GRANT "DBA" TO "DBO";
GRANT "EXP_FULL_DATABASE" TO "DBO";
GRANT "IMP_FULL_DATABASE" TO "DBO";
GRANT "RESOURCE" TO "DBO";
ALTER USER "DBO" DEFAULT ROLE ALL;……
3、用户授权.sql
4、建表。