how do i create a view or meterialize view on object type.
Thanks.
Printable View
how do i create a view or meterialize view on object type.
Thanks.
Like this?
CREATE OR REPLACE VIEW vwuser_tables AS
SELECT * FROM user_tables
/
CREATE OR REPLACE MATERIALIZED VIEW mvuser_tables
PARALLEL
BUILD IMMEDIATE
REFESH ON FAST COMMIT
AS
SELECT * FROM user_tables
/
Of course you can only use PARALLEL if you have that option enabled. Materialized view are good because they can speed up complex queries, Oracle will change queries to use Materialized views. So you don't need to change your Sql to point to the materialized view. According to a white paper I read from Oracle you should not write queies directly against materialized views. hopefully this helps.
:cool:
I what to know how to create on the OBJECT TYPE NOT ON TABLE.
Thanks.
Sorry I misunderstood. Stephen Feuerstein has a good article on this subject.
http://www.quest-pipelines.com/pipel...s.htm#expert11