| Newbie Question [message #55587] |
Sun, 02 February 2003 23:29  |
Goalie35
Messages: 1
Registered: February 2003
|
Junior Member |
|
|
Hi guys.
I know the very basics to oracle but not much more beyond that(Building and editting tables). I'm still just a student but I'm getting there ;) ).
Anyway, I have an sql file called statistics.sql which I downloaded from the internet and I wanted to view it in oracle. I took the file and placed it in the propper Oracle directory however when I go to view it(DESC statistics), I get an error which says "ORA-04043: object statistics does not exist". I pretty much figured this was going to happen because I never loaded the file into Oracle. I only placed the file into the directory. How can I aleviate this problem?
Thanks in advance.
-Goalie35
|
|
|
|
| Re: Newbie Question [message #55588 is a reply to message #55587] |
Mon, 03 February 2003 00:41  |
K k
Messages: 3
Registered: February 2003
|
Junior Member |
|
|
Hey,
Looks like you're new to Oracle. No probs man.
You need to place the file in any directory.
Then connect to Oracle using the SQL plus and execute the command @full_path_to_filefilename.sql.
this will execute the file and run the sQL Statements contained inside.
You can then open the file in any text editor to see what it was supposed to do. After that you can check the database to see if it executed properly
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
