create db 10g
If you can't read please download the document
DESCRIPTION
Create Db 10gTRANSCRIPT
CREATE DATABASE ORA10gLOGFILE GROUP 1('C:\oracle\product\10.2.0\admin\ora10g\db\redo01.log') SIZE 100M,GROUP 2('C:\oracle\product\10.2.0\admin\ora10g\db\redo02.log') SIZE 100M,GROUP 3('C:\oracle\product\10.2.0\admin\ora10g\db\redo03.log') SIZE 100MMAXLOGFILES 5MAXLOGMEMBERS 5MAXLOGHISTORY 1MAXDATAFILES 100MAXINSTANCES 1CHARACTER SET US7ASCIINATIONAL CHARACTER SET AL16UTF16DATAFILE 'C:\oracle\product\10.2.0\admin\ora10g\db\system01.dbf' SIZE 325MSYSAUX DATAFILE 'C:\oracle\product\10.2.0\admin\ora10g\db\sysaux01.dbf' SIZE 325MUNDO TABLESPACE UNDOTBSDATAFILE 'C:\oracle\product\10.2.0\admin\ora10g\db\UNDOTBS01.dbf' size 100Mdefault temporary tablespace temp tempfile 'C:\oracle\product\10.2.0\admin\ora10g\db\temp01.dbf' size 100M;create database ora10gcharacter set US7ASCIInational character set utf8undo tablespace undotbs1default temporary tablespace temp;oradim -new -srvc OracleServiceora10gORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE@?/rdbms/admin/catalog.sql@?/rdbms/admin/catproc.sql@?/rdbms/admin/catexp.sql@D:\oracle\product\10.2.0\db_1\rdbms\admin\catalog.sql@D:\oracle\product\10.2.0\db_1\rdbms\admin\catproc.sql@D:\oracle\product\10.2.0\db_1\rdbms\admin\catexp.sqlcreate tablespace data01 datafile 'C:\oracle\product\10.2.0\admin\ora10g\db\data01.dbf' size 100Mextent management local segment space management auto;create tablespace data01extent management local segment space management auto;create user scott identified by tigerdefault tablespace data01;grant connect,resource to stud1;@C:\oracle\product\10.2.0\db_1\sqlplus\admin\pupbld.sqlORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZEora10g= (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = WIN7PC)(PORT = 2001)) ) ) )SID_LIST_ora10g= (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (PROGRAM = extproc) ) ( SID_DESC = ( SID_NAME=ora10g) ( ORACLE_HOME = D:\oracle\product\10.2.0\db_1) ) )ora10g = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = WIN7PC)(PORT = 2001)) ) (CONNECT_DATA = (SERVICE_NAME = ora10g) ) )