oracle8i-file: demobld.sql does not run.

[chuckman40]

Hello,
I'm new to Oracle and I'm studying for the SQL/PL exam and my login.sql file executes ok, but when I execute the demo file "demobld.sql" I get "Nothing in SQL Server to Run". I've made it so far with only the "emp" demo table but I need the rest to run now. Please help. Thanks!

Charles

 

[Turkbear]

Details please..
What Platform?
Exactly how are you trying to run demobld.sql?
( it is not executable, so I was curious about your statement that you could not execute it)

 

[chuckman40]

Thanks for replying TurkBear! I'm running Win98SE on a P2 @ 333Mhz. This is really messing me up! Maybe the file permissions aren't set for my usage. Do you know how to check file permisisons in an SQL environment? Help!

Charles

 

[chuckman40]

I didn't see your second question...How am I executing the file? I know of two ways...you can use "open" n the toolbar or the "get" command. "Open" and "get" work with the file "login.sql".

Charles

 

[sem]

Can you specify how you run the script? Do you use sql*plus or some other tool? Regards, Dima

 

[chuckman40]

Good Morning...

I'm using SQL*Plus.

Charles

 

[Turkbear]

1: In your SqlPLus shortcut specify the directory that has demobld.sql as the 'start in' directory..( Usually <Oracle_Home>/sqlplus/demo )

then
Login to SqlPlus as the user (see below, first) you want to use the tables
and enter

START demobld
( or for non-geeks, @demobld )

This should create the tables..
But,
You need a user with resource privs and a default tablespace( please other than SYSTEM) first.
Since you are probably the dba create a user and assign one of your non-system tablespaces as its default tablespace and grant resource and create session privs to that user...( since it is a local system, you could grant connect,resource instead..a few more privs than really needed, but easier)

 

[chuckman40]

Turkbear,

Thanks for your posts! I've been out of town and I just started playing with the info you gave me. My shortcut start-in directory is where demobls.sql resides. I looked up the &quot;CREATE USER&quot; command in my official Oracle8i Exam Guide book, and here's the example given:

CREATE USER athena IDENTIFIED BY greek#goddess

Now by executing this command without an ending semicolon it is expecting more...options! I've tried! It comes back with insufficient priviledges. I'm at a loss. How do I create default tablespace? I think I'm probally over doing my access to you here but I'm not getting anywhere.

Charles

 

[Turkbear]

CREATE USER myuser IDENTIFIED BY simplepassword
DEFAULT TABLESPACE tablespacename TEMPORARY TABLESPACE anotherspacename;
( CREATE TABLESPACE is harder as it needs specific info about your Directory and file structure)
You need to be connected as someone with DBA privs to do all that..

Read, read and read some more ( not just an exam guide but the Concepts and the Administrator's manuals at

http://technet.oracle.com

- register, its free, and it will be one of your most visited bookmarks)

good luck..

 

[chuckman40]

Thanks again, Turkbear. I had just found someone's attempt at what I'm trying to do on the web and its exactly like your explanation...except of course, it uses specifics about thte tablespace directory and file structure. Read, read, and read somemore..yep. I actually printed the manuals awhile ago...they're under my desk! LOL! Thanks! Charles