"then was unexpected at this time" when exporting in 10g Portal

I'm new to the Oracle world. Just installed Oracle 10g Portal and created a few test portlets. I tried to export the transport set and saved the generated script. When I run the script however I get an error "then was unexpected at this time".

It seems to be a problem with the export/import script that was generated by the portal.

When running the script with the following command: script.cmd -mode export -s username -p password -c schema -d file1.dmp

I would get "then was unexpected at this time" and the script would abort without cleaning up the files it uses. Here is the content of the inv.bat it created:

if
wwutl_db_export_import.export_definition_exists('0512C43DC5B8421D9F1DC9A842527FD7') then
*
ERROR at line 3:
ORA-06550: line 3, column 12:
PLS-00201: identifier 'WWUTL_DB_EXPORT_IMPORT.EXPORT_DEFINITION_EXISTS' must be
declared
ORA-06550: line 3, column 9:
PL/SQL: Statement ignored
ORA-06550: line 9, column 12:
PLS-00201: identifier 'WWUTL_DB_EXPORT_IMPORT.EXPORT_DEFINITION_EXISTS' must be
declared
ORA-06550: line 9, column 9:
PL/SQL: Statement ignored

Looking at the script it was happening in the Check for Invalid Export Id section and also in the Checking for privileges... section.

I removed both of these sections from the script and the export seemed to work, i.e. I ended up with my dump file. When I tried to do the import on another server however, I ran into similar issues using the script in import mode. Removing the problem sections for the import resulted in the import completing, but I cannot access anything in the GUI to complete the import.

I have tried regenerating the script, but run into the same issues.

The user I am using as a parameter has SYSUSER privileges. Any help would be much appreciated!!

Cheers,
John Received on Tue Dec 07 2004 - 20:57:52 CET