Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    1

    Exclamation Unanswered: Convert Materialized View to Table

    Hi!

    I am testing to set up Replication with 8i and 9i Database. I make a Snapshot from my Master Site to the 8i Database. Everything works fine, but is it possible to convert the Views to a normal Table?
    When I drop the Materialized View I also drop the Table. I want to make a failover Database and Multimaster Replication is not a solution because this is not a Oneway Replication, and with Snapshot Replication i must drop the M. View bevor I open the Database, for other Users.

    Thanks
    Peter
    Last edited by luciver; 04-18-03 at 11:09.

  2. #2
    Join Date
    Mar 2003
    Location
    Belgium
    Posts
    9

    Re: Convert Materialized View to Table

    Originally posted by luciver
    Hi!

    I am testing to set up Replication with 8i and 9i Database. I make a Snapshot from my Master Site to the 8i Database. Everything works fine, but is it possible to convert the Views to a normal Table?
    When I drop the Materialized View I also drop the Table. I want to make a failover Database and Multimaster Replication is not a solution because this is not a Oneway Replication, and with Snapshot Replication i must drop the M. View bevor I open the Database, for other Users.

    Thanks
    Peter
    Create new tables from the materialized views.

    Create table xyz as select * from M.view.

    Use the direct mode, it's faster.

    Jef.

Posting Permissions

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