How will you make sure that there are no active segments in your current
rollback segments before you remove the datafiles with the OS? Even after
you take the rollback segments off-line, Oracle will continue to use them
as long as they have an active segment.
BTW --- One way to help to avoid th
Hi!
For index, yes, if you use: alter index
rebuild compute statistics;
But don't rebuild your indexes daily, it's an
expensive operation... and you won't gain much from it anyway.
Tanel.
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Se
I see. Thanks.
Guang
-Original Message-
DENNIS WILLIAMS
Sent: Wednesday, July 23, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Guang
Yes, I noticed that after I posted my reply. Typically if this was a
production system I would tend to create new rollback segments, online t
Robert,
Be proud. 37 and published. very good work.
Ron
>>> [EMAIL PROTECTED] 07/23/03 01:34PM >>>
Well I *AM* 37, and I don't feel old. I'm actually the youngest DBA in
my
group, and it seems like I'm always the youngest wherever I go...
Robert
-Original Message-
To: Multiple recipi
Ak,
I just know you can collect statistics while creating index not rebuild
index.
Joan
> AK wrote:
>
> Does index rebuild generates new statistics as well ? How does that
> can hit performance intermediately if I want to rebuild few indexes
> daily just to finish everything in 5 days .
>
> -a
Guang
Yes, I noticed that after I posted my reply. Typically if this was a
production system I would tend to create new rollback segments, online the
new segments, offline the old segments, then change the init.ora. Sometime
later I would drop the old segments and tablespace, maybe after a back
Hi!
The reason might be performance when rollback segments grow and shrink if
optimal is set. (Of course if your RB segments are tuned well enough, that
they won't ever grow or shrink, then DMT isn't an issue)
If you do the change in two passes as you described, which leave the same
names for RB
Title: RE: dba age
Dude, I am 37 and the OLDEST Oracle DBA here... only one DBA older in the company!
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
You will recognize your own path when you come upon it, because you will suddenly have all the energy and imaginatio
Wow, I
remember UFI, iapgen and RPT/RPF, but I started in 1989. Do you remember
SQLPME?
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-From: Michael Kline
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 12:44
PMTo: Multiple
Does index rebuild generates new statistics as well
? How does that can hit performance intermediately if I want to rebuild few
indexes daily just to finish everything in 5 days .
-ak
Do I need to? I thought after all the steps I still have the same rollback
segment names (RBS01-06). The only difference is they will be in LMT now.
Guang
-Original Message-
DENNIS WILLIAMS
Sent: Wednesday, July 23, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L
Guang - Don't for
I was born on 1/10/1961 in Zagreb, Croatia, which makes me 42 years
of age. My horoscope sign is Ursus (6'4", 260 lbs, used to do greko-roman
wrestling, I can still run 5 miles and lift myself on a chin-up bar). People
sometimes confuse my age with the answer to certain question from the Doglas
Ada
Yes, I can.
But I want to call this tablespace RBS because I use this name in all my
other dbs. Just try to be consistent with naming convension.
Guang
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 1:54 PM
To: Multiple recipients of list ORACLE-L
Why are you conve
I claim 36, making me the youngest DBA here.
Of course, myself is the oldest DBA here at 36.
And I is the average of our ages.
Me, myself, and I work pretty well together, if you ignore all the arguments.
> -Original Message-
> From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]
> Sent:
If there is no evidence in the alert log, and no backups/file
copies/incarnations are registered in rman, my bet is that the database isn't
backed up.-Original Message-From: DENNIS WILLIAMS
[mailto:[EMAIL PROTECTED]]Sent:
Wednesday, July 23, 2003 9:50 AMTo: Multiple recipients of lis
Why are you converting an RBS tablespace?
If just an exercise, it's understandable.
If for a production database, just create a new tablespace, new rollback
segments, and then drop the old ones.
Jared
"Guang Mei" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/23/2003 10:24 AM
Please
Let's
see... I remember dirt.. I remember UFI>.
I
remember version 4.1.0 that ran on DOS... PC, PC-XT..
Oracle since 1983...
Good
loaded question.
Maks.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent:
Wednesday, July 23, 2
They are using RAID5, not mirroring, and the database,
for all the bigger it is needs some SERIOUS tuning.
There are procs that are taking over 1 million disk
i/o's to post a move in inventory..
Again, NOTHING in the alert log, just runs and runs,
no alter tablespace, just redo log changes. And n
Tanel,
Thanks. Frankly speaking I have no idea about 'Hitchhikers Guide To Galaxy
book' , however, 42 is a favorite/magic figure on this list.
I think, Jared, now may be getting frustrated with this OFF-topic
discussion so no further response from my side..
Sorry Jared.
Regards
Rafiq
Re
Guang - Don't forget to update your init.ora!
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, July 23, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L
Hi:
I need to convert RBS tablespace (used for rollback segments)
I was afraid of that
--
Performing Remote Agent backup
Media Name: "Media created 7/18/2003 08:00:06 PM"
Backup of "\\FAILSAFE\V$ "
Backup set #11 on storage media #1
Backup set description: "DailyBackup"
Backup Type: FULL -
exactly...
now, i have to say, there is the option to round up/down when necessary
depending on how many gray hairs are showing through the hair color
application and available room lighting...
-Original Message-
Sent: Wednesday, 23 July, 2003 12:15
To: Multiple recipients of list ORAC
I'm
94
I
started working with Oracle back in the late thirties on the Rexall
"Wonder-Math" Mechanical Computing Device. Writing SQL with a machine not unlike
a player piano, we did, for hours on end, then we would feed the boxes of
program reels into the Wonder-Math and stand with oiler c
Well I *AM* 37, and I don't feel old. I'm actually the youngest DBA in my
group, and it seems like I'm always the youngest wherever I go...
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 7/23/2003 12:14 PM
King Arthur: "Old woman!"
Dennis: "Man."
KA: "Sorry.
Hi:
I need to convert RBS tablespace (used for rollback segments) from DMT to
LMT on a 24x7 production machine (Solaris 2.8, Oracle 8173). Here are the
steps I am thinking of taking:
1. create a new rbslmt tablespace
2. create new rollback segments (RBSlmt01, RBSlmt02, ... RBSlmt 06) in
rbslmt t
Hi!
Thanks for the compliment :) But I'm still complete loser compared to some
other guys here, so there's much work to be done.
I think the "42" might very well come from the Hitchhikers Guide To Galaxy
book, if you know what I mean ;)
Tanel.
- Original Message -
To: "Multiple recipien
DBAs are at an intersection, the place where all the data is stored!
Eveyrone wants the DBA to do something for them... and it's never fast
enough.
: )
Patrice.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
Fat City Netwo
King Arthur: "Old woman!"
Dennis: "Man."
KA: "Sorry. Old man! Whose castle is that?"
D: "I'm 37!"
KA: "What?"
D: "I'm 37, I'm not old!"
KA: "Well, I can't just call you 'man'."
D: "Well, you could say 'Dennis'."
KA: "I didn't know you were called Dennis."
D: "You never bothered to find out, did you
So, your answer is 51.667? Sounds about right.
-rje
P> chronologically i'm 50
P> mentally i'm 15
P> physically i'm 90
P> -Original Message-
P> Sent: Wednesday, 23 July, 2003 10:55
P> To: Multiple recipients of list ORACLE-L
P> Now this one is difficult folks ..
P> what is average a
42. And missing a few "experience" fingers...
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
Can "they" point to backup sets from which you
can test recovery? As someone else mentioned,
that's the crucial issue.
There are a couple of possibilities:
Veritas can do volume mirroring, for example.
I haven't used this at the Veritas level but we
do something similar on our Hitachi SAN (to gen
Tanel.
I am personally impressed with your pratical knowledge, based on your
responses to this list. Mostly DBA's particpating on this list is 35+ (may
in the range of 40-45). Only one DBA is 42 years old for the last 5 years.
Guess who Gogala Mladen(don't shoot me as I am your fan). That is hi
you don't have backups. Oracle will only support recovery from hot
backups taken when the tablespaces are not flagged as in backup mode if
you do the backup via RMAN.
Technically, if you are very very lucky, the moon is in the seventh
house and Jupiter has aligned with Mars, you *MIGHT* be able to
Mladen,
Where were you in your previous life? You know, the one where there
was all of the aged wisdom.
I did a google search on Mladen Gogala
Interesting site showed up. Some are listed as 403 forbidden.
Ron
>>> [EMAIL PROTECTED] 07/23/03 12:29PM >>>
I'm only thilteen.
Mladen Gogala
Or
Hi
It isn't possible to hide the structure of the database successfully, as
your customers DBA will access the database and can query its structure
- tables, indexes, constraints etc from the dictionary and work out how
quite a lot of your tables interact. That said if you want to make it
difficul
Hi Thomas
Have a look at V$SESSION_CONNECT_INFO, which shows details of the
network connection of current sessions. This might help you.
Kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step
For an apricot, I am old. For a head of lettuce, even more
so.
But for a mountain I am not even
begun in years.
However, for a man I am just right.
Matt Adams - GE Appliances -
[EMAIL PROTECTED]It will make sense when you stop thinking
logically,and start thinking Oracle-ly - Jim Dr
chronologically i'm
50
mentally i'm
15
physically i'm
90
-Original
Message-From: AK [mailto:[EMAIL PROTECTED]Sent:
Wednesday, 23 July, 2003 10:55 To: Multiple recipients of list
ORACLE-LSubject: dba age
Now this one is difficult folks ..
what is average age of an e
I think that a typical DBA ages so fast that simple measuring
techniques are suspect
-rje
J> insert into dba_tbl values('41'); <--- thats mine
J> do this for all of the "experienced" dbas
J> select avg(age) from dba_tbl;
J> :)
J> joe
J> AK wrote:
>> Now this one is difficult folks .
For something a little different, play with the attached free.sql script.
-Original Message-
where can i find a script to find segments which can't extend due to low of
space in tablespace .
-ak
free.sql
Description: Binary data
Coming from the perspective of one who has needed to get to a DB structure
of a purchased app, you might have some luck using obfuscation. Ever try to
reverse engineer an 800-table schema with no RI? It can be done (we've done
it), but with the help of the app source.
One other 3rd-party app has
Michael
Don't discount the possibility that they are just using Veritas to back
up everything on the Oracle server. Not correct, but I've seen people that
know nothing about Oracle do that.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message
AK - Don't fear, you may feel young now, but working as a DBA ages you
really fast. The other day the discussion drifted into chopping fingers for
making mistakes. Before safety couplings were adopted, the experience of
railroad brakemen was judged by the number of fingers missing. Maybe we
should
I fully agree with Dennis. Even some applications like Oracle Finanacials
11i requires that min db_block size should be 8K. About 32K size, may be
some OS not support that size but 16K is much better for OLAP environment
and we have been using 8K for OLAT and 16K for OLAP/DSS.
Regards
Rafiq
R
I found no signs of
RMAN being used in
any way shape or
form...
I've been told they
are doing "hot" backups
using Veritas...
HOWEVER, the alert log shows
no signs what so
ever of "alter tablespace
xyz begin/end
backup"...
Can it do a good
backup backing up live
DB files and
leaving
...and young enough to go ahead and do it anyway! Woooh!
-Original Message-
Sent: Wednesday, July 23, 2003 9:30 AM
To: Multiple recipients of list ORACLE-L
simple answer:
old enough to know better
:)
--- "Goulet, Dick" <[EMAIL PROTECTED]> wrote:
> Now that's a LOADED question w
10G
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas
You will recognize your own path when you
come upon it, because you will suddenly have all the energy and imagination you
will ever need.
~ Jerry Gillies ~
-Original Message-From: Goulet, Dick
[mailto
AK, this is a very old script.
set pagesize 999
spool extent.lst
ttitle 'Database Objects that will have Trouble Throwing Extents'
column owner format a10;
column segment_name format a22;
column segment_type format a10;
column tablespace_name format a14;
column next_extent format 999,999,999;
We all know that the universal answer that requires a number is ...42
I just had my 58th. Gray hair, kids, grand kids and 7 years from
retirement.
Ron
>>> [EMAIL PROTECTED] 07/23/03 11:54AM >>>
Now this one is difficult folks ..
what is average age of an experienced oracle dba ?
-ak
--
Please
> what is average age of an experienced oracle dba
42?
Þessi póstur var sendur með vefpósti mi, http://www.mi.is
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gudmundur Josepsson
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fa
simple answer:
old enough to know better
:)
--- "Goulet, Dick" <[EMAIL PROTECTED]> wrote:
> Now that's a LOADED question which I'm sure many a individual on this
> list will resist answering.
>
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -Original Message-
>
I'm
only thilteen.
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 11:55
AMTo: Multiple recipients of list ORACLE-LSubject: dba
age
Now this one is difficult folks
Hussain
I think Joe and Dick both make excellent points. The key to understanding
your product probably doesn't lie with your database structure. Most vendors
do this well enough just by having obscurely named tables and columns. Most
sites buy Oracle because they expect to use it on an enterpri
where can i find a script to find segments which
can't extend due to low of space in tablespace .
-ak
--- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote:
> Paul,
>
> remember it is a trigger ... so it runs under executing user's privs
> ...
>
> 1. everyone needs a direct grant for execute on dbms_session
Been there.
> 2. there needs to be a public synonym for dbms_session
Done that.
> 3.
Experience can be tricky, I know experienced DBA and developpers with a
lot of years of experience and they're still junior in my mind, they're almost
at the same level as when they started with Oracle.
On the
other hands, I know some people who have been DBA for 3 years and are very
very
insert into dba_tbl values('41'); <--- thats mine
do this for all of the "experienced" dbas
select avg(age) from dba_tbl;
:)
joe
AK wrote:
Now this one is difficult folks ..
what is average age of an experienced oracle dba ?
-ak
--
Joseph S Testa
Chief Technology Officer
Data Manageme
Now
that's a LOADED question which I'm sure many a individual on this list will
resist answering.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 11:55
AMTo: Multiple recipients of list
Syed
The statement I received from an Oracle instructor is that the ability to
handle blocks of a different size are in 9i for one purpose and one purpose
only -- so you can bring a transportable tablespace from another database.
Specifically, if you have databases with several block sizes you w
Hussain,
As someone who has to support third party, purchased applications it is my
firm belief that you want to make this as transparent as possible. Why, because no
data system purchased today will operate in a vacuum. They have to be integrated into
the remainder of the application
Hi!
I would look at program column in v$session... it should show oracle or
something similar there if the connection is initiated by another Oracle
server.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 23, 2003 6:39 PM
Ok, use this I found on metalink:
event="1722 trace name errorstack level 3"
what about the level 3? What are my options here?
thanks.
-Original Message-
Sent: Wednesday, July 23, 2003 10:20 AM
To: Multiple recipients of list ORACLE-L
List,
I need to trace for a specific Oracle err
>From past experiences, the only client I've seen using 9iAS is the one being
Oracle wall to wall (and Oracle was a partner in the business, a big
bio-tech startup).
All the other clients running on Oracle databases were using BEA Weblogic or
IBM Websphere.
Stephane Paquette
Administrateur de bas
Now this one is difficult folks ..
what is average age of an experienced oracle dba
?
-ak
Hi,
The Oracle http server (OHS) is a collection of
three distinct feature sets.
1 - Web Server based on the proven Apache
technology. It also provides support for WebDAV, with Oracle9iDB as a
backing store. The Proxy Plug-In component allows Oracle9iAS to be used with
other web servers
David,
You can try this, I think. -joan
alter session set events '1722 trace name systemstate level 10';
"Ehresmann, David" wrote:
>
> List,
>
> I need to trace for a specific Oracle error number, ORA-01722. Any
> suggestions would be appreciated.
>
> thanks,
>
> David Ehresmann
> --
> P
David,
This comes with the usual caveats (contact oracle support, don't do this
without testing, some fading may occur, objects in the rear view mirror are larger
than they appear)...
On error dumps are pretty straight forward. If you can reproduce the error in
a session, just se
Building on Jacques' solution, here is one that aligns all the statements nice and
neat. Of course, it does not have the username/instance, so I don't know how
acceptable it is
select ' 1 '
as new_prompt
from dual
/
set sqlprompt "&new_sqlprompt"
1 select 1,
2 2,
3 3,
4 4,
I have a task to pull v$session info from various databases and insert into
a history table.
I'd like to exclude those sessions that are connected to a database via a db
link.
Is there an easy way to identify such sessions?
Thanks.
Jeffery D Th
Hi Chris,
Be default Oracle 9i create database with 4k block_size ,you can choose
differently types of block_size on tablespace level. You may like to look
into tablespace block_sizes. I have a 4 k block size in one of our
production database but it allows me to have different block size on
tables
Ryan
I'm no Java expert and am willing to be corrected. My understanding
is that Apache is just a web page server. The better comparison is between
Tomcat and 9iAS. Since most web hits are for just static pages, you may even
chose to have Apache front-end your 9iAS. Over Tomcat, 9iAS is J2E
Title: RE: DBMS_JOB scheduling
nope ... at-least not yet.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinio
I wouldnt be concerned with hiding the db structure, look at
peopleslop(aka peoplesoft), the structure is there for all to see but
how its implemented is all on program code, yes you can eventually
figure out how its all related(took me 6 months on one of the versions
but I figured out all of t
List,
I need to trace for a specific Oracle error number, ORA-01722. Any
suggestions would be appreciated.
thanks,
David Ehresmann
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ehresmann, David
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-50
Dennis,
I've heard the "not getting locked into one vendor" idea before. It happens
to be the mantra from our current CIO. Problem is then that you have vendors pointing
fingers at the other guys when something goes wrong. Previous place I worked was ALL
DEC from the ground up. Some
Title: RE: DBMS_JOB scheduling
Igor,
you are right ... as a unwritten policy we don't allow windows databases
... even for crash test dummies ...
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views exp
Hi Listers,
I
am trying to configure a two-node Oracle9i RAC on Redhat Linux AS 2.1. I have 2 network cards in each
node. Oracle doc. says that one of
the network cards has to be on a public network and the other network card on a
private network each configured with stati
I just started at my new DBA job, and I have been reviewing their database
installation procedure. I noticed that they create all their databases with a 4K
block size. This is for Oracle 9.2 on AIX 5.2. It has been my general understanding
that most sites these days use 8K db_block_size as a
> 1. have you tried select to_char(sysdate,'D') from dual ??
Yes, and it works fine on MY servers, but the docs say that the value
returned
depends on your NLS_TERRITORY setting. I am trying to get it to work for
everybody.
> This is really nice, but my only gripe with dbms-job is that is isn't
Title: RE: logon trigger to start tracing
Paul,
remember it is a trigger ... so it runs under executing user's privs ...
1. everyone needs a direct grant for execute on dbms_session
2. there needs to be a public synonym for dbms_session
3. yell "Bingo!"
Raj
That's it! Thanks...sometimes I forget that a trigger is a stored
object, too.
Regards,
--- Wolfgang Breitling <[EMAIL PROTECTED]> wrote:
> The logon user needs to have granted "alter session" privileges
> directly to
> her, not just through a role.
=
Paul Baumgartel
Transcentive, Inc.
w
Gudmundur,
Where is this documented (so I can RTFM)?
The one piece of this I don't quite understand is that the timestamp is not
emitted twice in a row. If the long time is the triggering event, why do I see a gap
of 90 minutes (in another trace file)?
Daniel
Gudmundur Bjarni Jo
Hi all,
When you develop a software and you intend to sell it, are there any ways of saving
your database structure. Because obviously we don't give the fmb's, we only give the
executable. But to run the software we need to have the database and there are ways by
which the database structure can
Oracle9i 9.2.0.3.0, O7_DICTIONARY_ACCESSIBILITY is FALSE.
--- Jacques Kilchoer <[EMAIL PROTECTED]> wrote:
> What database version? What is your setting for
> O7_DICTIONARY_ACCESSIBILITY?
> I tried the following in an 8.1.7 database with
> O7_DICTIONARY_ACCESSIBILITY = FALSE
>
> create user x iden
Title: RE: DBMS_JOB scheduling
Raj,
You must be speaking from “UNIX
heights” -J
Under Windows I find dbms_job much more
reliable than windows “at” scheduling.
Actually, never had problems with dbms_job
“forgetting” to run a job.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
Title: Quick RMAN Verfication question
I believe you can setup an RMAN Recovery Catalog within a database on a UNIX platform, which will back up a DB on Win2k. But I've never set it up this way. So basically, my question is, Is anyone else doing this right now? how well does it work for you?
Phillipe,
Look at using INSTR and SUBSTR to calculate the position of the last / and
work from there.
Daniel
> "NGUYEN Philippe (Cetelem)" wrote:
>
> Hi Gurus!
> a very simple problem for You :I just want to retrieve the .dbf name from file_name
> column in dba_data_files.
> eg :'/orac
what functionality does 9iAS give you over just running apache?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 23, 2003 9:59 AM
> Ryan
>My impression is that 9iAS probably has the best database interface.
The
> others look pre
Title: RE: DBMS_JOB scheduling
Garry,
1. have you tried select to_char(sysdate,'D') from dual ??
This is really nice, but my only gripe with dbms-job is that is isn't reliable ... it wasn't in 9ir1 on aix and we didn't even look at it in 9ir2. in 9ir1 dbms_job used to _forget_ to run jobs
Not sure what exactly you are asking here but one way of sizing the multiple buffer
pools is to look at V$DB_CACHE_ADVICE view.
The following is from the 9i performance tuning manual
V$DB_CACHE_ADVICE can be used to size all pools configured on an instance. Make the
initial cache size estimate,
Jeroen
I haven't done this specific export/import. Hopefully someone who has
will respond. The usual prescription is to use the exp binary from the older
Oracle version to export the data. The layout of the data files changed
between Oracle 7 and Oracle 8, but did not change from 8 to 9, so you
Hi Igor,
yes, it is. But it would be better if we all
swallow the use of the builtin functions.
My weaknesses are with analytic functions.
I would give my colleague's right arm for
getting into them ;-))
Greetings,
Guido
>>> [EMAIL PROTECTED] 23.07.2003 15.54 Uhr >>>
> eat this:
Is it chewab
Hi,
when i try to start the oid server process, i get the following message in the oidctl.log
sgslunlListen: unable to bind endpoint (13)
Dispatcher controller: OiD LDAP server exiting..status:0
When i look with ps -ef | grep oid I see a defunct marked oid server process. So i
can´t connect to
Ryan
My impression is that 9iAS probably has the best database interface. The
others look pretty primitive in comparison, basically just JDBC when you get
to the bottom. Also, note that Oracle is currently running a special to lure
WebLogic and Websphere users away. I think in this confusing, ev
> eat this:
Is it chewable? -:)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Guido Konsolke
Sent: Wednesday, July 23, 2003 3:14 AM
To: Multiple recipients of list ORACLE-L
Hi Philippe,
eat this:
select
substr('/oracle/d0/data/user.dbf',instr('/oracle/d0/data/user.dbf','
I'm not sure of the export compatibility, but you should know that 9i
clients won't talk to a 7.3.4 database, and 7.3.4 clients won't talk to a
9.2 database, which could be a problem. At least, they're not certified
to talk to each other, which isn't quite the same thing.
Cheers
Simon Anderson
when configuring multiple buffer pools in oracle9i , how are lru_latches set.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Hi,
We are investigating
possibilities for migration of an oracle 7.3.4 to oracle 9i. We want to
separate our
production DB from the app-logic such that we
can migrate from oracle 7.3.4 on hp-ux 10.20 to
oracle 9i
on hp-ux 11.
Problem is our development and test-environment because we
I'll jump in here if I may.
There's another spotlight/DBXray type tool that we are starting to bring in
to the UK market place at the moment, that is being received *very* well.
The tool is called MGA Eagle Eye, which is developed over in Australia by
Mark Gurry's company (http://www.mga-it.com).
Any Interest?
The DBMS_JOB package is supplied by Oracle to allow the running of
procedures at regular
intervals. Unfortunately the INTERVAL parameter is limited to 128
characters, which prevents
you from getting very complex (user defined functions [in the interval
parameter] do not
work well
101 - 200 of 203 matches
Mail list logo
