Why Transportable Tablespaces did not import views, procedures and sequences?
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.