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 c
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 decid
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 state
Thanks Jared and others who replied.
Best regards,
Prasad
Jared.Still@r
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
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
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
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 do
Thank you all for your replies. I bounced the database and still it has
the same problem.
Regards,
Prasad
"Rachel
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;
GLOBAL
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 particular
Use %ROWTYPE.
TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence%ROWTYPE
INDEX BY BINARY_INTEGER;
hth,
prasad
"Deen Dayal"
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 r
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
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:
Both DBMS_STATS.GATHER_DATABASE_STATS and DBMS_UTILITY.ANALYZE_DATABASE are
gathering statistics on sys objects. As per oracle, we shouldn't analyze
the objects owned by sys.
When I searched on metalink, I found the following information provided by
oracle tech support.
filed bug 969814 against
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 table_na
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 <[
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+?), y
Hi VMS & DBA gurus,
As part of migration process from Oracle v7 to v8i, we are trying to do the
complete export of our database. Due to the lack of disk space, we can not
land such a big export file.
Our v7 database is on VMS platform and I am looking for the VMS script,
which does dynamic compr
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 that
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 Q&A on Steve Adams's web site, the
answer is 1M for max physical i/o
size for
22 matches
Mail list logo