Hi Jonathan,
I have attached the PL/SQL scripts to dump everything in the correct order. I
include what our DBA said on how to run it. Please email me or Martin the DBA
(md...@sa...) if you have any questions.
Since we need to get started on importing data into GUS we need to use GUSdev.
The schema we have is not in sync with the website code (remember, we had errors
because tables did not exist in the GUS import). Could we get a copy of the DB
and the website code (plus perl layer). I hope this is not asking too much - you
could test the PL/SQL to see if it works!
thanks,
Paul.
----------------
Its a PL/SQL package that can be installed on any database that it is needed on.
It can be called by a simple script such as :-
--run_cps.sql
--
set serveroutput on size 100000
spool cre_eric.sql
execute schema_copy.cp_schema('ENTMAN','USERS','INDX','ERIC','RED','GUS',128)
spool off
The above eg duplicates the "entman" schema into user "eric" identified by
"red", using tablespaces "users" and "indx" and defaulting all objects to "128k"
intitial and next.
The script can be changed to run for multiple users, spool the various outputs
and probably kick it off at the end.
----
As a side issue, if you have a fragmented database this code will calculate the
size of the extents
|
