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.
