Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: can't create table from package

Re: can't create table from package

From: William Robertson <williamr2019_at_googlemail.com>
Date: Thu, 13 Dec 2007 15:35:34 -0800 (PST)
Message-ID: <34f0ee7d-affc-4881-8068-90f51af222e6@s19g2000prg.googlegroups.com>


On Dec 13, 2:03 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:

> And with 10g and later releases there is CREATE SCHEMA, which would
> preclude the use of PL/SQL to create database objects on product
> installation, which creates all or nothing should an error occur.

CREATE SCHEMA has been around since at least 7.3: <http://download.oracle.com/docs/cd/A57673_01/DOC/server/doc/SQL73/ ch4a.htm#toc098>

However it is arguably of limited usefulness: <http://radiofreetooting.blogspot.com/search?q=create+schema> Received on Thu Dec 13 2007 - 17:35:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US