Folks,

I'm trying to export a users schema using the following command:

exp john/doe owner=john file file='c:\john.dmp'

The export produces the following errors:

Export: Release 9.2.0.1.0 - Production on Mon Jan 6 09:09:08 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 1422 encountered
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.STANDARD", line 628
ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 129
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.sc
hema_info_exp
. exporting foreign function library names for user STEPHEN
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user STEPHEN
About to export STEPHEN's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 1422 encountered
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_METADATA", line 474
ORA-06512: at "SYS.DBMS_METADATA", line 497
ORA-06512: at "SYS.DBMS_METADATA", line 649
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

User john has been granted the following permissions:
session, create table, create sequence, create view, create procedure.

Do I have to grant execute to john?

Please help thanks,

stickybit.