Didn't know this one ! Diem non perdidi.
But it seems to be the same as select global_name from global_name (on the database on
which I have tried, both are suffixed with a .WORLD); for what I remember from my
numerous databases cloning, the global name is something which is distinct from the
Hi
Gurus,
How do I convert a long datatype to clob datatype.
Say Table A
No number
Col1 long
Would like to convert to
Table A
No number
Col1 clob
Alter table A modify (col1 clob);
Gives an error as inconsistent datatypes.
Could you give me an example of this with
Where?
I can only see 9.2.0.2 on the otn download site..
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
[EMAIL PROTECTED]Sent: 11 September 2003
01:20To: Multiple recipients of list ORACLE-LSubject:
Re: 9.2.0.4 anyoneYeah,
been out
create table newtab select no, to_lob(col1) col1
from table1;
it's better to create the table first and then use
insert +append, that way you control better which datatypes your columns will
have.
Tanel.
- Original Message -
From:
Siddharth
Haldankar
To: Multiple
According to a very reliable source the book will be delivered to O'Reilly's
warehouses on September 17.
Gudmundur
Cary,
Is your new O'Reilly book Optimizing Oracle Performance out yet?nbsp; Do you have
an estimated date?
a T d H v A a N n K c S e,
Carol A. Pena
Men's
Heh,
notice the phrase next to nothing. I didn't get it free but I got it for
about 28 pounds plus postage and handling. Compared to the price of ordering
up a standard product that's a fairly reasonable price.
Sorry if I wasn't very clear on that point.
Regards,
Mike
-Original
Sorry, I didn't notice in the end of your post,
that you don't want to recreate your table.
Then try this one:
add a new clob type column to your table using
alter table add.
make an update statement:
update tableA set col1=null,
newcol=to_lob(col1);
use alter table drop column col1
Hi!
Yes, the problem with own scipts was, that they tended go get old,
especially when the same Oracle7 scripts were used for creating 8i
databases etc..
Novadays there's lot more to do than just run create, catalog catproc to
create a full blown database.
Tanel.
- Original Message -
It's available as a patch from Metalink.
Cheers,
Mike
-Original Message-
Sent: 11 September 2003 10:59
To: Multiple recipients of list ORACLE-L
Where? I can only see 9.2.0.2 on the otn download site..
-Original Message-
[EMAIL PROTECTED]
Sent: 11 September 2003 01:20
To:
9.2.0.4 is a patchset - go to Patches section in
metalink.
Tanel.
- Original Message -
From:
Mark
Leith
To: Multiple recipients of list ORACLE-L
Sent: Thursday, September 11, 2003 1:59
PM
Subject: RE: 9.2.0.4 anyone
Where? I can only see 9.2.0.2 on the
Thanks about this tip, I didn't know about this one :)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 4:59 AM
How about SELECT ORA_DATABASE_NAME FROM DUAL;
HTH
GovindanK
select
Where?
I can only see 9.2.0.2 on the otn download site..
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
[EMAIL PROTECTED]Sent: 11 September 2003
01:20To: Multiple recipients of list ORACLE-LSubject:
Re: 9.2.0.4 anyoneYeah,
been out
Robert,
you say yet like you are expecting problems? :)
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, September 10, 2003 6:24 PM
To: Multiple recipients of list ORACLE-L
Anyone have any negative experiences with 9.2.0.4 yet?
Robert
--
Please see
Hi Gurus,
Can anyone suggest
me a good book or links for material on how to estimate and size tablespaces and
database, before creating the same. I need to plan my database before I actually
go down to create it.
Thanks to all in
advance
Best
Regards
Munish
Bajaj
Hallo,
Anyone whom could tell me if it is in an sqlloader possible to write for instance this
if you dont know the exactly name of file.
infile '/d31/datafiler/sema/incoming/konkurrenter.*'
If there are going to be files with different extensions fo rinstance the first time a
file is going to
Thanks Tanel,
But to_lob does not work in update clause, it only works in
select clause, that is the restriction it has.
With Warm Regards
Siddharth Haldankar
Cisco Systems Inc. ODC
Zensar Technologies Ltd.
# : 4128374
[EMAIL PROTECTED]
[EMAIL PROTECTED]
I hope you were being sarcastic there Mladen...
Patrice.
-Original Message-
Sent: Wednesday, September 10, 2003 7:59 PM
To: Multiple recipients of list ORACLE-L
Nope, that's what voting machines are invented for.
They work almost perfectly in almost every state.
--
Mladen Gogala
Hi,
this statement returns the GLOBAL_NAME value rather than the database name.
Admittedly the 2 should usually be the same but often (following a database
clone for instance) it is not correctly set.
Regards,
Mike Hately
- Original Message -
To: Multiple recipients of list ORACLE-L
Just 2 minor ones on the
upgrade so far - it had to have the compatible init parameter set - otherwise it
tried to default to Ora 8 and I am using LMT's so it complained. Also I had a
problem with the listener not being able to connect, so I deleted and recreated
a new one - everything
I have been struggling with an asp-based IIS web application one server, it
is tarting to look like a global asp variable is not being passed down to a
local asp variable.
Has anyone ever seen this type of thing before?
I have had a number of problems with this system, I am starting to wonder
One more thing my database is 8.1.7, think this alter table
modify from long to clob is 9i feature
With Warm Regards
Siddharth Haldankar
Cisco Systems Inc. ODC
Zensar Technologies Ltd.
# : 4128374
[EMAIL PROTECTED]
[EMAIL PROTECTED]
-Original Message-
From:
I wonder if there is a list somewhere of all the nice things DUAL can say.
: )
Patrice.
-Original Message-
Sent: Thursday, September 11, 2003 8:05 AM
To: Multiple recipients of list ORACLE-L
Thanks about this tip, I didn't know about this one :)
Tanel.
- Original Message -
The way I handled a similar situation was to create a default SQL*Loader
file with something recognizable in the place that you want to do the
substitution (in your case, the infile filename). Then, I wrote a shell
script that created the correct filename and copied the default
SQL*Loader file to
Hallo,
Anyone whom could tell me if it is in an sqlloader possible to write for instance this
if you dont know the exactly name of file.
infile '/d31/datafiler/sema/incoming/konkurrenter.*'
If there are going to be files with different extensions fo rinstance the first time a
file is going to
Linking issues with installing 9.2.0.4 patch on HP/UX...
Had migrated a 8.1.7 database inplace to 9.2.0.2 whcih went fine and went to
apply 9.2.0.4 patchset and the relink splattered all over the place. Patch
requirments were vauge at best and found a list of required OS patches on
HP's tech site
I believe Mr. Ellison is responding to a lot of market pressure, and failing DB sales.
I know it would be a relief here to see this inplace soon, but as always the DEVIL
is in the details.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday,
1) Write a perl script which will rewrite the control file on the fly.
2) Write a script which will generate a symbolic link for the file du jour.
3) Do PURGE *.txt/KEEP=1 (I couldn't resist, it was the best OS ever).
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL
Just a guess - but you
might need to create / configure a provider for forms - also you might check
your display setting in the conf file.
[EMAIL PROTECTED] 9/10/2003 4:49:29 PM
Hi
NT
2000
Oracle
9.0.2.0.1
Oracle 9ias
9.0.2.0.1
Installed infrastructure and tested
Actually, I was wondering why Robert would care about 9.2.0.4 since his 10g
New Features book (Oracle Press, 0-07-222947-0) is due out this December.
Isn't 9i a little passé? :D
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech
Hi!
I wouldn't call it a real negative experience, but:
C:\Work\Oraclesqlplus admin/admin
SQL*Plus: Release 9.2.0.4.0 - Production on N Sep 11 17:21:59 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 -
There should be a low level pricing for home users, so that people who
download oracle may use metalink. I would pay for home support if it was
something like $150/ year for my Linux box. There should also be a low
price for small companies wih 16 users. One should be able to buy a 16
users
when i get a failure and oracle writes to my alert log, the job number does not match
to the one in dba_jobs.
any way to map these two different numbers? other than figuring it out from the error
message and the 'what' in dba_jobs?
--
Please see the official ORACLE-L FAQ:
I used to work for a large but non profit organisation (.org) and we were
using Oracle, the sales rep never send us Christmas card for sure
Stephane
-Original Message-
Mladen Gogala
Sent: Thursday, September 11, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L
There should
It's probably just someone executing some arbitrary code on your Windohs
box. At least according to Microsoft Security Bulletin MS03-039 pushed out
yesterday (Sep 10).
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc,
I've created a physical standby database that seems to be performing
properly, but there's no alert log in user_dump_dest, nor anywhere else
on the machine. Is there no alert log until/unless the standby
undergoes a role transition?
TIA
=
Paul Baumgartel
Transcentive, Inc.
I got a mail from a recruiter searching for Senior
Oracle Developers.
"Minimum of four years hands-on application
programming experience using Oracle RDBMS, including two years using Oracle
version 8.0 or higher on large databases (20 or more Oracle
tables)."
I've always wondered, where
That same mentality applies to organizations with 100-200 users! After the
latest meeting with the Oracle rep, damagement is seriously considering
alternate database systems.
Abey.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September
There
must be a "G" missing there. It should be "(20G or more Oracle
tables)".
Guang
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Tanel PoderSent:
Thursday, September 11, 2003 11:49 AMTo: Multiple recipients of
list ORACLE-LSubject: What
This seems strange to me, because things are written to the alert log file when the
instance starts, even when the database is not opened.
It should have been background_dump_dest (not user_dump_dest) and sometimes stuff is
written to $ORACLE_HOME/rdbms/log.
If you have looked for the file with
This appears to be standard appearance. The
browser is not trying to display anything else. All you have done after you
press the OK is close the form. After forms closes it simply keeps the gray box
there.
-Original
Message-From: John Shaw
[mailto:[EMAIL PROTECTED]Sent:
Title: RE: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6, 8.1.7, 9.2.0
Before I begin
I have an rman catalog currently in 8.1.7
it supports catalogs for databases in 8.0.6
I wish to migrate using database migration assistant to 9.2.0 and keep the older catalogs in-place.
Unless they have radically changed how they handle physical standby
databases, you should have an alert log for that database.
Have you logged in as sysdba and checked the location of the
background_dump_dest in v$parameter?
--- Paul Baumgartel [EMAIL PROTECTED] wrote:
I've created a physical
You need to configure your TNSNames in your 9i Box.
Luis
-Original Message-
Sent: Monday, September 08, 2003 3:39 PM
To: Multiple recipients of list ORACLE-L
Dear List,
I have two database one on 8.1.7.4 on sun Solaris 8.2 and another one on
oracle 9.0.1(two separate box) I have
Oracle9.2.0.4 on Windows.
I installed it yesterday and upgraded my test database, with OID, and it
worked fine.
It is available since 15AUG2003.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 12:24
Do you have any more info??
If it's a variable problem, then try tracing (response.write) the global
variable locally, if it shows nothing, then that's the problem (IIS acting
childish again!!), if it does then check the connectivity by testing ODBC...
I've had no problems with either Microsoft
Initial testing indicates that the bug(s) that caused index create/rebuild
online to lock a table and then get permanently stuck in a hung state have
been fixed.
It looks like 9.2.0.4 does NOT fix the problem of fatal 4031 situations that
can only be cleared by restarting the instance. So you
This is because you have the Applet loaded and that grey portion is the applet portion whose height and width is been defined in your dynamic HTML file generated by Forms servlet. This applet is used to talk to the Forms and displays them on the browser and after pressing the OK button, you are
Tanel,
Thanks. By the way congrat for becoming an OCM
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 11 Sep 2003 03:19:24 -0800
Hi!
Yes, the problem with own scipts was, that they tended go get old,
especially when the same
Alternately check in $ORACLE_HOME/dbs directory for alertSID. log. I
observed that people are still using defaults while creating databases
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 11 Sep 2003 08:24:26 -0800
Unless
Speaking of non-profit organisations, what is Oracle's policy on that?
Do they sell Oracle software to non-profit groups?
Probably it's a small market at best, but Personal Oracle might meet their
needs.
Another group that comes to mind are high schools and colleges, they might
want to purchase
It's not trying to load another form. When you click OK, you get gray
box. If you look into test.fmb, you'll see exit_form; under button OK
John Shaw wrote:
Just a guess - but you might need to create / configure a provider for
forms - also you might check your display setting in the conf
Title: Message
9.2.0.3 catalog works with 8.1.7, that I have tested personally. I don't
have a clue about 8.0.6.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]Sent: Thursday, September 11, 2003
Tanel,
As I am still in the job market looking for any full time assignment, I see
all type of requirements like 5+ years 9i experience etc and will see in
coming weeks same for 10g( 5+ years experience with Oracle 10g)..
What you can do for this when dealing with recruiters who even
Hm, yep, it seems it works only in insert select
command (I tried an update with subquery) but didn't succeed).In this case
try following:
1) if you got partitioning option and have enough
space to store a temporary copy of your table in database, then:
SQL create table t (id number,
It is because of some oxes in HR departments
-Original Message-
Sent: Thursday, September 11, 2003 7:05 PM
To: Multiple recipients of list ORACLE-L
Tanel,
As I am still in the job market looking for any full time assignment, I see
all type of requirements like 5+ years 9i
In Estonian language, the word administrator also means receptionist.
Guess how many former hotel receptionists or whatever security desk
operators I've had to turn down in past when they've looked for DBA job. Oh,
yes, some of them had over 20 years administrator experience in large
Excellent..but most difficult part to pass through recruiters these
days...
Date: Thu, 11 Sep 2003 09:29:24 -0800
It is because of some oxes in HR departments
-Original Message-
Sent: Thursday, September 11, 2003 7:05 PM
To: Multiple recipients of list ORACLE-L
Tanel,
As I am
Can we setup a physical standby on a different OS (Win 2003) than the
primary db (Win 2000).
Thanks in advance.
Murali.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Murali_Pavuloori/[EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Hi...
I'm experiencing a problem with standby databases...
This is what I did:
1.- Setup primary database for failover with and
standby database ...everything ok.
2.- Setup standby database, setup ALMOST ok...
Why almost?, because I put (by mistake):
standby_archive_dest = location=path/x
Hi!
standby_archive_dest only applies in managed recovery mode e.g. when you
issue recover managed standby database.
In regular recovery case logs are searched from log_archive_dests by
default.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
not according to the oracle documentation. A physical standby has to be
on the same platform/same operating system (including patches)/same
database release
logical standby databases do not have to conform to that restriction
--- Murali_Pavuloori/[EMAIL PROTECTED] wrote:
Can we setup a
Nothing is known, except that the call came from the area code 425.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Johnston, Tim
Sent: Thursday, September 11, 2003 1:54 PM
To: Multiple recipients of list ORACLE-L
So that's what happened. OTN says Due to Thursday's events at Moscone
Center, VP Product Strategy Ken Jacobs' keynote has been rescheduled for
11am on Friday., but they didn't say what it the events were.
Bummer for OracleWorld folk that have to catch planes, I guess.
Rich
Rich Jesse
Tanel...
thanks for your input...
both options are placed...
standby_archive_dest for managed recovery (that's the
goal)
and...
log_archive_dest_1 because when Oracle 'looks' for the
archive log files... uses this parameter to find them.
really, my problem is why my db are not synchronized!
Standard life? I thought that you work for Oriole corp.?
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Stephane Paquette
Sent: Thursday, September 11, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L
Subject:
And the database must be muave.
--
Mladen Gogala
Oracle DBA
-Original Message-
Guang Mei
Sent: Thursday, September 11, 2003 12:15 PM
To: Multiple recipients of list ORACLE-L
There must be a G missing there. It should be (20G or more Oracle
tables).
Guang
-Original
/u005/oracle/product/rdbms/admin ls -l dbmstrig.sql
-rw-r--r-- 1 oracle dba 8657 Apr 28 2002 dbmstrig.sql
/u005/oracle/product/9.2.0/rdbms/admin sed -n '76,85p' dbmstrig.sql
Rem returns the current database name
create or replace function database_name return varchar2 is
begin
return
Title: RE: URGENT REPORTS WONT START
Getting error:
REP-50125: Caught exception: java.lang.reflect.InvocationTargetException
One note I found on web said to comment out some tags. Doesn't seem to help.
Any ideas?
At the time, no policy. Yes we were paying for the software.
Small market but a lot of visibility : IATA (International Air Transport
Association), ICAO (International Civil Aviation Organization) those 2 run
Oracle, plus all the UN organizations are non profit organizations.
Stephane
There is at least 2 Stephane : Stephane Faroult (Oriole), Stephane Paquette
(Standard Life)
Stephane
-Original Message-
Mladen Gogala
Sent: Thursday, September 11, 2003 2:50 PM
To: Multiple recipients of list ORACLE-L
Standard life? I thought that you work for Oriole corp.?
--
Mladen
We are getting ready to migrate one of our instances from AIX 4.3.3
to 5.2. Do I need to get different media for this?
Thanks,
Peter Schauss
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Schauss, Peter
INET: [EMAIL PROTECTED]
Fat City Network Services--
Title: RE: how can I see which database I am logged into without
You might get some surprising results from SELECT ORA_DATABASE_NAME FROM DUAL; (see below). I have a DEV database cloned from Prod. and it still lists the Prod. DB name with that query. Where is it reading the name from? You can
And possibly more than 20 tables in the hotel's restaurant ...
Tanel Poder wrote:
In Estonian language, the word administrator also means receptionist.
Guess how many former hotel receptionists or whatever security desk
operators I've had to turn down in past when they've looked for DBA job.
And don't forget file permissions issues either--especially if there
will ever be a firewall between your db and your users. If the docs are
in the db, users won't need OS perms to read/write/delete anything on
the filesystem...
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
What is your point? Mike Hately's statement is still correct. It returns
the global_name which should be, but not necessarily IS, the same as
db_name since it can be set to any arbitrary value. Of course, if you are
using replication you better set it to the correct value or it will not work:
HI,
I was wandering if a lot of people are copying statistics using dbms_stats
from production to test environment to see what will be the access plan.
If not used, why ? no time to look at it, bugged, not usefull ,... ?
Stephane Paquette
Administrateur de bases de donnees
Database
Title: RE: how can I see which database I am logged into without
My point was that you can see different names by using different queries. But, you and Mike brought up a good point- I need to use the alter database rename global_name to XXX after cloning databases to avoid any such confusion.
Good point. Then run the following query:
select name from v$database;
HTH
GovindanK
On Thu, 11 Sep 2003 11:44 , Wolfgang Breitling [EMAIL PROTECTED] sent:
What is your point? Mike Hately's statement is still correct. It returns
the global_name which should be, but not necessarily IS, the
Just a guess..most possibly it is fetching from v$databaseAfter cloning
from production, if you don't change db_name explicitly for dev database ,
it will show production databse name in v$database
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Munish
How close do you need to be on sizing? The most accurate method is to
create a test table, load a sample of your data, analyze the table so you
get data in user_tables. Then you need to figure out the average number of
rows per data block. Then calculate the number of blocks your table
Maybe from service_name in init ora file. David Wagoner [EMAIL PROTECTED] wrote:
You might get some surprising results from SELECT ORA_DATABASE_NAME FROM DUAL; (see below). I have a DEV database cloned from Prod. and it still lists the Prod. DB name with that query. Where is it reading the name
Have you tried the kb?
http://support.microsoft.com/default.aspx?scid=fh;EN-US;kbhowtosd=MSDNln=EN-USFR=0
this one caught my eye:
How to Configure IIS to Connect to Oracle from ASP and ADO
http://support.microsoft.com/default.aspx?scid=kb;en-us;193225
HTH,
-Roy
Roy Pardee
Example given below is for the same user.
/home/govindank sqlplus user/[EMAIL PROTECTED]
SQL*Plus: Release 8.1.6.0.0 - Production
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
With the Partitioning option
Gurus:
How can we find out if XML is installed in DB? I looked @ the v$option and
it doesnot say.
I have queried the dba_users for XDB user...is this the correct way? Please
help.
Thanks in advance.
Murali.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET:
It's sys.props$ if it reflects global dbname.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 11:37 PM
Just a guess..most possibly it is fetching from v$databaseAfter
cloning
from production, if you don't
Hi List,
Has anyone ever seen this erro while creating
interMediatext index? If so please help me out to
resolve the same.
TIA
create index hibm_taxonomy.taxcategoryvalue_value
*
ERROR at line 1:
ORA-29855: error occurred in the execution of
ODCIINDEXCREATE routine
ORA-2: interMedia Text
Title: RE: how can I see which database I am logged into without
When
the database was cloned from prod, did the global name changed (alter databeas
db rename global_name to ...)
Maybe
ora_database_name takes it from global_name.
Stephane Paquette
Administrateur
de bases de donnees
O/S is AIX 4.3.3
/usr/sbin/bootinfo -p returns chrp meaning that the hardware is
capable of either 32 or 64 bit operation.
/usr/sbin/bootinfo -K returns 32 meaning that the kernel is running
in 32 bit mode.
When I run sqlplus the server says:
Oracle8i Enterprise Edition Release 8.1.7.0.0 -
how about select from v$database;
bs
-Original Message-
Sent: Thursday, September 11, 2003 9:40 AM
To: Multiple recipients of list ORACLE-L
Hi,
this statement returns the GLOBAL_NAME value rather than the database name.
Admittedly the 2 should usually be the same but often (following
Can you try:
select global_name from global_name;???
compare it with your
select ora_database_name from dual
Are they the same?
HTH
JL
--- David Wagoner [EMAIL PROTECTED] wrote:
You might get some surprising results from SELECT
ORA_DATABASE_NAME FROM
DUAL; (see below). I have a DEV
I don't use it a lot, since our test systems are currently complete copies
of our li'l ol' 30GB production DB. But it's nice to have for things like
the 9i RAC test, where we can't have a complete copy of the data (although
I've yet to try it on there). And it has worked well so far from 8.1.7.4
At my university we were given Oracle licences .. as well as substantial
gifts from Sun (Servers, workstations etc)... that way we finished
University with good working knowledge of Solaris and Oracle on Solaris...
Which is of course in their best interest... :S
-Mensaje original-
De:
How about:
SELECT 'RUMPELSTILSKIN' FROM DUAL;
That should be a good guess.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jose Luis Delgado
Sent: Thursday, September 11, 2003 4:38 PM
To: Multiple recipients of list
By chance, do you have Tom Kyte's latest book? Effective Oracle by Design??
He states his opinion on this approach on page 30, section entitled Test Against
Representative Data.
-Original Message-
Stephane Paquette
Sent: Thursday, September 11, 2003 4:38 PM
To: Multiple recipients
Oh yeah, I forgot to say that in 9.2.0.3 the shared pool was broken up into
heaps (Oracle terminology) but whatever fancy stuff they were trying to
accomplish by doing this (I think part of the magical self-tuning
initiative) was buggy and this hastened the fatal 4031 situation. There is
a
Hi
does a command change backuppiece ... delete delete
the info about a backup piece from a rman catalog only
or does it also delete the backup piece itself from
the tape?
thanks
gene
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design
I use it a lot. I create mock databases where I just load the schema (from
export rows=no) and then copy the statistics on top. That lets me do
what-if scenarios, changing sql, init parameters, statistics, or even the
Oracle version, without impacting anyone. When I find something that looks
Stephane,
No time to look at it enough to do it. Also, not a lot of time is
spent tuning our test/dev environments.
But I'd like to do it.
Stephen
[EMAIL PROTECTED] 09/11/03 01:37PM
HI,
I was wandering if a lot of people are copying statistics using
dbms_stats
from production to test
Funny.
--- Mladen Gogala [EMAIL PROTECTED] wrote:
How about:
SELECT 'RUMPELSTILSKIN' FROM DUAL;
That should be a good guess.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Jose Luis Delgado
Sent:
Hello list, seeking your personal opinions and experiences about
db_file_multiblock_read_count.
What do you all set your db_block_size and db_file_multiblock_read_count
to?
How did you all come to decide that those values would suit your systems ?
Any windoze user here who can tell me how can
1 - 100 of 115 matches
Mail list logo