As for the workspace manager, in the 9.2 Application Developer's Guide - Workspace Manager, section 1.5 reads: =========copied from documentation Standard Oracle database import and export operations can be performed on version-enabled databases; however, the following considerations and restrictions apply:
-- A database with version-enabled tables can be exported to another Oracle database only if the other database has Workspace Manager installed and does not currently have any version-enabled tables or workspaces (that is, other than the LIVE workspace).
-- Only database-wide import and export operations are supported for version-enabled databases. No other export modes (such as schema, table, partition, and workspace) are supported.
-- For an import operation, you must specify IGNORE=Y.
-- The FROMUSER and TOUSER capabilities of the Oracle9i Import utility are not supported with version-enabled databases. =========end of copied from documentation.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Dan Norris
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.