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...
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 "CREATE USER" command in my official Oracle8i Exam Guide book, and here's the example given...
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
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.