 | | | Oracle List | |
The error message IS ORA-942 "table or view does not exist ".
How/Why are you recreating the table twice again ?
What is the table for ? Is it your custom table ?
In your DESC you are prependiBartho
My first reaction was "hu?? ". So I googled for your terms and you might
want to look at this link
http //technology.amis.nl/blog/index.php?p 842
Dennis Williams
On 6/2/06 Willemsen BarHello
I am hoping that someone can help me with a problem I am facing on an
9.2.0.7 Oracle installation on AIX 5.1 with the optimizer not being able
to determine an execution plan and the sharedWe are running several instances on the same node as separate unix
users but each is a member of DBA group. Oracle homes are owned by
oracle dba.
2006/6/2 Niall Litchfield <niall.litchfield@(protected)
Morning Ghassan.
> "Ghassan Salem " <salem.ghassan@(protected) > 06/02/06 09 14am > > >
> Hi all
> Anybody knows if there are kind souls out there maintining orasrp?
I 'm not maintaining it as such but well if the physical standby is unavailable then your logical is also
unavailble - is that something you can cope eith?
Sending redo to a standby isnt really an overhead for the primary
On 02/06/0Amit
Oh just what is it you DON 'T want the auditors to see???? Usually auditing
operates on the principle that nothing is hidden from the auditors. I was
just reading about the auditors that audit > Specify log { <RET > suggested | filename | AUTO | CANCEL}
> cancel
> ORA-01547 warning RECOVER succeeded but OPEN RESETLOGS would get error below
> ORA-01194 file 1 needs more recovery to be consHi
>Does any please know about a way to connect from 9.2.0.1 to 10.2.0.1 without problems
>I got 01406 and forced disconection in several tries that seems a bug.
>
>I don 't know if this is only my pI thought I 'd give this a test for you - trying to TTS from 10.2 to
10.1.0.4 and got
IMP-00003 ORACLE error 721 encountered
ORA-00721 changes by release 10.2.0.0.0 cannot be used by release
10.
> > >Hi Stalin
> > >You can use RHEL ClusterSuite
> > >Or try linuxha project
> > >http //www.linux-ha.net/
> > >For free )
Isn 't there a parallel thread about simplicity? How many people
want to get ereLuca
In LMT Oracle acquired a row cache enqueue on dc_tablespace_quotas after a
segment is built. this could even be a partition exchange or add. In DMT it
used to be worse where Oracle acquired
Yes with parallel_max_servers I have tried the START_REDEF with PARALLEL
4 on the
source and target tables. Doesn 't help enough. I still get
ORA-1555s/22924s in less than 7 minutes
when I expeYou can parse out the functions and procedure names in packages from
all_source. You will need to write some crafty SQL but it isn 't really that
hard.
- Ethan
<div >You can parse out the functions an > Oracle 10.2.0.1/Sun Solaris 8
>
> We have tried a number of things like the no_parallel hints parallel
> degree 0 outlines rule hints but they all end up using parallel query
> for a particular On 5/31/06 dba1 mcc <mccdba1@(protected) > wrote
>
> we have DELL 6800 server (Xeon 64 bits) with Redhat As
> 4.0 (64 bits) installed on it.
>
> After I installed ORACLE LINUX 10GR2 64 bits software
> I 'm not doubting you as I 've seen some of the same surveys but here is a
survey by Merill Lynch of 75 US and 25 European CIOs.
Keith
I have a table with
a. a LOB segment
b. a very high rate of UPDATEs to the LOB (a BLOB !)
c. the LOB segment is in an LMT-AutoAllocate-ASSM Tablespace
d. the database is running AUM andJust some thoughts....
did you check for any async IO problems? is the async IO driver configured
properly? i usually wouldn 't dare ask these questions for a Tru64 box....it
works like a charm...
buTime to prepare a Form letter for such things in future. Just fill in
the blanks and fax it over.
Raj
On 5/31/06 Jonathan Gennick <jonathan@(protected) > wrote
> And so today I will fax off my firsI think generally as a matter of convenience to you. I have noted that
everytime a new DBA comes in he wishes to either increase the number of
tablespaces from 5 to 40 or reduce them from 40 to 5. MJonathan is indeed a relational adult.
Mogens
Bobak Mark wrote
>Hi Jonathan
>
>I agree that is a pain....but could you imagine the chaos that could ensue if they simply honored all email requMaybe it 's taking 7 minutes to return the data to your client over the
network if it 's a lot of data and/or you have a slow network connection.
How long does it take if you just spool the output to a Hi Christo
Every undo is protected by redo.
Index can be created with NOLOGGING i.e the initial creation of index
data will not be logged but any reqursive SQL performed during
creation will be.
HTHHello All
We 're doing a direct path to an empty table via
insert /*+ APPEND*/ into TABLE as select * from other_schema.SAME_TABLE
The table has a primary key and a few extra indexes. The goal isFor some real fun try using systimestamp and then doing some timezone
conversions so somthing like an update_date field is always displayed in
the users local time zone.
I got quite a few grey haiOn 5/31/06 A Joshi <ajoshi977@(protected) > wrote
>
> Hi
> I am struggling with following sql for passing rowid as bind variable.
> I keep getting ORA-911 error. Thanks for your help. I made it a nOn 5/30/06 A Joshi <ajoshi977@(protected) > wrote
>
> Hi
> I would like to know if there are any known issues or tasks to be done
> in case of oracle upgrade from 8i to 9i for advanced replication.
Thanks Jeremiah.
I had also seen your DBA Disaster Diary presentation and read your guide
about pre-building the Oracle executables...but I couldn 't figure out
how to pre-run the SQL scripts...
I wDoug
Do you mean which segments the process wrote undo information read undo information or both?
Regards
Daniel Fink
Doug Gernaat <dag@(protected) > wrote we have a ProC program that runs f |
|
|
