Board index » delphi » Creating Oracle Database

Creating Oracle Database

How does one create an Oracle Database. I know how to create an Access
Database using ADOX etc, but tried the same for Oracle and it did not work.
I have Oracle Personal Edition Verion 8, Delphi5 Enterprise.
 

Re:Creating Oracle Database


ADOX is currently supports only Jet Engine, i.e. you can only create
Access databases. In version 2.5 of MDAC you will also be able to
create SQL Server bases, it this functionality is still considered. Try
to use native SQL statements to create an Oracle Database.

--
Best regards,
Alex Fedorov
afedo...@aha.ru

Quote
Arnold Johnson <Arno...@compuserve.com> wrote in message

news:7un3on$2mc8@forums.borland.com...
Quote
> How does one create an Oracle Database. I know how to create an Access
> Database using ADOX etc, but tried the same for Oracle and it did not
work.
> I have Oracle Personal Edition Verion 8, Delphi5 Enterprise.

Re:Creating Oracle Database


From the ADOx readme.txt

3.2 Using ADOX with Microsoft OLE DB Providers

Certain features of ADOX are unsupported, depending upon your OLE DB data
provider. ADOX is fully supported with the Microsoft OLE DB Provider for the
Microsoft Jet Database Engine. For the Microsoft SQL Server OLE DB Provider,
the Microsoft OLE DB Provider for ODBC, or the Microsoft OLE DB Provider for
Oracle see below. ADOX is not supported by any other Microsoft OLE DB
providers.

Microsoft SQL Server OLE DB Provider

All ADOX objects, collections, properties, and methods are supported except
for those listed here:

Catalog: Create method.
Tables: Properties for existing tables are read-only (properties for new
tables can be read/write).
Views: Not supported.
Procedures: Append method, Delete method, Command property.
Keys: Append method, Delete method.
Users: Not supported.
Groups: Not supported.

Microsoft OLE DB Provider for ODBC

All ADOX objects, collections, properties, and methods are supported except
for those listed here:

Catalog: Create method.
Tables: Append method, Delete method. Properties for existing tables are
read-only (properties for new tables can be read/write).
Views: Append method, Delete method, Command property.
Procedures: Append method, Delete method, Command property.
Indexes: Append method, Delete method.
Keys: Append method, Delete method.
Users: Not supported.
Groups: Not supported.

Microsoft OLE DB Provider for Oracle

All ADOX objects, collections, properties, and methods are supported except
for those listed here:

Catalog: Create method.
Tables: Append method, Delete method. Properties for existing tables are
read-only (properties for new tables can be read/write).
Views: Append method, Delete method, Command property.
Procedures: Append method, Delete method, Command property.
Indexes: Append method, Delete method.
Keys: Append method, Delete method.
Users: Not supported.
Groups: Not supported.

-Euan

Quote
Arnold Johnson <Arno...@compuserve.com> wrote in message

news:7un3on$2mc8@forums.borland.com...
Quote
> How does one create an Oracle Database. I know how to create an Access
> Database using ADOX etc, but tried the same for Oracle and it did not
work.
> I have Oracle Personal Edition Verion 8, Delphi5 Enterprise.

Re:Creating Oracle Database


You can only create an Oracle database using SQL commands in Server Manager.
In Oracle (unlike other DBMS) a database is synonymous with an instance.
Are you really trying to create an instance OR are you trying to create a
schema in an existing database/instance?

Re:Creating Oracle Database


I am really trying to create an instance.
Quote
Todd K. Jones wrote in message <7unila$5f...@forums.borland.com>...
>You can only create an Oracle database using SQL commands in Server
Manager.
>In Oracle (unlike other DBMS) a database is synonymous with an instance.
>Are you really trying to create an instance OR are you trying to create a
>schema in an existing database/instance?

Other Threads