Brand new 9.2.0.3 db created using (modified) scripts from dbca. I'm a
little suspicious that DBCA wasn't really tested with std (since it puts
invalid values in the init.ora it creates for a start). I'm rebuilding my
laptop here so I get another chance to play with this later on.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"W.Breitling" <member28455_at_dbforums.com> wrote in message
news:2903891.1053474809_at_dbforums.com...
>
> Is that database a clone of an EE database and then run in an SE
> instance? We had a similar "problem" cloning a (8.1.7) database with
> partitioning option to a server with Oracle running without the
> partitioning option. Everything worked fine, including the existing
> partitions. We just could not create any new partitioned tables. I
> believe we could even do partition maintenenance (split/merge) on
> existing partitions, but am not 100% certain at the moment.
>
> Originally posted by Niall Litchfield
> > I found the following extract from a 9.2.0.3 export log interesting
> >
> > Connected to: Oracle9i Release 9.2.0.3.0 - Production
> > JServer Release 9.2.0.3.0 - Production
> > Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR
> > character set
> >
> > **** NB standard edition*******
> >
> > About to export the entire database ...
> > . exporting tablespace definitions
> >
> > . about to export SYSTEM's tables via Conventional Path ...
> > . . exporting table HELP 918 rows
> > exported
> > . . exporting table LOGSTDBY$APPLY_MILESTONE 0 rows
> > exported
> > . . exporting table LOGSTDBY$APPLY_PROGRESS
> > . . exporting partition P0 0 rows
> > exported
> >
> > partitioned table in Standard Edition - how did that happen then?
> >
> >
> > Anyone else seen this? Got any data at all in this object?
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> ******************************************
>
> --
> Posted via http://dbforums.com
Received on Wed May 21 2003 - 03:23:31 CDT
