To clear and refresh all the data in the ODS database:
Note: This procedure assumes that you chose the default username (ODSUSER) during the installation. If you chose a different name, use it instead of the default.
drop user odsuser cascade;
begin
for syndrop in (select synonym_name from all_synonyms where synonym_name like 'P6%')
loop
execute immediate 'drop public synonym '||syndrop.synonym_name;
end LOOP;
end;
Dropping the users listed in step 2 of the preceding procedure will remove all data from the P6 Reporting Database instance. You can rerun the odsetl file to populate the ODS database with the P6 EPPM database information.
Related Topics |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014