Re: Why Can't I resize a datafile

Depends on which parameter file your instance is using. What's your Oracle SID? What startup command do you give to SVRMGR? It could be that the parameter file is held elsewhere - and could be called "initXXXX.ora" where XXXX is your SID - or it could be called pretty much anything.

The parameter looks ok - could be the wrong file - to test it, put in something like

rollback_segments = ( no matching bracket

and see if the SVRMGR startup complains about the file format - if it does, then you've at least found the correct file.

JR

"Na, Kyung-tae (³ª°æÅÂ)" <hotchild_at_iitcorp.co.kr> wrote:

>I found two init.ora files:
>
>./patch/patch7224/init.ora
>./app/oracle/product/733/dbs/init.ora
>
>I added below line in second init.ora file. Am I right?
>
>compatible = 7.3.3.0.0
>
>Then restart server... but I met same error! Something wrong?
>
>Nisar Tareen wrote
>>
>>In init.ora set up Parameter Compatible.... then try.
>>
>>Nisar Tareen.
>>
>>
>>
>
>
Received on Mon Nov 16 1998 - 01:34:43 CST