Re: Newbie Quesetion: Accessing and Displaying Data

hello robert,

you have to prefix the objects with the owner of the object to access the objects if you havent log in as the owner and no synonyms exist:

for example SQL>delete from hugo.tablename;

use <schema-name> is not available in Oracle.

hth.

s.kapitza

robert_bollinger_at_hotmail.com (Robert Bollinger) wrote in message news:<a966437c.0205220622.1debffd3_at_posting.google.com>...
> Hi -- I am trying to access the data in a database: DAILYDATA.DBF
>
> If I log on as System/manager I know I have access to the data but do
> not know how to go about doing it.
>
> From the PLSQL prompt SQL> do you "use dailydata.dbf" set a workspace
> to access it? I know this is got to be simple for those in the know.
> Thanks.
>
> I am actually trying to delete all the rows in that database. Please
> help.
>
> Thanks,
>
> Robbie Bollinger
Received on Fri May 24 2002 - 09:25:11 CEST