 | | | Oracle List | | Hi John
if you are using oracle 8i or newer you can try
alter table move.... command
don 't forget to rebuild indexes with
alter index rebuild.... comand
since moving a table implies rowid chaKean
You can do it this way
Select emp_count emp_dis_count
Hello fellows!
First of all congratulations for the high sound to noise ration in this
list. I 've no doubt it 's the best one I 've ever participated.
My doubt
I 've been working for the last fo---------- Forwarded message ----------
From Chris Hoover <revoohc@(protected) >
Date Jun 13 2005 4 08 PM
Subject How to shutdown 9i?
To Oracle-L@(protected)
We are having a very strange List
If a user logs into database A and executes a query against database B
over a database link then signs out will database B show an active
session for some period of time afterward? Your thouI always create either a script or a procedure to both issue grants and
create public synonyms. So an export/import followed by an execution of
this procedure simply creates the syns and issues thehttp //tahiti.oracle.com
On 6/13/05 Ken Naim <kennaim@(protected) > wrote
> Can anyone point me to a good document on the best practices and step by
> step setup and configuration of rman for diskHi
Is there anyone in the DL running Oracle 11i (11.5.9) e-business suite
in 9i2 RAC environment? I am interested to find out whether you are
controlling the concurrent managers via the cluster or
Yikes you want to see a high number of waits?
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ %
Total
Event Hi Mladen
Well I think this depends on your individual perspective.
I agree your observations of commercial realities. I think this is
universal for all practitioners. However I also believe thWhen you say that sqlplus uses the index do you actually execute the sql
and look at the sql trace or v$sqlplan for the sql or are you looking
at autotrace (traceonly) or explain?
Explain and t
On 06/14/2005 08 26 56 AM A.Bahar@(protected) wrote
> Please before to give someone utterly nonsensical advice and before to
pass oneself off as a 20
> scholar try to read whayou have to enter a user with dba privs ... enter system and correct
password.
Raj
On 6/13/05 A.Bahar@(protected) <A.Bahar@(protected) >
wrote
>
> HI 20
>
> I haI don 't know about the smiley ) But I opened the source of the doc
and it seems that it has errors in it. Otherwise it looks like having
legitimate information.
- Vlad
On 6/12/05 rjamya <rHi
The algorithm used to generate the DBID is not documented.
As for its uniqueness if a database is duplicated without RMAN and
without using the "nid " utility it will have the same DBID asI have seached on google for days did find anything relevant for
descriptions of columns of the table tkprof_table (created when you run the
script created by tkprof with insert )
when I try Hi all 20
I am running some scripts from Chapter 4 of Kytes forthcoming book . 20
I want to exactly measure PGA usage.
Array is created
SQL > l
1 create or replace package demo_pkg
2 as
Solaris 5.9 Oracle 9.2.0.4
I 'd like to put a lob segment into a locally managed tablespace
configured with automatic segment space management.
I believe you could not place a lob segment in a J.
If it is a hot backup you don 't backup the online redo logs. While
the database is open the redo logs are constantly changing and you
will most likely get an inconsistent copy. Best practicI don 't know but have a look at the most plausible tables from this list
1* select table_name from dba_tables where owner 3D 'repository owner '
and table_name like '%EVENT% '
SQL > /
TABLE_NAHi
I have a two-node RAC environment running on Oracle 9.2.0.6 (64-bit)
Solaris 8 with Veritas "DBE/AC for Oracle 9i RAC 3.5 ". ORACLE_HOME is on
a shared CFS. We have just added a third node to tLarry Elkins wrote
>And why does the process I 'm currently tracing written in C++
>create/populate/drop the *same* GTT 10 000+ times -)
>
>
>
Because the process has been developed by a Run this "safe " command on unix
> alert_db.log
> listener_db.log
On Windows you can just run
echo " " > alert_db.log
echo " " > alert_db.log
Cheers
Dimitre Radoulov
ETN?TEAM
-We had a case where having it to anything different then zero was
simply not acceptable )
As the create of a row and the immediate update of the row afterwards
were happening on different nodesHello.
asktom is busy I guess
Let me try my luck here.
Can you please explain 20
1. Why CBO considers semi-join on a collection in "IN-LIST ". Such course of
20
actions propagates incoI have identified a session that is blocking other sessions in 8.1.7.0.
The session is coming accros a db_link from a 9.2.0.6 database.
How do I identify the sid of the session in the 9.2.0.
If anyone gets a chance to look at this stuff please
let me know how they look
----- Forwarded message from TechRepublic <TechRepublic@(protected) > -----
TechRepublic - Real World. Real TiDepends on the version. But in some yes it can. see
Note.292034.1 WRONG RESULTS FROM QUERIES ON TABLES CONTAINING USER-DEFINED
TYPES
Bug 4007071 - Wrong Results Selecting From User-Defined TDBAs here remain busy even if
-----Original Message-----
From Spears Brian [mailto BSpears@(protected)]
Sent Tue Jun 14 17 31 13 2005
To Les.Hollis@(protected) ganstadba@(protected) OrOn 6/9/05 deen dayal <deen.dayal@(protected) > wrote
> i am asked to come up with a HA solution for a database running in DMZ la
yer.
> i have to create a standby database in another network |
|
|
