Re: As SYSDBA from Exp cmd line
Date: Fri, 02 Aug 2002 03:05:27 GMT
Message-ID: <XFm29.218043$Wt3.178223_at_rwcrnsc53>
Create a parfile and specify: userid="sys/syspass as sysdba".
That will work.
Alex
"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
>
> "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 Fri Aug 02 2002 - 05:05:27 CEST