Prev: utl_file.frename against utl_file.fcopy
Next: Strange ODBC error
From: Brian Peasland on 13 Sep 2006 23:12
rwking(a)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(a)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
From: rwking on 13 Sep 2006 23:28
Brian,

You are the man.

Thank you so much for your help. That query worked beautifully!! :o)

Best,

Rich King

First  |  Prev  | 
Pages: 1 2 3
Prev: utl_file.frename against utl_file.fcopy
Next: Strange ODBC error