Re: Suggestions on MV Implementation !!!!!!!

Hi, I got the following info on MViews from metalink. It is very good info and hope it is useful to you. Best regards, Problem Description --- You are trying to create a materialized view which refreshes automatically when the underlying table is updated. However, the

RMAN Incremental backups.

Hi All, I am new to RMAN. I am reading RMAN documentation and doing some testing on our development box. I have couple of questions. 1. Our database is in NOARCHIVE LOG mode and I would like to do Incremental backups. Since db is in noarchive log mode, I put the database in mount

Re: RMAN Incremental backups.

Thank you ALL for your responses. Rachel, I quoted exactly what the documentation says. It is in oracle 8i backup and recovery training doc by oracle. It is on page 43 of 12th chapter. That is why I was confused and seeking some suggestions. Since our system is data warehouse system, we

Re: Question on dba_ts_quotas

Thanks Jared and others who replied. Best regards, Prasad Jared.Still@r

Question on dba_ts_quotas

Hi All, I have a question on dba_ts_quotas. User called QUOTE has objects in TS_QUOTE_DATA and TS_QUOTE_INDEX tablespaces. And, I expect that the relation/quota would show up in dba_ts_quotas. I don't see any records in dba_ts_quotas for this schema. I checked for other schemas and they showed

Re: 8i or 9i for Data Warehouse

Very good white papers/technical articles related to DW enhancements/new features in 9i are available on Oracle Technet. They are pretty good. Please take a look at those and see whether you can use those in your DW project. Hope this helps. Regards

Re: Export Hanging

Hi Mandar, We had similar problem when we did full db export. What we found was, export process was hanging when it was reading one of the system table (in our case, it is SYS.EXU8REFIC). When we saw the execution plan, it is using ALL_ROWS (there are no stats on sys objects but still it is

Re: Re: Export Hanging

I did find it in SQLab (It is by Quest). There was sql running for hours on this table. Then, I did whatever I mentioned in my earlier mail. Just to let you know, the table that we had problem wasn't the same table other people reported in metalink. Hope this helps. Prasad

Renaming GLOBAL_NAME

Hi All, I am trying to rename the global_name from SIMSNT7B.WORLD to SIMSNT7B. I issued the following command to change the global_name. ALTER DATABASE RENAME GLOBAL_NAME TO SIMSNT7B; Still it is showing SIMSNT7B.WORLD when I query the global_name view. SQL select * from global_name;

Re: Renaming GLOBAL_NAME

Thank you all for your replies. I bounced the database and still it has the same problem. Regards, Prasad Rachel

RE: bitmap indexes and rule based optimizer

rbo does not support bitmap indexes. Alternate way (in case if you don't want to use alter session to change the optimizer) to make use of the bitmap index is, If you provide index hint with bitmap index in the SQL statement, It invokes cbo and the bitmap index would be used for that

Re: any way to stop rollback for dml?/8.1.7.1/Solaris 8

Steve, Even we do have the same kind of requirement. AFAIK, there is no way except INSERT with APPEND hint (Direct Load Insert). See Direct-load Insert chapter in concepts manual. Unfortunately Direct load insert works with Insert .. select, not Insert .. values syntax. hth, prasad

Strange behavior: Update with select

Strange behavior : Update with select stt. select stt in update 1 is NOT working correct and select stt in update 2 is working correct though the select statements are logically same. Explanation: select stt in update 1 doesn't return any data even though it suppose to return one

Re: PL/SQL Question after migrating from 7.3.4 to 8.1.7

Use %ROWTYPE. TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence%ROWTYPE INDEX BY BINARY_INTEGER; hth, prasad Deen Dayal

Re: both dbms_stats dbms_utility are gathering stats on sys objects

Hi Jon, Thanks for your reply. I am aware of this option and I am currently doing the same way(i.e.,analyze database and delete SYS schema stats). But, I was wondering which release of 8.1.7 fixed this problem since Oracle claims that it is fixed in 8.1.7. Excerpt from oracle tech support mail:

Different behavior of Too_many_rows exception in pl/sql between v7v8i

We noticed a different behavior with too_many_rows exception in v7 and v8i. Is this a bug or that's the way it should work in 8i? I really appreciate your feedback on this. Thanks Regards, Prasad declare v_table_nameuser_tables.table_name%TYPE; begin v_table_name := null; select

RE: OEM Book Recommendation

Technical libraries section under metalink has white papers, manuals etc on OEM packs. hth, Prasad Christopher Spence [EMAIL PROTECTED]@fatcity.com on 05/30/2001 04:21:20 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L

RE: looking for export with dynamic compress script on VMS

Thanks to all of you who responded to my question. Best Regards, Prasad Jesse, Rich [EMAIL PROTECTED] on 05/08/2001 03:56:49 PM To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] cc: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Prasad, If you are on v7+ of OpenVMS (or is it v7.1+?), you can use

Response times with different multiblock read count

Hi All, I am running a test query with different db_file_multiblock_read_count to test the overall throughput. environment: oracle 8.1.6 on hp-ux v11 db_block_size : 16k system is using LVM and file system is using buffered I/O and disk is mirrored but not stripped. I was expecting

Max phy I/O size on Hp-UX

This question regarding max physical I/O size for hp-ux v11. When we were talking to unix sys admin, she searched in HP knowledge base and found that 256k is the maximum physical I/O for hp-ux. When I was looking at QA on Steve Adams's web site, the answer is 1M for max physical i/o size for