SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION; SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0; 启动数据库 alter database open; 修改字符集 alter database character set internal_use ZHS16GBK; 关闭,重新启动SQL>shutdown immediate SQL> startup...
'/oracle/oradata/boss/example01.dbf', '/oracle/oradata/boss/testtbs01_01.dbf', '/oracle/oradata/boss/testtbs01_02.dbf', '/oracle/oradata/boss/testtbs04_01.dbf' CHARACTER SET ZHS16GBK ; SQL> CREATE CONTROLFILE REUSE DATABASE "BOSS" NORESETLOGS ARCHIVELOG 2 MAXLOGFILES 16 3 MAXLOGMEM...
'/oracle/oradata/boss/example01.dbf', '/oracle/oradata/boss/testtbs01_01.dbf', '/oracle/oradata/boss/testtbs01_02.dbf', '/oracle/oradata/boss/testtbs04_01.dbf' CHARACTER SET ZHS16GBK ; SQL> CREATE CONTROLFILE REUSE DATABASE "BOSS" NORESETLOGS ARCHIVELOG 2 MAXLOGFILES 16 3 MAXLOGMEM...
create controlfile database orcl logfile 1. 2. --全部日值组和日值文件,及大小 NORESETLOGS DATAFILES 1. 2. --数据库全部数据文件路径及名称 maxloghistory 2000 --最大历史日志数 maxdatafiles 2000 --设置最大数据文件数 maxlogmembers 5 --最大日值成员数 character set ZHS16GBK; --设置数据库字...