|
-
SQL> CREATE MATERIALIZED VIEW vw_teste
2 BUILD IMMEDIATE
3 REFRESH FAST ON COMMIT
4 as
5 SELECT codigo, nome
6 FROM marcio.teste@pd00
7 ;
SELECT codigo, nome
*
ERROR at line 5:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
SQL> CREATE MATERIALIZED VIEW vw_teste
2 PCTFREE 0 TABLESPACE usr
3 BUILD IMMEDIATE
4 REFRESH COMPLETE ON DEMAND
5 AS
6 SELECT codigo, nome
7 FROM marcio.teste@pd00
8 ;
Materialized view created.
BUT do not refresh
Last edited by marcio.68; 05-12-2003 at 12:53 PM.
Márcio de Souza Almeida
DBA Oracle / SQLServer / PostgreSQL
Rua Cupa, 139 Apto 85 A
Penha - São Paulo - SP
03640-000 - Brasil
http://www.directory.com.br
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|