dba_tablespaces column plugged_in missing

[Former Member]

Hi,

I am getting an error ORA-904 while executing dbacockpit. I seems, that something is wrong with my dba_tablespaces.

The error is, that column plugged_in is missing.

The error occured after starting the preparations for an upgrade from SAP ERP 6.0 EHP6 to SAP ERP 6.0 EHP7.

I am on Oracle 12c.

Could someone tell me why this column could vanish and how do I get it back?

Best regards

Christian

[JamesZ · Accepted solution]

Hi Christian,

plugged_in is still valid in 12c. Did you check "desc dba_tablespaces"? Can you find "plugged_in" column listed?

Best regards,

James

[Former Member · Accepted solution]

Hi James,

the column was not visible in a desc dba_tablespaces as user sapsr3, but as user sys.

Dba_tablespaces was missing in dba_sysonyms, too.

I got a downtime and started catproc.sql and catalog.sql, now it seems to be ok.

Best regards

Christian

[fidel_vales]

Hello,

curious, curious.

As indicated by James, the column PLUGGED_IN should exist in Oracle 12c.

please, get output of the following queries (format it as monospace or put a screenshot so it is readable)

select comp_id, version, status from dba_registry;

select owner, object_name, object_type, timestamp from dba_objects where object_name = 'DBA_TABLESPACES';

select owner, table_owner, table_name from dba_synonyms where synonym_name = 'DBA_TABLESPACES';