oracle create command
CREATE DATABASE "bbk"
        MAXDATAFILES 500
        MAXINSTANCES 8
        MAXLOGFILES 32
        CHARACTER SET "UTF8"
        NATIONAL CHARACTER SET AL16UTF16
        ARCHIVELOG
        DATAFILE
                '/u01/oradata/bbk/system01.dbf' size 300M
        EXTENT MANAGEMENT LOCAL
        DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/u01/oradata/bbk/tempts01.dbf' SIZE 100M
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE  '/u01/oradata/bbk/sysaux.dbf'
        UNDO TABLESPACE "UNDOTBS1"
        DATAFILE '/u01/oradata/bbk/undotbs01.dbf' SIZE 200M
        LOGFILE
GROUP 1(
        '/u01/oradata/bbk/redo01a.rdo',
        '/u01/oradata/bbk/redo01b.rdo'
       ) SIZE 100M,
GROUP 2 (
        '/u01/oradata/bbk/redo02a.rdo',
        '/u01/oradata/bbk/redo02b.rdo'
        ) SIZE 100M,
GROUP 3(
        '/u01/oradata/bbk/redo03a.rdo',
        '/u01/oradata/bbk/redo03b.rdo'
      ) SIZE 100M
;
spool off
 
                    
                     
                    
                 
                    
                 
                
            
         
         浙公网安备 33010602011771号
浙公网安备 33010602011771号