I've assed enough files in my time thats for sure. Fortunately not Oracle
ones mostly.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Barry Raymond" <barry_at_netbotz.com> wrote in message
news:fh3c9ugvdbggviroqvtiv7ef5h8u44muvs_at_4ax.com...
> Thanks guys worked fine. Just assing some .ora files to the table
> space.
> On Tue, 12 Mar 2002 23:50:46 GMT, damorgan <damorgan_at_exesolutions.com>
> wrote:
>
> >Are you trying to do this in a single datafiile? Add another one to the
> >tablespace.
> >
> >Daniel Morgan
> >
> >
> >
> >Barry Raymond wrote:
> >
> >> I'm having problems with Oracle and a large database. I have plenty
> >> of disk space but the database pukes when it gets to 16GB. When I try
> >> to enlarge the datafile I get this error:
> >>
> >> ORA-01144:(File size (4198600 blocks) exceeds maximum of 4194303
> >> blocks.
> >>
> >> I'm running Oracle 9i Enterprise on W2K on an NTFS filesystem. I've
> >> been reading up on the Oracle Raw file system, but it really doesn't
> >> metion over comming this problem and NTFS can handle really big file
> >> sizes anyway. Is there a way to enably 64bit file system support
> >> under W2K? The DB gets so large because I am inserting pictures into
> >> it so I can't just make the DB smaller.
>
Received on Mon Mar 18 2002 - 11:39:54 CST
