Home » Developer & Programmer » Reports & Discoverer » IMP ORACLE10G FILE (Materialized view problem)
IMP ORACLE10G FILE (Materialized view problem) [message #249614] Thu, 05 July 2007 03:41 Go to next message
arehman
Messages: 5
Registered: June 2007
Location: Pakistan
Junior Member
Dear All,

Can anybody help me to import 10g dmp file without problem in materialzed view. Because when I import file then materialized view shows data as a table but not show QUERY.

I want to show query of materialzed view.

Plz. help in this respect.

Best Regards,
Re: IMP ORACLE10G FILE (Materialized view problem) [message #249680 is a reply to message #249614] Thu, 05 July 2007 09:44 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
This has little to do with reporting, nor with the import file.

The query text of materialized views can be found in the all_mviews data dictionary view (column query).

If you are using a tool such as Toad or PL/SQL Developer, you can easily see the query text.

The same goes for views by the way, the query text is to be found in all_views.text.
Re: IMP ORACLE10G FILE (Materialized view problem) [message #249898 is a reply to message #249680] Fri, 06 July 2007 08:13 Go to previous messageGo to next message
arehman
Messages: 5
Registered: June 2007
Location: Pakistan
Junior Member
Dear All,

Thanks for your suggestion.

I already use Toad / PL SQL Developer
and also check from data dictionary but the behavious of materialized views is like 'TABLE' not Materialized views.

Please suggest in this respect

Regards,
Re: IMP ORACLE10G FILE (Materialized view problem) [message #250872 is a reply to message #249898] Wed, 11 July 2007 12:12 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
What are you using, Toad or PL/SQL Developer?
Re: IMP ORACLE10G FILE (Materialized view problem) [message #251204 is a reply to message #250872] Thu, 12 July 2007 12:39 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Unless I'm wrong, TOAD will display a materialized view both in the Tables section and in the Snapshot section. So, did you check Snapshots in TOAD and see what's written in there?
Previous Topic: Convert RDF to PDF through pl/sql
Next Topic: Output Discoverer report vertically rather than in a table??
Goto Forum:
  


Current Time: Sun Dec 04 23:12:46 CST 2016

Total time taken to generate the page: 0.08410 seconds