Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: can't create table from package
On Dec 16, 7:56 am, DA Morgan <damor..._at_psoug.org> wrote:
> William Robertson wrote:
> > On Dec 15, 7:52 pm, "shakespeare" <what..._at_xs4all.nl> wrote:
>
> >> No, this is not
> >> CREATE SCHEMA
> >> but
> >> CREATE PROCEDURE "schema.procname"
>
> > I was responding to David Fitzjarrell's comment that "CREATE SCHEMA"
> > is available from 10g onwards.
>
> CREATE SCHEMA is listed in the Oracle 7 Server SQL Language Quick
> Reference (1987).
Indeed, it's on page 4-221 of http://download.oracle.com/docs/pdf/A32538_1.pdf (And check out the typo on page A-18)
The bit about being able to roll back multiple DDL has long been a source of wonder for me, begging the question of implicit commits on other DDL.
jg
-- @home.com is bogus. "Some somehow observe the day,but are vexed, I believe, that the body of people profane it, and blessed be God no authority yet compels them to keep it." - Boston Puritan Samuel Sewall, Christmas Day 1685 - when celebrating Christmas was illegal in New EnglandReceived on Mon Dec 17 2007 - 12:22:56 CST
![]() |
![]() |