Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i Export Problem

Re: Oracle 9i Export Problem

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Mon, 27 Oct 2003 09:47:11 +0100
Message-ID: <grgppvomism1asbdj97q47vnn4p0gmu5ar@4ax.com>


On Thu, 23 Oct 2003 16:08:12 +0100, "DOKNIK" <dominiqs_at_o2.co.uk> wrote:

>Any suggestions .I am new to Oracle 9i, i have used 8.1.7 and have always
>done exports as SYS without any such problems

Any user with the exp_full_database role would do. In fact you shouldn't use SYS to export, especially not in scripts as that will disclose your password.

--
Sybrand Bakker, Senior Oracle DBA
Received on Mon Oct 27 2003 - 02:47:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US