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.