Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Newbie question: Accessing and Deleting Data
Do you come from another RDBMS background MSSQL perhaps? A datafile is not a
database. I'd suggest a read of the Oracle concepts guide before you go any
further.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Robert Bollinger" <robert_bollinger_at_hotmail.com> wrote in message news:a966437c.0205220625.473533f4_at_posting.google.com...Received on Thu May 23 2002 - 07:30:23 CDT
> 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