Database Administration (MOSC)

MOSC Banner

Why Transportable Tablespaces did not import views, procedures and sequences?

edited Oct 10, 2016 2:11PM in Database Administration (MOSC) 2 commentsAnswered

Hi,

I tried to import the tablespace USERS from a db 10.2.0.5.0 to a db 11.2.0.3.0

The database had only one tablespaces for data and only one user schema called EVIARI.

In other words, I was expecting that all EVIARI information was inside USERS tablespace.

TTS of tablespace USERS worked well for Tables and Indexes, but views, procedures and sequences of EVIARI schema were missing in the db 11.2.0.3.0

I tried to find where those objects “lived” in the original db (db 10.2.0.5.0) but I couldn´t find that information, anyway, it is obvious that they live in SYSTEM or SYSAUX tablespace.

For this database was easy to find the missing objects and copy them but this issue concerns me in case I need to use TTS for more complicated databases.

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