- 论坛徽章:
- 3
|
楼上的朋友,确实是文件错了,DATAFILE1.dbf应该为file1.dbf.可是改过来后:
SQL> CREATE CONTROLFILE reuse DATABASE "test" NORESETLOGS NOARCHIVELOG
2 MAXLOGFILES 64
3 MAXLOGMEMBERS 2
4 MAXDATAFILES 254
5 MAXINSTANCES 32
6 MAXLOGHISTORY 113
7 LOGFILE
8 GROUP 1 'F:\NGNDATA\TEST\REDO01.LOG' SIZE 1048576 ,
9 GROUP 2 'F:\NGNDATA\TEST\REDO02.LOG' SIZE 1048576 ,
10 GROUP 3 'F:\NGNDATA\TEST\REDO03.LOG' SIZE 1048576
11 DATAFILE
12 'F:\NGNDATA\TEST\SYSTEM01.DBF',
13 'F:\NGNDATA\TEST\USERS01.DBF',
14 'F:\NGNDATA\testspace\FILE1.DBF'
15 CHARACTER SET ZHS16GBK
16 ;
CREATE CONTROLFILE reuse DATABASE "test" NORESETLOGS NOARCHIVELOG
*
第 1 行出现错误:
ORA-01503: CREATE CONTROLFILE ??
ORA-01163: SIZE ???? 2048 (?), ????? 20480 ??
ORA-01517: ????: 'F:\NGNDATA\TEST\REDO01.LOG' |
|