SAP Knowledge Base Article - Preview

3374523 - SCC8 Client Copy fails with SQL0204N <tablespace> is undefined during Virtual table creation-Import phase

Symptom

Running a client import results in the following errors for Virtual Tables. 

SQL0204N  "<SID>#DATA@XXD" is an undefined name
SQL0150N  The target full select, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target.  This sqlcode does not necessarily indicate a problem if the affected table is a virtual table.
Checking the developer trace files, the following errors are present along with the above errors.
Table <tabname> is a virtual table for deferred table creation.
Virtual table <tabname> needs to be converted to a table. 
The CREATE TABLE statement when called to create the table fails with SQL0204N  "<SID>#DATA@XXD" is an undefined name for the tablespace defined in the CREATE STATEMENT.







Read more...

Environment

Db2 LUW IBM
BC-CTS-CCO

Keywords

RSCCEXPT, exclude list , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.