Hi all
thanks ....my sysdate is wrong ....once i corrected it...now its fine........
premkumarsp1
Last Activity: Apr 27 '08, 02:08 PM
Joined: Feb 9 '08
Location:
-
thanks ....i have got it........Leave a comment:
-
flush shared pool
Hi
I am flushing the shared pool in oracle 9i database by using the command
>> alter system flush shared_pool ;
Now if i give
>> select sql_text from v$sql;
236 rows are selected. I am the only person accessing the database. No other jobs are running. Wat could be the reason for the records being fetched while i give the command select sql_text from v$sql
Can some... -
change in sysdate
hi
in the oracle sysdate, time is coming wrongly. THe date and time in the OS from where i am accessing oracle and in the OS where oracle is installed is correct. I want to know how to update time in sysdate. can someone help me with this problem. -
hi
table_mv is a materialized view of table table_rm.
table_rm is in remote database
Whenever a record is getting inserted in table_rm, it will get replicated in its materialixed view table_mv.
I want to insert the same record in table_ori. So, i wrote a trigger on table_mv.
regards
prem.Leave a comment:
-
hi all,
thanks for ur reply. I created a view. Its working fine. But there is a new problem. I created a trigger on a materialized view table similar to the existing problem. This time i am facing problem in the insert statement.
Table_mv is a materialized view table of another table which is in remote database.
table_ori is a table similar in structure to table_ori.
Requirement: whenever a record is inserted in...Leave a comment:
-
hi veena,
Empl1 is exactly similar in structure in empl. Wenever records are getting updated in empl, i want to update the empl1 table automatically. Empl and empl1 are used for different purposes....Leave a comment:
-
hi debasisdas
Actually i want to update a particular record. I dono which particular field will be updated. So, i am deleting the entire record based on the primary key and inserting back the new updated record.
thanks
prem...Leave a comment:
-
Trigger with insert
hi
i created a trigger like this
[code=oracle]
create or replace trigger new before update on empl for each row
declare
pragma autonomous_tran saction;
begin
delete from empl1 where name = :old.name ;
insert into empl1 select * from empl where name=:old.name ;
commit;
end;
[/code]
If i do some updation in empl table that is not getting reflected due to this... -
materializd view
hi
i created a materialized view on a table prem to a remote database thru db link.
create materialized view prem
BUILD IMMEDIATE
refresh fast
start with sysdate
next sysdate +(1/1440)
as
select * from prem@dblink;
i created indexes on prem table in both databases. I created materialized view log in master table database.
I gave refresh... -
thanks..
i am working on it.....Leave a comment:
-
C++ programming
I need to write a c++ program to read a csv data from a socket and generate a CSV file. Could someone help me with this programming...
No activity results to display
Leave a comment: