create table temp1
( Value    number,
  string   varchar2(1000)
)
TABLESPACE PR_PROPHET_ETL1_DATA 
PCTUSED    0 
PCTFREE    5 
INITRANS   1 
MAXTRANS   255 
STORAGE    ( 
            INITIAL          1100M 
            MINEXTENTS       1 
            MAXEXTENTS       2147483645 
            PCTINCREASE      0 
            BUFFER_POOL      DEFAULT 
           ) 
NOLOGGING 
NOCOMPRESS 
NOCACHE 
NOPARALLEL 
MONITORING;

create table temp2
( Value    number,
  string   varchar2(1000)
)
TABLESPACE temp
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            MINEXTENTS       1
            MAXEXTENTS       2147483645
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;

Create table temp2
as (select * from temp1);

INSERT INTO TEMP1/TEMP2
     SELECT *
     FROM   MY_VIEW
     WHERE  <CONDITIONS>;

SQL> set linesize 1000
SQL> set pagesize 1000
SQL> create table test_base_table 
>(row_num number primary key, 
>txt varchar2(400));

Table created.

SQL> create materialized view log 
>on test_base_table;

Materialized view log created.

SQL> create materialized view test_mat_view 
>build immediate 
>refresh fast 
>on commit as 
>select row_num, to_char(row_num)||' '||txt message 
>from test_base_table;

Materialized view created.

SQL> insert into test_base_table 
>values (1,'abc');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from test_base_table;

   ROW_NUM TXT
----------------------------------------------
         1 abc

SQL> select * from test_mat_view;

   ROW_NUM MESSAGE
----------------------------------------------
         1 1 abc

SQL> insert /*+ append */ 
>into test_base_table 
>(select rownum+1,object_name 
>from dba_objects 
>where rownum<=3);

3 rows created.

SQL> commit;

Commit complete.

SQL> select * from test_base_table;

   ROW_NUM TXT
----------------------------------------------
         1 abc
         2 ICOL$
         3 I_USER1
         4 CON$

SQL> select * from test_mat_view;

   ROW_NUM MESSAGE
----------------------------------------------
         1 1 abc