Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent Help Need: CReate Large Table

Re: Urgent Help Need: CReate Large Table

From: Roger Loeb <rloeb_at_martech.com>
Date: Tue, 19 May 1998 19:05:54 -0600
Message-ID: <6jta9k$o8l$1@news1.rmi.net>


Thanks to all who responded so promptly by email. You saved my ... Yup, it's a Unix issue, not an Oracle issue. Sure gonna be a lot of files when we roll out the real database, which has 10 partitions that are each about 80 gig. Ugh.

Rog

Roger Loeb wrote in message <6jsn3r$dc8$1_at_news1.rmi.net>...
>OK, what's the secret? We're trying to create an 80gb table on a DEC Alpha
>running Unix 4.0b with Oracle Enterprise 8.0.3. (This is supposed to be a
>"proof of concept" demo for a client, but thus far all that we've proved is
>that we're inept.) The initial database create fails with ORA-1501,
>then 1519 (error in SQL.BSQ near line 206), then 0604 (recursive SQL error
>level 1), and then 1144 (something about the file size exceeding 4,352K).
I
>know that this version of Oracle is supposed to support large databases.
>So, how do you make it work? We're running out of time for this demo.
>
>I tried to post this question to the tech support forum on Oracle MetaLink
>and all that I got was an Oracle error! Maybe the SQLServer gods are
trying
>to tell me they're angry with my disloyalty.
>
>Thanks for any help you can offer.
>
>Rog
>--
>roger@_delete_this_to_reply_.martech.com
>
>
Received on Tue May 19 1998 - 20:05:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US