Home » SQL & PL/SQL » SQL & PL/SQL » materialized view (oracle 10 g)
materialized view [message #608247] Tue, 18 February 2014 02:15 Go to next message
oraclehi
Messages: 40
Registered: July 2012
Location: India
Member
i have created a materialized view by this syntax:

CREATE MATERIALIZED VIEW mv_sublet
as select..........

i got a MV_SUBLT materialized view in materialized views node of oracle database 10g, but unable to find same name table in tables node of database.
as i read whenever we create a materialized view then a table of same name of materialized view is also created but i am not able see it, although i'm getting data from select * from mv_sublet.

is it possible to see that table in tables node of oracle database 10g.
Re: materialized view [message #608249 is a reply to message #608247] Tue, 18 February 2014 02:28 Go to previous messageGo to next message
Michel Cadot
Messages: 57606
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
although i'm getting data from select * from mv_sublet.


There, logically, you are querying the mview.

Quote:
is it possible to see that table in tables node of oracle database 10g.


The problem is with your client tool (you didn't tell us). The table is there, just query user_tables:
SQL> select table_name from user_tables where table_name='MVIEW';

no rows selected

SQL> create materialized view mview as select * from t;

Materialized view created.

SQL> select table_name from user_tables where table_name='MVIEW';
TABLE_NAME
------------------------------
MVIEW

1 row selected.


Re: materialized view [message #608251 is a reply to message #608249] Tue, 18 February 2014 02:35 Go to previous messageGo to next message
oraclehi
Messages: 40
Registered: July 2012
Location: India
Member
WHEN I EXECUTE

select table_name from user_tables where table_name='MV_SUBLET';

TABLE_NAME
---------------------------
MV_SUBLET
Re: materialized view [message #608253 is a reply to message #608251] Tue, 18 February 2014 03:03 Go to previous messageGo to next message
Michel Cadot
Messages: 57606
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This is expected, so you have your table.

Re: materialized view [message #608255 is a reply to message #608253] Tue, 18 February 2014 03:06 Go to previous messageGo to next message
oraclehi
Messages: 40
Registered: July 2012
Location: India
Member
yes i know, but ehy i'm not able to see my table MV_SUBLT in TABLES NODE of database just like other tables.
Re: materialized view [message #608256 is a reply to message #608255] Tue, 18 February 2014 03:23 Go to previous message
Michel Cadot
Messages: 57606
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

As I said, this is a problem with your client tool (or maybe it is like this it works) but as you didn't tell us which one it is we can't help more.

Previous Topic: how to import table data from sql plus
Next Topic: not in, not exists query
Goto Forum:
  


Current Time: Thu Apr 17 08:53:26 CDT 2014

Total time taken to generate the page: 0.15560 seconds