DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how to create a view for object.

  1. #1
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192

    how to create a view for object.

    how do i create a view or meterialize view on object type.

    Thanks.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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.

  3. #3
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    I what to know how to create on the OBJECT TYPE NOT ON TABLE.

    Thanks.
    Chan
    OCP7.3/8.0/8i/9i
    Sun Certified Sys. Admin

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Sorry I misunderstood. Stephen Feuerstein has a good article on this subject.

    http://www.quest-pipelines.com/pipel...s.htm#expert11

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width