Re: As SYSDBA from Exp cmd line
From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 1 Aug 2002 21:54:09 -0700
Message-ID: <92eeeff0.0208012054.2e992fc0_at_posting.google.com>
Date: 1 Aug 2002 21:54:09 -0700
Message-ID: <92eeeff0.0208012054.2e992fc0_at_posting.google.com>
"Matt Goyer" <mgoyer_at_fairtunes.com> wrote in message news:<3d498c16$1_10_at_news.newsgroups.com>...
> Yes, but:
>
> EXP-00044: must be connected 'AS SYSDBA' to do Point-in-time Recovery or
> Transportable Tablespace import
>
> Matt
>
Got it. You need to pass the entire string in quotes. I believe on Solaris, you also need to escape quotes. I know on HP you have to.
On Solaris
ORACLE_SID=oradev export ORACLE_SID
exp \'sys/password as sysdba\' ...
On WinNT/2K
exp 'sys/password_at_oradev as sysdba' ...
HTH
//Rauf Sarwar
Received on Fri Aug 02 2002 - 06:54:09 CEST