That is true and you are correct.
> -----Original Message-----
> From: Stephane Faroult [SMTP:sfaroult_at_oriolecorp.com]
> Sent: Friday, October 27, 2000 4:51 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE : RE: Is it possible to import a package alone?
>
> There is a very minor glitch in Rodd's script - ORDER BY should be by
> name, TYPE, line - simply because PACKAGE and PACKAGE BODY bear the same
> name. I presume that the original version had
> type = 'PACKAGE BODY',
> not
> type like 'PACKAGE%'
> --
> Regards,
>
> Stephane Faroult
> email: sfaroult_at_oriolecorp.com
> Oriole Corporation
> Voice: +44 (0) 7050-696-269
> Fax: +44 (0) 7050-696-449
> Performance Tools & Free Scripts
> ------------------------------------------------------------------
> http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
> ------------------------------------------------------------------
> >
> > I give!
> > I'll make it easier. Here's a script that pulls it from the data
> dictionary
> > to a spool file. Add another where clause to specify the package name
> and
> > you can narrow it down to specifics. This script as it is will pull all
> the
> > packages for a given user. It is ment to be run from SQL*Plus so that
> you
> > can format the output into standard readable output with lines joined
> and
> > everything.
> >
> > set feedback off
> > set pagesize 60
> > set linesize 200
> > set newpage 0
> > break on name skip page
> > col " " format a80 wrapped
> >
> > select decode(line,1,'CREATE OR REPLACE ',null) as "/", text as " "
> > from dba_source
> > where owner = '<SCHEMA OWNER>'
> > and type like 'PACKAGE%'
> > order by name, line;
> >
> > -- The following command creates the terminating slash at the end of the
> > script.
> > set heading off
> > select '/'
> > from dual;
> >
> > clear breaks
> > clear columns
> > clear buffer
> > set heading on
> > set linesize 200
> > set pagesize 60
> > set feedback on
> >
> > Rodd Holman
> > Enterprise Data Systems Engineer
> > LodgeNet Entertainment Corporation
> > rodney.holman_at_lodgenet.com
> > Comments made are my own opinions and views. They do not represent
> views,
> > policies, or procedures of LodgeNet Entertainment Corpor
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stephane Faroult
> INET: sfaroult_at_oriolecorp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Oct 27 2000 - 07:03:30 CDT
