Export question

From: Ford Desperado <ford_desperado_at_yahoo.com>
Date: 13 Oct 2004 14:42:25 -0700
Message-ID: <e96bc0d0.0410131342.465878bb@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 Wed Oct 13 2004 - 16:42:25 CDT