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: export

Re: export

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 18 Oct 2004 20:26:15 +0200
Message-ID: <41740a46$0$29883$626a14ce@news.free.fr>

"vertigo" <ax178_at_wp.pl> a écrit dans le message de news:cl104c$div$1_at_nemesis.news.tpi.pl...
> Hello
> How in exp can i select which database should be imported ?
> And how can i do it as sysdba ?
> i tried:
>
> exp USERID=sys/passwd_at_database1 as sysdba FULL=y FILE=arch.dmp
> but i receive error, that multiple values are not permitted for userid.
>
> when i tried:
> exp USERID=sys/passwd_at_database1 as sysdba FULL=y FILE=arch.dmp
> i receive ORA-28009 connection to sys should be as sysdba or sysoper
>
> Thanx
> Michal

Never use SYS to export a database, use SYSTEM or another DBA.

-- 
Regards
Michel Cadot
Received on Mon Oct 18 2004 - 13:26:15 CDT

Original text of this message

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