Database Utilities (MOSC)

MOSC Banner

import failed to install all user objects

edited Oct 15, 2010 3:04AM in Database Utilities (MOSC) 6 commentsAnswered
We have a customer who was given an export of our application's schema.  The schema was imported to the same user name and tablespace name.   Later, our application started failing in different ways.  On investigation, we found that certain tables were missing.  The on-site dba said that the tables are missing because the export was made from an enterprise Oracle and the import was done to a standard edition Oracle.  Further, he said that the tables were not imported because standard edition does not support Deferred Segment Creation.  I find it hard to believe that if I export all objects owned by a

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center