Re: How many scripts after created database?
From: Ekkehard Schulz <schulz_e_at_bln.sel.alcatel.de>
Date: 1996/10/21
Message-ID: <54g8hd$1vk_at_slbh00.bln.sel.alcatel.de>#1/1
Date: 1996/10/21
Message-ID: <54g8hd$1vk_at_slbh00.bln.sel.alcatel.de>#1/1
"SUN Tzeng" <sunn1224_at_ms4.hinet.net> writes:
>How many scripts(*.sql) after created database?
>I don't know what script is must to run after created a database.
>Only have I run is the "catalog.sql" script.
>Please give me a hint
>Thanks
Usally I run the following scripts
1. catalog.sql (for data dictionary views)
2. catproc.sql (for stored procedures)
and as system/manager
3. catdbsyn.sql (for data dictionary synonyms)
4. ?/sqlplus/admin/pupbld ( to avoid the message Product profile not loaded )
when invoking sqlplus
Regards
-- Ekkehard Schulz, Alcatel SEL AG Berlin, Department VB/EF Colditzstrasse 34-36, D 12099 Berlin, Germany Phone: +49-30-7002-3469 Fax: +49-30-7002-3667 Email: ekkehard.schulz_at_bln.sel.alcatel.deReceived on Mon Oct 21 1996 - 00:00:00 CEST