Alter Materialized View log (merged) [message #399028] |
Mon, 20 April 2009 05:35  |
|
Hi,
It is possible to rename column of the Materialized View log like
ALTER MATERIALIZED VIEW LOG ON DOCUMENTS_UD
RENAME custodian to capture_business_unit_code;
ADD Clause works with alter materialized view log but Rename clause gives following error..
ERROR at line 2:
ORA-14155: missing PARTITION or SUBPARTITION keyword
Thanks in advance
Uday
|
|
|
|
Re: Alter Materialized View Log [message #399039 is a reply to message #399036] |
Mon, 20 April 2009 06:10   |
|
Hi Babu,
Please give the query.
I am renaming the column of the table which is also added there in the materialized view log thru alter statement, and i do not want to drop and recreate the mat view log and build the indexes again.
Uday
|
|
|
|
|
|
|
How to refresh Materialized View log [message #399312 is a reply to message #399028] |
Tue, 21 April 2009 09:56   |
|
Hi,
I have a table say abc
create table abc
(
a number(4), Primary Key
b varchar2(10),
c varchar2(20)
);
then i have created mat view log
create materialized view log on abc;
Now i am adding column c (Non primary Key) to mat view log...
alter materialized view log on abc
add (c) ;
Now after some time i fire alter statement on table renaming the column c to d
alter table abc rename column c to d;
Now i want to refresh the mat view log according to the table definition.
Thanks in advance 
|
|
|
|