| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Qu. about creating dbs in POLite
Creating a new Oracle DATABASE means creating a new Oracle INSTANCE, which I don't think you can do with POLite. If you want to create a new SCHEMA, first create (as SYSTEM) a new USER with appropriate system privileges, then log as that new user into SQL*Plus and create DATABASE OBJECTS (tables, indexes, views, etc.) that will belong to that user/schema.
BTW, the Oracle command to create a database is CREATE DATABASE (suprise, suprise !).
Hope this helps.
Michael Serbanescu
>I downloaded Personal Oracle Lite from the Oracle website. I got this version
>because I am running Windows 3.11 on my PC and needed to play around with SQL.
>However, after it was successfully downloaded, unzipped, installed and running,
>I am having problems creating a new database. The Navigator option is only
>available with Windows '95 version so I am forced to use the command line
>utility to create my new databases.At the SQL> prompt I type in CREATEDB with
>the appropriate data source name and database name etc., but receive an error
>message. The message tells me that CREATEDB was not recognized so the rest of
>the line was ignored. I got the CREATEDB command from the help files that came
>with the download. Any helpful ideas woulbe greatly appreciated. Thanks.
Received on Sun Nov 23 1997 - 00:00:00 CST
 |
 |