Re: As SYSDBA from Exp cmd line

From: Matt Goyer <mgoyer_at_fairtunes.com>
Date: Thu, 1 Aug 2002 15:28:30 -0400
Message-ID: <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

"Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message news:92eeeff0.0208011016.14b6efb6_at_posting.google.com... > "Matt Goyer" <mgoyer_at_fairtunes.com> wrote in message  news:<3d494263_1_at_news.newsgroups.com>...
> > I want to automate doing a tablespace export from a script. I'm using
 Oracle
> > 8i and it's running on Solaris 8. The problem is that 'exp' is
 incorrectly
> > parsing my command line parameters (namely the username & password):
> >
> > exp sys/****_at_oradev as sysdb
> >
> > LRM-00108: invalid positional parameter value 'as'
> >
> > I've tried escaping the whole sequence with ' or " but neither seems to
> > work.. ?
> >
> > Any insight appreciated,
> > Matt
> >
> >
> >
> >
> > -----------== Posted via Newsfeed.Com - Uncensored Usenet News
 ==----------
> > http://www.newsfeed.com The #1 Newsgroup Service in the World!
> > -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
 =-----

>
>
> $ ORACLE_SID=oradev export ORACLE_SID
> $ exp sys/password file=yourfile.dmp grants=....
>
> For help with args use
> $ exp help=y
>
> HTH
> //Rauf Sarwar




-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
   http://www.newsfeed.com       The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Thu Aug 01 2002 - 21:28:30 CEST

Original text of this message