Re: VLDB Question

omar_adebisi_at_hotmail.com (Simon Adebisi) wrote in message news:<f1e58c26.0305061032.6a8229e9_at_posting.google.com>...
> Simon again. I am importing data from several sources for reporting purposes
> and need to create a fairly large Oracle database. (At least 2 GB of
> incoming data). I intend to use release 9i of Oracle and have read that it
> supports Very Large Databases (VLDB).

2Gb is a piddly data size for Oracle. If that is "very large" for you, I suggest you look at what sort of hardware you're using for this system. Rather than looking at the software.

> I have been searching for over two
> days now in trying to find the syntax for the CREATE DATABASE... command
> that would allow me to create an Oracle VLDB. This application will be going
> production next week so it is an urgent matter. Thanks in advance for your
> help gang!
>

Enlighten me: when you started using SQL Server, did you also expect to go production in less than a week after you first heard of the product? Or is this a special you reserve for Oracle?

Quite frankly, I don't even know where to start to explain to you Oracle does NOT use a CREATE DATABASE statement like you expect it to be used for VLDB. You need a crash course on database administration. Failing that, I strongly recommend you hire a temporary qualified Oracle DBA: it's gonna save you so much hardship it's not even funny...

But I'd suggest reading the SQL language manuals to start with. And the Database Concepts manual.

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Tue May 06 2003 - 19:03:57 CDT