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

On Fri, 14 Jun 2002 15:11:53 GMT, Daniel Morgan <dmorgan_at_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.

>
>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
  Received on Sat Jun 15 2002 - 02:17:21 CEST