Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why Can't I resize a datafile
In your ./app/oracle/product/733/dbs directory, you will see a few init
files. Choose the one that corresponds to your database SID. For example, my
Oracle Sid is "y2k". So, in my directory, I will see a inity2k.ora file. This
is the file in which all my parameters will be set.
If you need me to clarify anything further, let me know.
Good Luck,
Satar
In article <72oer0$dsp$1_at_news.nuri.net>,
"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.
> >
> >
> >
>
>
--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 16 1998 - 20:18:30 CST