using datapump import to update a database (hpux to oel 5.8)
I've created a 11.2.0.3 database on oel 5.8 (64bit). We've also created a
dataguard environment (acutally oracle created the dataguard
environment).
I would now like to refresh the linux database.
Prior to installing dataguard ,i would have dropped the database, created a new one and then done a full import.
Since i've got dataguard installed i would prefer to just import specific tablespaces, but i've run into a number of problems:
(1) in dropping the tablespaces i get these error:
dropping development tablepspace errors:
ORA-29857: domain indexes and/or secondary objects exist in the tablespace
dropping development_ndx:
ORA-23515: materialized views and/or their indices exist in the tablespace
I would now like to refresh the linux database.
Prior to installing dataguard ,i would have dropped the database, created a new one and then done a full import.
Since i've got dataguard installed i would prefer to just import specific tablespaces, but i've run into a number of problems:
(1) in dropping the tablespaces i get these error:
dropping development tablepspace errors:
ORA-29857: domain indexes and/or secondary objects exist in the tablespace
dropping development_ndx:
ORA-23515: materialized views and/or their indices exist in the tablespace
0