An undocumented restriction in Workspace Manager – exporting tables with valid time support
Posted by Matthias Rogel on 7. February 2013
If you are using Workspace Manager, it could be probably useful to know, that there is an undocumented restriction concerning import/export.
Due to Import and Export Considerations,
…Workspace Manager supports the import and export of version-enabled tables in one of the following two ways: a full database import and export, and a workspace-level import and export through Workspace Manager procedures. No other export modes, such as schema, table, or partition level, are currently supported….
However, this does not hold for tables with valid time support:
firstname.lastname@example.org > CREATE TABLE d (id NUMBER PRIMARY KEY); Table created. email@example.com > EXECUTE DBMS_WM.EnableVersioning (table_name=>'D', validTime=>TRUE, hist => 'NONE'); PL/SQL procedure successfully completed. firstname.lastname@example.org > EXECUTE DBMS_WM.Export(table_name => 'D',staging_table => 'D_STG', workspace => 'LIVE'); BEGIN DBMS_WM.Export(table_name => 'D',staging_table => 'D_STG', workspace => 'LIVE'); END; * ERROR at line 1: ORA-20171: WM error: Export not supported on a table with valid time ORA-06512: at "WMSYS.LT", line 13185 ORA-06512: at line 1
Support confirmed, that in this case only full db import/export (!) is supported, documentation would be updated somewhen.