第1个回答 推荐于2018-04-13
增加数据文件:
ALTER TABLESPACE tablespace_name
ADD DATAFILE '/oracle/oradata/db/tablespace_name02.dbf' SIZE 1000M;
建库脚本:
CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS NOARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 4 'E:\ORACLE\ORADATA\ORCL\REDO04.LOG' SIZE 50M,
GROUP 5 'E:\ORACLE\ORADATA\ORCL\REDO05.LOG' SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'E:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF',
'E:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF',
'E:\ORACLE\ORADATA\ORCL\CWMLITE01.DBF',
'E:\ORACLE\ORADATA\ORCL\DRSYS01.DBF',
'E:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF',
'E:\ORACLE\ORADATA\ORCL\INDX01.DBF',
'E:\ORACLE\ORADATA\ORCL\ODM01.DBF',
'E:\ORACLE\ORADATA\ORCL\TOOLS01.DBF',
'E:\ORACLE\ORADATA\ORCL\USERS01.DBF',
'E:\ORACLE\ORADATA\ORCL\XDB01.DBF'
CHARACTER SET AL32UTF8
;本回答被提问者和网友采纳