Re: SQLPLUS get command or @command

Najm Hashmi wrote:

> Hey Scott, I tried as you said but it still does not work. any other
> suggestions.
> Thanks again, regards,
> Najm
> "Scott Mattes" <ScottMattes_at_yahoo.com> wrote in message
> news:s73t7.2994$4Y1.2276740_at_news1.news.adelphia.net...
> > Have you tried @"c:\data\entireis.sql" ? Have you verified the spelling of
> > the filename (i have the power toys from MS installed and when in doubt I
> go
> > to WinExplorer, find the file and send it's name to the clipboard).
> >
> >
> > "Najm Hashmi" <najmh_at_videotron.ca> wrote in message
> > news:DL2t7.11885$0f3.916528_at_wagner.videotron.net...
> > > Hi All, I am trying to run my sql script using get command or @. I get
> the
> > > following error: could not open C:\data\entireis.sql.
> > > What is the correct way to do so. At sqlplus commad line i enter get
> > > C:\data\entries.sql.
> > > I have check the permissions on the file everyone can read write and
> > execute
> > > this file.
> > > Are there any further configuration to do with it?
> > > I have 8i and froms6i in different homes and os is win 2000 pro.
> > > Thanking you in advance for your help.
> > >
> > >
> >
> >

Najim,

The right syntax is :

SQL>@c:\data\entrireis

The default suffix is *.sql so you can skip it.

Hope that helps.

Trifon Anguelov
Senior Oracle DBA

www.dbaclick.com Received on Fri Sep 28 2001 - 17:46:57 CDT