Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

1st SchemaTable's "On Data Change" --> Update another Schema.another Table

KnightbeatFeb 22 2010 — edited Feb 22 2010
I need to know how to write a trigger so that it listens to a table*(table 1)* of one schema & immediately updates another table(table 2) which exists in another schema, on any data change (record insert/update or delete) in the 1st table I mentioned.

[I didn't read anything about this before I ask this. So I just need to know whether it's possible or not. I don't expect you to spend a lot of time on this. But I will be much thankful, if you could tell me whether this is possible to be done or not]

Thanks!

Comments

Peter Gjelstrup
Answer
1. What is the difference between the below 2 index usage scenarios:
/*+ index(a index_name) parallel(a,4)*/
/*+ parallel_index(a,index_name,4)*/
Are both these same?
No,
First are two hints, one to use index and one to instruct the optimizer to use 4 concurrent servers for a parallel operation

The second is just one hint. it tells optimizer to use 4 concurrent servers on partitioned indexes.
2. What is full index scan and fast full index scan?
Full index scan do single block reads.
Fast full scan do multi block reads.

3. I have a table created in database and it has a few indexes on some columns. How can I check whether the index is Bitmap or B-Tree ?
In user_|all_dba_indexes. Index_type will be BITMAP or NORMAL

Regards
Peter


P.S: Speaking of hints. Bookmark this, can answer most of such questions much better than I can:
http://www.oracle.com/pls/db112/homepage

Edited by: Peter on Mar 26, 2013 1:47 PM
Marked as Answer by AB312062 · Sep 27 2020
AB312062
Thanks Peter !

Can you tell more about the difference in using index and parallel_index. I din't fully understand. If you could explain with some example or provide some link where I can find more information, that would be helpful.

Regards
AB
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 22 2010
Added on Feb 22 2010
#on, #sql, #trigger, #update
2 comments
423 views