Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Enable Table Partition feature.
Paul Bennett wrote:
>
> What other helpful views are there that are not created by catproc?
>
> -- Paul
>
> Philip Douglass wrote:
>
> > I'm afraid I don't know the answer to your first question, since we don't
> > currently use partitioned tables, but as for the second question, you need
> > to run the catblock.sql script (in $ORACLE_HOME/rdbms/admin for UNIX).
> > catalog.sql does not run catblock.sql
> >
> > -- psd
> >
> > Arun Patel <arunpatel_at_sprint.ca> wrote ...
> > > Dear friends,
> > >
> > > I'm unable to create partition table in Oracle8 Database. I get and error
> > > "Partition feature is not enabled'
> > >
> > > Can anybody tell me what parameter should I enable ?
> > >
> > > Second is, DBA_WAITERS view does not exist in my database. I want to use
> > > this view for lock contention. I ran Catalog.sql scrip again but still it
> > > does not create any view. I saw in DBA_OBJECTS and V$DICTIONARY view.
> > But
> > > there is no such entry in this views.
> > >
> > > Can anybody tell me whether it's exist in Oracle8 or renamed to some other
> > > name ?
> > >
> > > Thank you,
> > > sgm.
There is some useful stuff in catparr and utlraw (I think) that are/were not run in some releases ...
HTH
--
"Some days you're the pigeon, and some days you're the statue." Received on Thu Dec 16 1999 - 18:42:19 CST