| Queries allowed on fixed table [message #198422] |
Tue, 17 October 2006 02:35  |
gajini
Messages: 262
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
