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

[Guest]

Hi All,

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

[Guest]

I found the following in my export log file:

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
- Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character
set
Note: grants on tables/views/sequences/roles will not be exported
Note: indexes on tables will not be exported
Note: constraints on tables will not be exported

About to export specified tables via Conventional Path ...
EXP-00011: SYS.WWUTL_EXPORT_IMPORT$ does not exist
EXP-00011: SYS.WWUTL_EXPORT_IMPORT_DETAIL$ does not exist
Export terminated successfully with warnings.

Looks like my problems are caused by these 2 tables not being in the
database.

I didn't get any errors when installing, and can't seem to find any
information as to why these tables wouldn't exist.
Anyone else run into this?

Regards,
John