copy user objects problem

iTijn

Member

In an attempt to copy the user objects from DB to the other I did the following:

I used the "EXPORT USER OBJECTS" function on the source DB.
Running the resulting SQL in a new DB (and user) results in serveral errors.
Execution doesn't seem to like the "SPOOL" and "PROMPT" commands.
What am I doing wrong?

Version info:
Oracle Database 10g Express Edition Release 10.2.0.1.0
PL/SQL Developer Version 7.1.5.1398

Please be easy on me, I'm far from being an expert on this.
 
Back
Top