ORA-06550 error occurs when installing Demonstration Data in Space Manager with LiveReorg. (4263606)

1. Space Manager : Menu | Tools | Admin | Demonstration Data | click.

2. Set a password and click Install.

3. ORA-06550 error.

WORKAROUND 1

1. Copy the attached demo_history.sql  into the Demo subfolder in the Space Manager 8.3 install folder (replacing the existing one).

2. Space Manager : Menu | Tools | Admin | Demonstration Data | click.

3. Set a password and click Install.

WORKAROUND 2

If you still receive an error after replacing the demo_history script, please run the following "selects" to identify the old demo user names. Use the resulting names with the drop user commands in SQL to remove the old Space manager demo users.

select owner, table_name, iot_type
    from dba_tables
    where table_name = 'BEVERAGE_DISTRIBUTOR';

select spc_object_id, owner, object_name
    from quest_spc_segments
    where object_name = 'BEVERAGE_DISTRIBUTOR'
          and object_type = 'TABLE' ;

Example:
DROP USER QUEST_SPC_DEMO_USER1 CASCADE;
DROP USER QUEST_SPC_DEMO_USER2 CASCADE;

Please note. Drop the demo tablespaces only if they are the original demo tablespaces, they only contain demo data tables, and they are not intended for any other use

Example:

DROP TABLESPACE <demo tablespace 1> INCLUDING CONTENTS AND DATAFILES ;

DROP TABLESPACE <demo tablespace 2> INCLUDING CONTENTS AND DATAFILES ;

Default names for demo tablespaces:

demo tablespace 1:   QUEST_SPC_DEMO_TS_01

demo tablespace 2:   QUEST_SPC_DEMO_TS_02“

STATUS

Waiting for fix in a future release of Space Manager with LiveReorg.