RE: Unix bourne shell HELP

From: Shawn Ferris <Shawn.Ferris_at_twtelecom.com>
Date: Mon, 19 Jun 2000 16:09:40 -0600
Message-Id: <10533.109794@fatcity.com>

I'm not sure I understand what you're asking.. It appears you are trying to build the demo db for user a?

> $Oracle_home/sqlplus/demo/demobld.sql/user a

This line confuses me. I think what you want is:

connect a/b
@$ORACLE_HOME/sqlplus/demo/demobld.sql

Although, may I suggest this as an alternative:

connect a/b
@?/sqlplus/demo/demobld.sql

The ? will translate to ORACLE_HOME automagically. This way the here document isn't necessary. (no need to translate shell environment variables)

HTH
Shawn M Ferris
Oracle DBA - Time Warner Telecom Received on Mon Jun 19 2000 - 17:09:40 CDT