Materialized view

[holdingbe]

Hi all,

I create a materialized view in toad tool but materalized views not present in the schema browser. I refresh it and then check. After that only materalized view is not present in the schema browser. what is the reason for it...


Regards
Michael

[amitpatel66]

Hi all,

I create a materialized view in toad tool but materalized views not present in the schema browser. I refresh it and then check. After that only materalized view is not present in the schema browser. what is the reason for it...


Regards
Michael

CLOSE and OPEN a NEW SESSION and check it out!!

[Saii]

Check under SNAPSHOTS tab.

[holdingbe]

Check under SNAPSHOTS tab.

Already i did like close and open a new session and i checked under the shapshot.. but i unable to see the materailized views....

please help me,,, it is urgent


regards
Michael

[amitpatel66]

Already i did like close and open a new session and i checked under the shapshot.. but i unable to see the materailized views....

please help me,,, it is urgent


regards
Michael

Confirm that your VIEW has got created properly using CREATE statement.

or

Run the CREATE statement again. If the VIEW has got created it will throw an error saying the object with the same name exists.

[holdingbe]

Confirm that your VIEW has got created properly using CREATE statement.

or

Run the CREATE statement again. If the VIEW has got created it will throw an error saying the object with the same name exists.

Hi,
once again i execute the same scripts but it throws the error like object with the same name exists