Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How do I create a new schema object(programatically(ODBC) or with scripts) in a database

0 views
Skip to first unread message

netnews

unread,
Jun 14, 2002, 12:10:53 AM6/14/02
to
HI.
how do I create a newschema. I just get the default Domain/User when
programatically adding tables with ODBC. (CREATE SCHEMA....) Which tool with
Oracle 8i lets you create a schema so that users can connect to my
predefined ones. Must I use a script or is there a oracle tool that lets me
do this

Thanks
steve


Daniel Morgan

unread,
Jun 14, 2002, 11:11:53 AM6/14/02
to
netnews wrote:

The only way to issue DDL programatically is using dynamic SQL. Either the
DBMS_SQL package or native dynamic SQL.

It should be noted, however, that programatically building objects in Oracle is
almost always a bad practice. And in my opinion an almost inexcusable practice.
I can not think of a single justification for doing it. So I would strongly urge
you to not do it; but rather to reconsider why you are doing it and then ask for
help if you need it.

Daniel Morgan

Bill Thorsteinson

unread,
Jun 14, 2002, 8:17:21 PM6/14/02
to
On Fri, 14 Jun 2002 15:11:53 GMT, Daniel Morgan <dmo...@exesolutions.com>
wrote:

>netnews wrote:
>
>> HI.
>> how do I create a newschema. I just get the default Domain/User when
>> programatically adding tables with ODBC. (CREATE SCHEMA....) Which tool with
>> Oracle 8i lets you create a schema so that users can connect to my
>> predefined ones. Must I use a script or is there a oracle tool that lets me
>> do this
>>
>> Thanks
>> steve

I think you may be looking for CREATE PUBLIC SYNONYM. You will also need to
grant appropriate access to the user's schema or PUBLIC. You could also
create synonyms in the user's schema.

0 new messages