Re: Urgent help needed!

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 14 Sep 2006 03:12:46 GMT
Message-ID: <J5KBLH.n3w@igsrsparc2.er.usgs.gov>

rwking_at_gmail.com wrote:
> G Quesnel wrote:

>> Who are you connecting as - try "show user"
>> What do you mean by "raw data"
>> Where is the database - do you have access to the "server".
>> Are you saying that you can not issue a OS command to determine the
>> size of all database files (Windows: right click + properties of
>> folders where all data+temp+log+control files - Unix df -k <folder
>> name>).
>> Can you connect to the database as a user who has dba privileges (SYS
>> or SYSTEM)?
>>
>> Did you try the Alternate views USER_ and ALL_ on the views Vista has
>> suggested (ie USER_DATA_FILES I think works on tablespace you have been
>> granted quota on)
>>

>
>
> - My username is ISM61018
> - Forgive my terminology... raw data may not be the correct term. The
> database is just five tables of grocery store data over the past 2
> years.
> - The database is on a server at my university (I do not have access to
> this) and I am connecting via a web-based ISQL*PLUS interface
>
> Is this the correct format? Thank you for your response... I did try
> the query you suggested, but my response was:
>
> ERROR:
> ORA-04043: object USER_DATA_FILES does not exist
>
> And the same was true with ALL_

There is no USER_DATA_FILES view nor a ALL_DATA_FILES view. There is only the DBA_DATA_FILES view.

> When I tried using ISM61018, I recieved this message:
>
> ERROR:
> ORA-04043: object ism61018_data_files does not exist
>
> I do not have DBA privileges on this database as the entire class was
> granted a username/password. Does this mean I will not be able to
> execute a query of this type?

If you do not have DBA privs, then you probably want the size of your tables and indexes. In that case, query USER_SEGMENTS.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Wed Sep 13 2006 - 22:12:46 CDT