 | | | Oracle List | | Jacinta
> I need some help here. I need to get a report of all
> the table that are empty on a schema.
A quick way to determine whether a table
is empty regardless whether there are milionsI am attempting to use automatic shared memory management in oracle 10G but
having set the sga_target value and attempted to bounce the database I get
the error
ORA-00093 _shared_pool_reserved_Hi all
Anybody tried Oracle 10g Beta or has that installed on
his system.
I am very interested to know did Oracle speed up
XMLType insertion.
We stick with XMLType because developers like
On 01/23/2005 11 06 42 PM Kean Jacinta wrote
20
> I need some help here. I need to get a report of all
> the table that are empty on a schema.
You could run something like DBMS_STATS.GAHi
I recently noticed this
http //www.puschitz.com/SecuringLinux.shtml
Its good. I wish I had read it /before/ setting up a few of my LINUX boxes. -)
Some of his ideas will give SOX-interhttp //www.cltoug.org/
Server 2
Error #1500
The page you requested is temporarily unavailable. Please try again.
If you are the owner of the site and you feel you are seeing this page in eHi
I restored (rman inconsistent) a 10.1.0.3 DB to a new LINUX RHEL3ASU2
host and I had problems with the standalone EM Repository. Basically
the original 'host.domain ' was still in the repos
Need some help.
Developer has a wide table...20 columns.
He would like to add a 21st column to the table.
Then he would like to (be able to) store the first 20
20 columns data in concatenated My customer want to use linux as database server maybe oracle9206+rhel3
But i 'm wonder which is the most popular cluster software in linux box?
I found a Linux HA project at this web site http //wHow about just using to_char ? or try making the SQL dynamic ie
open cursor for '.... '
hth
connor
--- "Duret Kathy " <kduret@(protected) > wrote
> PROCEDURE BA_TRD_PROC(
> PROCEDURE BA_TRD_PROC(
P_ALL_ROWS_CURSOR out cursorvar
P_START_DATE in EV.TRDDATE%type
P_END_DATE in EV.TRDDATE%type
)
is
begin
open P_ALL_RIt 's got to be something obvious which would
make this an embarassingly naive question but here goes. 20
I 've got a table "tab " and a partition "part "
i do alter table tab truncate partitiJ.Velikanovs@(protected) wrote
>I have need to kill one of my shell scripts in case of timeout is off.
>
>
Murderer!
>Not just single process but all that is relative to it.
>
>
Have yHi Robert
The direct deletion from the table is unsupported from
Oracle but the strange thing is that Oracle method to
get rid of messages is very simple based on the
background process removiIncorporating pkill may simplify this a bit.
With -P you can specify a parent process killing all the children.
On Fri 21 Jan 2005 22 26 00 +0200 J.Velikanovs@(protected)
<J.Velikanovs@(protected)
Hi list 0A 0Ahere is an output of the autotrace from the following sta
tement
select * from fa where fakt_art 3D 'BES ' and fakt_nr between 5300001 a
nd
5300010 0AExecution Plan
-----------A mid-size company west of Boston is looking for an experienced Oracle
DBA. The ideal candidate would come from a development background but
should be also comfortable supporting critical Oracle 7 Further to my previous reply I can now confirm that
ater releases of appserver -10g have a method 20
Of changing hostnames and IP addresses that works.
There is a script called chgiphost tht does Does anyone have an example of specifying singlerow in sqlldr as I am
strugging to figure out the syntax
--
http //www.freelists.org/webpage/oracle-l
Hi Paula
>Other then use sort_area_size to sort in memory and parallel query what
>can be done to optimize a pull of 2 large tables joined together where
>most of the rows from both tables are seI saw the note but missed the bug. Great. I 'll see if this is
relevant (although ours is not a Windows installation). Also it 's
10.1.0.3 so supposedly the problem is fixed.
Adam
ParkerCheck out 20
Note 285906.1
And previous bug for 10.1.0.2 (3599503). 20
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Adam Folks
We 're encountering an ora-600 from the following statement run in
against a 10g database
ORA-00600 internal error code arguments [qctVCO csform] [0] [0]
[0] [0] [1] [1] [0I thought that hash value and address uniquely identify SQL statement?
From the following SQL
it 's obviously not the case. Is there any other way of uniquely
identifying them? It 's 9.2.0.5 on Create the index separately.
Also if you install the 10g "Companion CD " or as I like to call it
"Disk 2 " (contains java apache HTML DB etc.) it must go under its
own Oracle home.
Seems 10g "Companion CD " contains 9i
If you have Oracle Support get on to Metalink and open a TAR.
I think the correct subject heading for this type of TAR is "Version
Update Request "
But any way if you have support and it is a Is the Uniform allocation has any advantageous than SYSTEM allocation type?
Does the SYSTEM allocation type has any issues?
Raja.
-----Original Message-----
From Smith Ron L. [mailto rlsmithI 'm running into a problem on one of our systems where a query on
dba-segments is running incredibly slow.
The full query is
select 'alter index diamond '||segment_name|| ' rebuild tablespace tm9.2
I 'm trying to load a file that has a field that can be > 4000 characters.
external files don 't let you use a clob so I 'm using a varchar2(4000).
problem is I don 't want any rejected records but |
|
|
