Full database export

From: lei wang <leiwang_q_at_hotmail.com>
Date: 10 Apr 2002 13:30:16 -0700
Message-ID: <af074b9c.0204101230.5483fedc_at_posting.google.com>



Hi there,

I know that I need EXP_FULL_DATABASE role to export full database. But if I don't have the EXP_FULL_DATABASE role, I want exp to exit with error. The problem is exp prompts and tries to read from stdin if I don't have EXP_FULL_DATABASE role. This is the command line and exp output:

    exp <username>/<password> full=y file=mydb.dmp log=mydb.log consistent=y

    Export: Release 8.1.7.3.0 - Production on Wed Apr 10 16:13:25 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

    Connected to: Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production

    With the Partitioning option
    JServer Release 8.1.7.3.0 - Production     EXP-00023: must be a DBA to do Full Database export
(2)U(sers), or (3)T(ables): (2)U >

If I type ^D, exp terminates. I have to run exp from a script(probably a cron job), and I don't want exp to prompt. Is there any way to have exp terminate when the user does not have exp_full_database role?

Thanks in advance. Received on Wed Apr 10 2002 - 22:30:16 CEST

Original text of this message