Re: Export question

. exporting stored procedures
means Procedures, Packages and Functions.

Regards
/Rauf

ford_desperado_at_yahoo.com (Ford Desperado) wrote in message news:<e96bc0d0.0410131342.465878bb_at_posting.google.com>...
> I have 2 schemas with idenical tables / indexes / convstraints. I need
> to move stored procedures / triggers / functions from one schema to
> another
>
> I tried to export a schema, here is the parameter file:
>
> FILE=xxx.DMP
> GRANTS=N
> INDEXES=Y
> CONSTRAINTS=Y
> COMPRESS=Y
> RECORD=N
> LOG=SD.LOG
> FEEDBACK=1000
> STATISTICS=ESTIMATE
> OWNER=xxxxxxx
> ROWS=N
>
> however, export failed to export functions:
>
> . exporting synonyms
> . exporting views
> . exporting stored procedures
> . exporting operators
> . exporting referential integrity constraints
> . exporting triggers
> . exporting indextypes
> . exporting bitmap, functional and extensible indexes
> . exporting posttables actions
> . exporting materialized views
> . exporting snapshot logs
> . exporting job queues
> . exporting refresh groups and children
> . exporting dimensions
> . exporting post-schema procedural objects and actions
> . exporting statistics
> Export terminated successfully with warnings.
>
> How could I export functions?
> Alternatively, could I use some utility to generate a script creating
> all the objects?
>
> it's Oracle 9i
Received on Thu Oct 14 2004 - 03:59:36 CDT