Re: As SYSDBA from Exp cmd line
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