Home » RDBMS Server » Server Administration » Queries allowed on fixed table
Queries allowed on fixed table [message #198422] Tue, 17 October 2006 02:35 Go to next message
gajini
Messages: 259
Registered: January 2006
Senior Member
Hi,

I've mounted my database,when i give the follwing query,'Select * from v$database;",it works,but when i give the query,"select * from dba_data_files;",it gives the following error,

ORA-01219:database not open:queries allowed on fixed tables/views only.

Just clear me,
1. What are the tables/views internally marked as fixed by ORACLE & on what basis ORACLE does this marking?
2. What is meant by fixed table/view?


Thanks,
Gajini

[Updated on: Tue, 17 October 2006 02:37]

Report message to a moderator

Re: Queries allowed on fixed table [message #198434 is a reply to message #198422] Tue, 17 October 2006 03:14 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

ORA-01219:database not open:queries allowed on fixed tables/views only.

Fixed Table Are Dynamic Table of Oracle Like V$,X$ etc
Query Complete List Of V$ performance views
>>>V$fixed_table;

This part describes data dictionary tables and views. These tables and views are called static, because they change only when a change is made to the data dictionary (for example, when a new table is created or when a user is granted new privileges).

1.All_
2.DBA_
3.USER_

Query >>> Dictionary Table.
sql>desc dictionary
Previous Topic: 2 Databases in 1 Unix box
Next Topic: listener problem
Goto Forum:
  


Current Time: Mon Dec 05 13:21:45 CST 2016

Total time taken to generate the page: 0.04670 seconds