Re: Help: ORA-01122

From: Vitaliy Mogilevskiy <vit100gain_at_earthlink.net>
Date: Wed, 07 Apr 1999 15:24:09 -0700
Message-ID: <370BDB09.49A2BCCA@earthlink.net>

Or maybe you dont even have that much space 5000m ---? why not break it into small files ?

+--------------------------------------------------------------------------+
| Vitaliy Mogilevskiy
| Senior Consultant
| CORE Technology Group, Inc.
| E-mail:    vit100gain_at_earthlink.net
| Web Page:  http://home.earthlink.net/~vit100gain/index.html

|            *** Free DBA Script Library at my Web Page ***
+--------------------------------------------------------------------------+

ewong74_at_netscape.net wrote:

> Hi there,
>
> I tried to create a tablespace and the an error message:
> SVRMGR> CREATE TABLESPACE USER DATAFILE 'c:\user.dbf' size 5000M;
>
> ORA-01122: database file 6 failed verification check
> data file 6 'c:\usr.dbf'
> actual file size of 462848 is smaller than correct size of 2560000 blocks
>
> Please help. Thanx!!
>
> Ed
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Apr 07 1999 - 17:24:09 CDT