Re: Export oddity

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