They were probably referring to MS patches
Cheers
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical Consultant WWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane, Australia
U r right ..I still dunno 'much' about perl..
as for dbms_metadata
it is a built in pl/sql package
saying
'select dbms_metadata.get_ddl(object_type,object_name,schema_name) from dual;
gives the entire ddl creation script.
However, 'interestingly'
execute dbms_metadata.get_d
Dear All,
I have been entrusted to tune a web based application. This product is at development
stage. I generated the trace file and found out the indexes on the table. So I
specified hints in all the queries and tested the application. There was a remarkable
increase in performance. Can any
I am sorry, this is dangerously close to offtopic
humor, and you'll have to move your old ass to
the off topic list, where we can pump you up
with Viagra, and return your sense of youth, humor,
and satisfaction to you.
-Original Message-
To: [EMAIL PROTECTED]
Sent: 1/3/2002 9:13 PM
>> Why do a large number of postings refer to "MetaLink" as "MetaStink" (or
>> "fetidstink") ?
>> The only problem I have with MetaLink is that patch downloads fail
>> mid-way [yes, this is
>> a "stink" problem particularly when I have downtime on the server but
>> don't have a patch ready !].
feel free to use the correct term, and i'll feel free to use metalstink :)
joe
[EMAIL PROTECTED] wrote:
>
> Why do a large number of postings refer to "MetaLink" as "MetaStink" (or
> "fetidstink") ?
> The only problem I have with MetaLink is that patch downloads fail mid-way
> [yes, this is
>>> [EMAIL PROTECTED] 4/1/2002 5:05:29 >>>
> If I do a customized install, is it going to fowl up the stuff that has already been
>installed?
Only if you're chicken. Or act like a turkey.
(Sorry for this poultry contribution :-)
***
Just think of it as a term of endearment
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, January 03, 2002 6:50 PM
To: Multiple recipients of list ORACLE-L
Why do a large number of postings refer to "MetaLink" as "MetaStink" (or
"fetidstink") ?
The only problem I have with MetaLi
Ok I guess I deserve any comments that come out of this. Take the K out
of that.
-Original Message-
Smith
Sent: Thursday, January 03, 2002 6:50 PM
To: Multiple recipients of list ORACLE-L
I received the same bonus with my company. Not offered anymore though.
That was
back when compani
i find the ordered hint extremely helpful...
so i usually find myself using this hint...
what is your opinion on using hints inside views?
thanks.
--
Maria Aurora VT de la Vega (OCP)
Database Specialist
Philippine Stock Exchange, Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafa
I received the same bonus with my company. Not offered anymore though.
That was
back when companies where flashing around the big bucks.
-Original Message-
Baumgartel
Sent: Thursday, January 03, 2002 9:25 AM
To: Multiple recipients of list ORACLE-L
Wow, Joe, $1000K for taking the tests
Why do a large number of postings refer to "MetaLink" as "MetaStink" (or
"fetidstink") ?
The only problem I have with MetaLink is that patch downloads fail mid-way
[yes, this is
a "stink" problem particularly when I have downtime on the server but don't
have a patch ready !].
Let's be gracious
Well, if "performance" is all that important, I guess
there is always Viagra?
(signed)
el fundamento viejo
ORACLE-L Digest -- Volume 2001, Number 363
> --
>
> From: "Mohan, Ross" <[EMAIL PROTECTED]>
> Date: Fri, 28 Dec 2001 15:55:32 -0500
> Subject: RE: DBA_TAB_
Title: Export via pipe ksh script
Here's one:
#!/bin/ksh # #
** # /etc/mknod
/u14/ORA_DUMP/arc_tadrcv.dmp p compress < /u14/ORA_DUMP/arc_tadrcv.dmp
> /u14/ORA_DUMP/arc_tadrcv.dmp.Z & exp
parfile=$HOME/exp_arc_tadrcv.par file=/u14/ORA_
Is this what you are looking for?
#!/bin/ksh
mknod /tmp/exp_pipe p
compress < /tmp/exp_pipe > export.dmp.Z &
exp file=/tmp/exp_pipe userid... log.
Rob Pegram
Oracle Certified DBA
--- Thomas Jeff <[EMAIL PROTECTED]> wrote:
> Could someone please send me a ksh script for doing
> imp/exp via
(Sorry to spoil everyone's fun)
I'll probably have to know this fairly soon, so I looked it
up.
Oracle has certified the 9i client and 9i server for
WindowsXP Pro (but not the Windows XP "Home" version).
>From MetaStink:
---excerpt---
General Notes For Oracle Server - Client On Microsoft W
Title: Export via pipe ksh script
From http://www.orafaq.com (in the sig for this
list):
Can one export to multiple files?/ Can one beat the Unix 2 Gig
limit?
From Oracle8i, the export utility supports multiple output
files. This feature enables large exports to be divided into files w
Yes Virginia, you can have two instances with the same name on the same Unix
server. We use them to upgrade database versions. The old one remains
intact until the users accept the new one. All we change is the listener
parameters for the ORACLE_HOME. An that's the trick; the ORACLE_HOMEs have
I went from fertilizer industry to oracle and things
worked out ok. from what I've seen, going from
networking to theatre seems like a similar natural
progression.
Date sent: Thu, 03 Jan 2002 01:05:21 -0800
To: Multiple recipients of list ORACLE-L
<[EMAIL PRO
Kathy,
It's been awhile since I've dealt with distributed databases, so I can't
recall some of the details clearly.
This is just a prelude to telling you there's more than one way to do it,
but the only one I can recall at the moment is the easiest one. :)
Recreate your database link to connec
Title: Export via pipe ksh script
Could someone please send me a ksh script for doing imp/exp via a pipe.
We're running AIX 4.3.3.
Thanks!
Jeffery D Thomas
DBA
Thomson Information Services
Thomson multimedia Inc.
Email: [EMAIL PROTECTED]
D
Ha!
Too little too late.
Jared
Joe Testa
Dear Gurus,
I have a Sun machine with Solaris 2.8. As per Oracle 8.1.7
installation documentation, the compatible solaris versions are either
2.6 or 2.7. It did mention 2.8.
Will there be any problem, if I install Oracle8.1.7 in this
machine having Solaris 2.8?
Thanks for h
Ok let's start over.hopefully this will be clearer.
I created a public database link owned by system, system is the user I created the
database link under.
created in my Production database:
create public database link ARCHIVE
connect to system iden
Actually, I passed it on to my supervisor with a brief
(cynical) comment.
Stephen>>> [EMAIL PROTECTED] 01/03/02 03:35PM
>>>Paul, just goes to show how many people on the listserv have me
in theirkillfile, since you're the only one that caught
it.joePaul Baumgartel wrote:> > Wow, Joe,
$
I have downloaded two of the 9i zip files from the OTN software site. I
have one more to go and have not been able to get connected all day. Anyone
know if there is a problem with the OTN site?
Thanks,
Ken
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
Patrice,
If you want to be able to run under sqlplus you can edit the utllockt.sql
script:
search for the set charwidth line and comment it out and add a column line
as below:
--set charwidth 17;
COLUMN waiting_session FORMAT A17
Note that the modified script won't work under svrmgrl - I haven
Paul, just goes to show how many people on the listserv have me in their
killfile, since you're the only one that caught it.
joe
Paul Baumgartel wrote:
>
> Wow, Joe, $1000K for taking the tests? That's what I call an
> incentive! ;-)
>
> PB
> --- Joe Testa <[EMAIL PROTECTED]> wrote:
> > Kim
Again, I beg to differ (with you and the others who questioned my
reponse), and I stand by my earlier post.
Oracle's "alter user" syntax allows for zero, one, or any number of the
user's granted roles to be designated as "default"; from the manual:
DEFAULT ROLE
Specify the roles granted by defau
Hi Rod,
You should be able to create a test database by running the Database
Configuration Assistant. Not sure about Pro*C but I believe adding them
shouldn't affect anything else.
John
[EMAIL PROTECTED] wrote:
>I have installed Oracle 8.1.6 on a Windows 2000 system. I would like to instal
That's not quite the way it works.
When a role is granted to a user, it automatically becomes a default
role for that user. A role is made non-default via an "alter
user...set default role..." statement. If such a statement is never
executed for a user, then all of the user's granted roles rem
what is the user in the db link. it it "b" or some other user?
babu
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 03, 2002 4:30 PM
> the db link is a public one owned by system.
>
> User B is only in Bshema. User A with the
dbms_metadata, a package that will let you pull ddl for objects out of
the database in a readable format.
joe
Jared Still wrote:
> For those of us that are still 9i ignorant, you will need to
> explain your comment about 'dbms_metadata'.
>
> As for 'Perl expertise', you obviously don't know
Thanks!
Oracle finally got back to me and said I should be all right. They
suggested just running root.sh and continuing with the remainder of the
install steps.
They're looking at the errors in the log file for me now.
Jay Miller
-Original Message-
Sent: Thursday, January 03, 2002 4:3
the db link is a public one owned by system.
User B is only in Bshema. User A with the trigger is only is Aschema.
Kathy
-Original Message-
Sent: Thursday, January 03, 2002 1:16 PM
To: Multiple recipients of list ORACLE-L
in the db link are you using the same user as the table owner
root.sh will update your oratab file. this is needed by many of the oracle
tools. actually the root user can edit the file thru vi and update it/add
the details to it.
also it initializes some other directories - one of which could be your
orainventory directory (i am making a guess here. pl corr
Just moving it is definitely not OK if the directory structures
are not identical. Here's just one example, $ORACLE_HOME/bin/loadjava
---
#!/bin/sh
#
# %W% %E%
#
unset JAVA_HOME
JAVA_HOME=/www/OraHome1/JRE
export JAVA_HOME
JRECLASSPATH=/www/OraHome1/JRE/lib/rt.jar:/www/Or
in the db link are you using the same user as the table owner in the remote
db. in your case are you using the user "b" in your dblink?
babu
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 03, 2002 3:35 PM
> database is 8.1.7
>
I don't know about default roles, but if you have none set as default, all
are active.
At 10:00 AM 1/3/02 -0800, you wrote:
>I think there is a command like: alter user ??? default role all
>
>-Original Message-
>Sent: Thursday, January 03, 2002 12:30 PM
>To: Multiple recipients of list
Well, I opened a TAR with Oracle but they still haven't gotten back to me
and I need to know before I leave tonight (as I might not be leaving
tonight).
I was installing 8.1.7 on a server prior to doing an upgrade this weekend.
Over an hour had passed after asking my SA to run root.sh for me and
database is 8.1.7
how do I grant insert privilege to a user in a different database?
Note: the database link in place in both database and I can describe tables in each
just fine. In the trigger I already have the insert into b.address@bschema. When I
try to execute the
trigger I get insuffi
> George,
>
> Just checked again right now.Following is the result that I got:
>
> SQL> select version_count, count(*) from v$sqlarea group by version_count;
>
> VERSION_COUNT COUNT(*)
> - --
> 1 48241
> 2 9
> 4
i dont think you need a relink all. the path is always taken from your env
variables so it does not need a relink...
may be on some patch levels you might need a relink. try it w/o relinking
and it it works its fine
i have tried it w/o relinking and it works fine...
babu
- Original Mes
Gene,
Don't go there, a MAJOR pain & performance breaker. A good tool for simple
reports, but NOT industrial strength. Been there, done that, damn it still
hurts. I'd recommend a product called Brio instead
(http://www.brio.com/products/overview.html). Otherwise see inline.
Dick Goulet
Whenever you move Oracle software, you must relink. Especially with changes
in the ORACLE_HOME and OS levels.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
If I copy the oracle software directories from one machine to another,
should I run "relink all"before using them? This is an 8.1.6.3
implementation
running under Solaris 2.7. The directory names are different on the new box
(i.e. ORACLE_BASE is not the same), and the O/S patch level is of
Okay... I have been trying to help the programmer on our data warehouse
project to get a nested table loaded... and we are failing miserably...
Oracle 817
AIX unix
We are reading a two tables in one schema, and loading result set into a
table and a nested table in another schema. We run for ho
I have never said that I know all... and I have admitted to being wrong
in the past.
The correct solution was already given... but not in your reply
--- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> I beg to differ. A default role is simply one that is automatically
> enabled (or "set") upon lo
Maybe I'm reading it wrong but with the syntax of
alter user xxx default role all except role [,role]...
and
alter user xxx default role all role [,role]...
according to my book then any combination of none, one, n, all would be
possible.
Iain Nicoll
Duhveloper (I won't surprise anyone here if
Not true. Only one role can be the default role, if specified. If not
specified then ALL are default. That is the only time!
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.comp
I went the ERP route after having been an Oracle DBA for 3 years in 2001
when I was recruited by SAP to become a Basis consultant even though I had
no SAP experience whatsoever (I think there were around 40 of us, many
without any previous SAP experience). They put me in boot camp and fully
traine
Same name on the same server, NO. But for the other review the create
controlfile command.
Dick Goulet
Reply Separator
Author: "Seema Singh" <[EMAIL PROTECTED]>
Date: 1/3/2002 9:05 AM
Hi
Can I have same instance name on same unix server?If yes then
I have installed Oracle 8.1.6 on a Windows 2000 system. I would like to install the
Test database and the Pro C++ wizards which were not installed in the original install.
If I do a customized install, is it going to fowl up the stuff that has already been
installed?
What should I look out fo
Title: RE: upgrade strategy
Use SharePlex for Oracle. Users can continue to do their activity on the primary machine, while you upgrade and test the secondary. Once the upgrade is complete, shareplex then applies the waiting transactions to the target. It's nice, because it can replicate b
I think there is a command like: alter user ??? default role all
-Original Message-
Sent: Thursday, January 03, 2002 12:30 PM
To: Multiple recipients of list ORACLE-L
I beg to differ. A default role is simply one that is automatically
enabled (or "set") upon login. Any or all of a use
Hi
Q) Can I have same instance name on same unix server?If yes then how?
A) No
Q) Can I restore the database with diffrent name.
A) Yes but this is hard by hand but easy if you use Rman
Q) Suppose I have backup of prod instance on one server.
can I create prod1 instance name on diffr
Thanks everyone! Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 03, 2002 10:00 AM
> Hi,
>
> Try
>
> ANALYZE TABLE PARTITION COMPUTE
> STATISTICS;
>
> /Quamrul
>
>
>
> >From: "Ruth Gramolini" <[EMAIL PROTECTED]>
> >Reply
Good reason to do it right the the first time.
Jared - ducking and running :)
Michal Zaschke
Wow, Joe, $1000K for taking the tests? That's what I call an
incentive! ;-)
PB
--- Joe Testa <[EMAIL PROTECTED]> wrote:
> Kimberly, I'm with you and like you I only took the 8 test because at
>
> the time, my employer paid for the tests and gave me a bonus to pass
> them(like $250/test and $1
Maybe you can find something on one of those job websites?
-Original Message-
Sent: Thursday, January 03, 2002 9:30 AM
To: Multiple recipients of list ORACLE-L
I was wondering if anyone has a DBA job description, you know, the type that
HR would want to see. I have finally convinced da
Hi Cherie,
The version_count should be irrelevant of the number of users you have. I
doubt this is a shared memory leak, it sounds like simple latch conetention
based on the number of versions you have of certain queries. If flushing
your shared pool resets the version count for that query, the
George,
I know that you don't support his scripts but do you happen to know if
there is a cat script or something
I need to run to get this view?:
SQL> @whence_invalids
sys.x_$kglob o
*
ERROR at line 33:
ORA-00942: table or view does not exist
I seem to be missing it. I wonder if i
Hi,
There are a number of 8.1.5 bugs that can cause these symptoms. There is
the null-refresh snapshot bug (1348501), and a number of aditional bugs of
whihc may or may not be published (but that are referenced in other notes on
metalink), including, but not limited to
1000866: HIGH V$SQLAREA.VE
I beg to differ. A default role is simply one that is automatically
enabled (or "set") upon login. Any or all of a user's roles may be
default (see the definition of user_role_privs).
May I suggest, Rachel my friend, that *you* RTFM? :-D
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
>
Cherie,
Sounds like a bug:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=132632.1
1193003
This problem was introduced in Oracle 8.1.5
SQL statements may not be shared when they should be. This can increase
Hi all:
My users are considering using Crystal reports as an
ad-hoc tool to query a DSS. They ran into several
issues however using it. I was wondering if someone
out there has ehough experience with that tool to shed
some light.
Issue 1. Whenever Crystal creates a query it only
create a one-pa
Hi,
Try
ANALYZE TABLE PARTITION COMPUTE
STATISTICS;
/Quamrul
>From: "Ruth Gramolini" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: Thu, 03 Jan 2002 05:00:20 -0800
>
>Good morning everyone,
>
>Can anyone give me the co
Hi
Can I have same instance name on same unix server?If yes then how?
Can I restore the database with diffrent name.Suppose I have backup of prod
instance on one server.can I create prod1 instance name on diffrent server
by having same hotbackup data files,archived log files and control files.?
The documented mechanisms for upgrading a db is to use the
migration tool or run the u0xx.sql script on your old
version data files. All this implies downtime which I
cannot afford. How do 24x7 shops upgrade oracle software?
I did the upgrade from 8.1.6 to 8.1.7 with a standby db proce
See
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem8a.htm#2058616
"PARTITION | SUBPARTITION
Specify the partition or subpartition on which you want statistics to be
gathered. You cannot use this clause when analyzing clusters.
If you specify PARTITION
> George/Arun,
>
> Thanks for your helpful replies. This information may help me
> explain the performance problems that peaked yesterday.
>
> I do have timed_statistics set to true and my version is 8.1.5.
and sql_trace? There are some workarounds posted in the bug report for the
timed statist
Ruth,
It is :
analyze table schema.table_name partition (partition_name) compute
statistics;
Repeat for each of the six partitions.
I always do the delete statistics statement first. I've had problems in
the past with
bits of old statistics hanging around and wreaking havoc.
Cherie Machler
I was wondering if anyone has a DBA job description, you know, the type that
HR would want to see. I have finally convinced damagement that I am not a
PC Programmer(my current title) since I write no code directly for end
users. I do nothing but database stuff. I figured someone must have a job
George/Arun,
I see that bug
ORA-0666"Warning. You have pushed the JaredPERL button."
Cause: // You pushed the button.
Action: // Stop it.
-Original Message-
Sent: Thursday, January 03, 2002 10:15 AM
To: Multiple recipients of list ORACLE-L
For those of us that are still 9i ignorant, you will need to
expl
And also, may I point out that most of us are still on
8x and even 7x.
mkb
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> show=y gives you a very unreadable, unusable
> (without major editing)
> file.
>
>
> --- Cyril Thankappan <[EMAIL PROTECTED]>
> wrote:
> >
> > Hi
> >
> > With due a
Title: Pass Oracle 7 to Oracle 9
I'm beginner in the DBA world
I want to pass my DB Oracle 7 in Oracle 9.
Could someone tell me which big points I need to know to do this "passage" in Oracle 9i
which points i must be careful in ?
Benoît NYSSEN
Benoît NYSSEN
Ruth,
Good morning.
To analyze a partition use;
ANALYZE TABLE table PARTITION (partition name) COMPUTE STATISTICS
The same is true for an INDEX and partition.
Hope this helps.
ROR mª¿ªm
>>> [EMAIL PROTECTED] 01/03/02 08:20AM >>>
>
>
> > Good morning everyone,
> >
> > Can anyone give me the
Ruth,
Pl check out dbms_stats package and gather_table_stats procedure in
particular..
Here is an example from my scripts..
execute dbms_stats.gather_table_stats ('DBM','CAMPAIGNS',NULL, NULL,
FALSE,'FOR ALL INDEXED COLUMNS SIZE 150',NULL,'ALL',TRUE,NULL,NULL, NULL);
HTH,
- Kirti
-Origi
George,
Thanks for this tremendously helpful email. Just what the doctor ordered.
Cherie
"George
Sorry - forgot the compute clause:
analyze table {table} partition ({partition}) compute statistics;
likewise:
analyze index {index} partition ({partition}) compute statistics;
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, January 03, 2002 9:20 AM
To
there is a bug with 815 with timed_statistics = true. it will cause your sql
not to be reused from the shared pool. search in metalink for more details..
try setting it to false...
babu
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, J
Smells like a software coding problem on the client side. Can you provide
additional information on how the DB is getting updated? Some
programmers/programs do a 'lock table in exclusive mode' before
inserting/deleting/updating which is totally unnecessary & can cause your
problem. There are t
Ruth
I believe in its most basic form you can do
analyze table partition ()..
eg
analyze table ruth.ruths_part_table partition (part1) compute statistics;
Please correct me if I am wide of the mark, still an infant when it comes to
partitioning and the like.
HTH
Lee
-Original Mes
There are a lot of issues including memory leaks and shared pool problems
that forced us to upgrade from 8.1. to 8.1.7.2
It's Oracle on Solaris.
Contact Oracle Support.
Regards,
Waleed
-Original Message-
Sent: Thursday, January 03, 2002 8:35 AM
To: Multiple recipients of list ORACLE-
For those of us that are still 9i ignorant, you will need to
explain your comment about 'dbms_metadata'.
As for 'Perl expertise', you obviously don't know much
about it.
Jared
On Wednesday 02 January 2002 23:55, Cyril Thankappan wrote:
> Hi
>
> With due apologies to Perl fans and shell scri
Hi Ruth,
According to the docs, the command is :
analyze table {table} partition ({partition});
likewise:
analyze index {index} partition ({partition});
HTH
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, January 03, 2002 8:00 AM
To: Multiple recipi
George,
Not particularly based on the number of users that we have.
See my other reply to Jared for follow-up.
Cherie
"George
Here is what we use which also incorporates using our own definition
of STALE with monitoring on. It includes indexes as well as
partitioned and non-partitioned tables as well as non-monitored tables.
HTH
select 'analyze table ' || '${SCHEMA}.' ||
a.table_name ||
' compute
Is anyone still doing this?
I found this in note 72460.1 on MetaLink:
Note: Moving the SYS.AUD$ table out of the SYSTEM tablespace is not
supported because the Oracle code makes implicit assumptions about the data
George/Arun,
Thanks for your helpful replies. This information may help me
explain the performance problems that peaked yesterday.
I do have timed_statistics set to true and my version is 8.1.5.
How do you define whether a version count is "high" ? Is there
some threshould that you cross w
Another down side of the default database is... the GUI tool that the Oracle
Universal Installer invokes doesn't support locally managed tablespaces, if
I remember correctly.
So you will have to drop most of the tablespaces, then re-create them using
DBA Studio if you want to use the GUI tools.
Title: Problem in rollback segment
Dear All,
Whenever any insert is made in a particular table, one row exclusive lock attained by Oracle, additionally one of the rollback segment is exclusively getting locked.
Also no one can insert into the table till the first transaction is comm
Some people mentioned ERP --> here is a newsletter on ERP, but not limited
to Oracle.
If you enjoy reading ERPCentrals Newsletter, please tell a friend or
colleague about it. Anyone can sign up for a free subscription on our Web
site at http://www.erpcentral.com
e.g. of Oracle-related items:
A
Jared,
We were seeing from 2 or 3 up to a dozen shared pool waits at a time
for about 200 users.
We normally haven't been seeing shared pool waits at all on this
application. It was an unusual one to investigate.
Our developer was extremely concerned about this issue and
brought it to our att
Good morning everyone,
Can anyone give me the command to analyze a partitioned tabled? To analyze
this table unpartitioned I use: analyze table schema.table_name compute
statistics;
I am partitioning it into 6 partitions and want to compute statistics on
each partition.
Thanks in advance,
Rut
>
>
> > Good morning everyone,
> >
> > Can anyone give me the command to analyze a partitioned tabled? To
> analyze
> > this table unpartitioned I use: analyze table schema.table_name compute
> > statistics;
> >
> > I am partitioning it into 6 partitions and want to compute statistics on
> > e
Looks like you're rigth about datatypes restriction. If I use the same
example but define COL as VARCHAR2(2) then it runs fine. I have to
rewrite a lot of my code now. G :-\
Thank you. :-)
Mike
P.S.: Your solution also works.
Stephane Faroult wrote:
>
> Michal Zaschke wrote:
> >
> > Hi al
Dear Gurus,
It is very interesting to read all the different responses to this posting.
I thought that I should add some of my observations during the past few
months of job hunting.
I am a trained accountant and had about 3 years of Oracle Financials
(Functional) experience both as an accou
Michal Zaschke wrote:
>
> Hi all,
> I wrote a script bellow. If it is run on Oracle 8 it runs fine and
> gives me all the result but on Oracle 9i it returns the error ORA-06502.
> Can anybody tell me please why?
> I have found a workaround - instead of
> select col||'x' colu from tbl union
1 - 100 of 103 matches
Mail list logo