Re: Full database export

On 10 Apr 2002 13:30:16 -0700, leiwang_q_at_hotmail.com (lei wang) wrote:

>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.

No, please get in touch with Oracle and submit a feature request. If you really want this (usually only 1 or 2 users have exp_full_database and not a bunch of users) consider wrapping exp in a sqlplus script

spool exp.cmd
select 'exp etc' from session_roles
where role = 'EXP_FULL_DATABASE'
/
spool off
host exp.cmd
exit

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Apr 10 2002 - 16:32:40 CDT