 | | | Oracle List | | Can I refresh materialized view FAST when a primary table doesnt have a
primary key ?
As per oracle it should work with ROWID option while creating MV logs.
SQL > create table temp(no number)
Table
Morning Andrey
> > based on Metalink Certify table Oracle 8.1.7.3 is not supported to
be monitored
> > in EM 10 Grid. Only databases started from 8.1.7.4.
I 'm certain that Oracle 10g client will notHi
Streams Capture/LogMiner builder crashed with the following errors when it was mining through redo logs for "alter table.. " stmt. We have added a column to this table with "DEFAULT SYSDATE " and tGene and Eric
Similar to that you might want to look at the script
"dba_column_usage.sql " at http //www.EvDBT.com. I would suggest
creating this view in any account other than SYS (such as SYSTEYeah I know It 's not supported. Here 's the scenario
Current
HPUX 9.2.0.5 2TB Warehouse
Moving to
AIX5L (5300) 10.2.0.3 Size/function same.
Would like to try using expdp/impdp as method On 4/19/07 Sam Bootsma <sbootsma@(protected) > wrote
>
> I have recently read the paper "Microsoft SQL Server 2005 for the Oracle
> Professional " and on page 16 of this document it says that "De
See http //hemantoracledba.blogspot.com/2007/04/apes-dba-or-dbas-apes.html
for one funny result of a search on Metalink.
Hemant K Chitale
http //hemantoracledba.blogspot.com
--
http //www.freIt wasn 't clear whether or not you 've reclaimed space within the
tablespaces by shrinking their objects. If you 've done that and have
pockets of free space within each tablespace one option is to mo
http //tldp.org/LDP/abs/html/testconstructs.html
To determine the ENDIAN format of your source DB
select t.endian_format
from v$transpotable_platform t v$database d
where t.platform_name d.platform_name
Not sure how you can tell the sHello David
Do you know what 'Protocol ' means in the risk matrix?
I ask this because the component at risk is XMLDB and protocol is HTTP
(DB06 in Jan 2007). Does that mean that you have to be usinAll
I am struggling to port an OAS/Oracle Forms application from one server
to another. I have the Oracle forms working but the silly icons on the
menu bar are not showing up.
I found that Has anybody ever turned off auditing on Dual? Does it have a down side?
noaudt all on sys.dual
thanks.
Now that I think about it I was going to download and update opatch
prior to applying the patchset. Sorry for the premature post there.
Why not stay with files?
What could be the approach to Convert a Large 3 TB NON-RAC Production
Database with Datafiles existing on cooked/Mounted Filesystem (UFS) to a
3 instance RAC using "ASM "?
<Yes it is standard practice to backup your recovery catalog repository
database offsite just like any other database
http //download-west.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmc
atdb00I can 't believe what I just saw.
During the install of the 10.2.0 patchset 2 (10.2.0.3) for Linux x86
(using X) an animated cursor was used while OUI was attempting to do
something prior to displayinCritical Patch Update for April 2007
p5948242 - 10.2.0.3 patch 4 for MS Win32
I 'd think about holding off testing this patch for a few days (wait
for the re-issue).
SMON is taking down the database iProxy connections in effect allow a user to become another. One needs to grant a privilege
ALTER USER <user to be proxied > GRANT CONNECT THROUGH <PROXY_USER >. Then run the statement
CONNECT <Do this now
rman target / nocatalog
RMAN > CONFIGURE CONTROLFILE AUTOBACKUP ON
And later when you need to restore
RMAN > set dbid . . .
RMAN > restore controlfile from autobackup
Regards
Why do you say table mode import is not feasible just because you have
hundreds of tables? I 've used table mode for thousands of tables -
works just fine. Simply spool out your table names to a textAs an aid to many folks that rely on this forum for help with Oracle
I thought the following URL might be useful
"How to Ask Questions the Smart Way "
http //www.catb.org/~esr/faqs/smart-questions.hNot *all* parsed statements only the statements that are dependent on
the table(s) that you analyze and it depends on whether or not you set
no_invalidate >false (default) or true.
I would suggestI 've done it but it 's not supported generally.
The way to do that is to rerun part of root.sh removing certain files
in advance. You will also need to edit hostnames there.
Next you will need to add a
Morning Niall
> > ... or being alerted on the detection of a problem and then not
until it is
> > resolved. If anyone uses the second approach I 'd love to hear what
tools you
> > use.
In a word NagAll
we have some development machines with Oracle clusterware 10.1 on them and
about 8 cluster databases with storage on RAW+ASM (Kevin can stop falling
about now). i.e no ASMLIB. I 'm looking at upgc28sCndoYXQgY2FuIEkgZG8gZm9yIHN1Y2ggaW50ZXJ2ZW50aW9uLCBzbyBTTU9OIGZhc3RseSBm
aW5pc2ggaXRzIGpvYnM/CgpyZWdhcmRzCnVqYW5nCgpPbiA0LzE3LzA3LCBqYW1ldG9uZyA8amFt
ZXRvbmdAZ21haWwuY29tPiB3cm90ZToKPgo+IHR3byBwb3all
does anyone have the experienced to setup dataguard broker with
10.2.0.1 on linux.
for primary and a standby physical database.
i tried with several combinations but have no luck.
--
regards
Andrew
When you reinstall CRS you must zero out the voting disk and OCR. See the
metalink article on cleaning up after a failed CRS install.
Bryan Thomas
Senior Consultant and Practice Manager
If you can live without the contents of the tablespace you *may* be able to
take the tablespace offline before you open and execute an offline drop.
You *might* try just starting up with the tablesp |
|
|
