Dear :All
Oh thank now i know where to dig the information, i
will try to read this manual, ... i bet it should have
take me some time :)
thank
Jkean
--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> Read about transportable tablespaces. It works like
> this:
> you export metadata, make a copy o
Read about transportable tablespaces. It works like this:
you export metadata, make a copy of the files in the place where the new database
can access them and import the metadata. There are many limitations and stipulations.
You really need to read the manual for this one. If you don't want to re
Yep, sqlplus.exe will still be there. Otherwise one wouln't be able to run
any automated sql scripts, because isqlplus can't do it as far as I
understand.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 12:04 AM
Dear : All
I have 2 database which is DB_A and DB_B. DB_A contain
schema A with the tablepace name as locus_tblspc.
Now DB_B is a newly create database. I would like to
populate what ever is in schema A to DB_A . This
included all the table,procedure,trigger,synonym,grant
and most of all tablespa
Sure! Create the following views while connected as schema A:
create view dba_users
as
select * from sys.dba_users
where username not in ('C','D');
create view all_users
as
select * from sys.all_users
where username not in ('C','D');
You might need to have SYS grant you
I apologize if someone already mentioned this (I've been busy so mostly
deleting traffic in order to keep from being overwhelmed!), but did anyone
mention the DBMS_METADATA package for this?
Looks pretty cool, mostly intended for generated XML output but also
generates DDL commands...
on 12/10/
Title: Re: SQL Area Reloads
Sure, it’s free now. But has that always been the case?
on 12/10/03 3:14 PM, Ashish Sahasrabudhe at [EMAIL PROTECTED] wrote:
The statspack report is showing 10,684 reload for SQL AREA with 2.2% misses.
Title: Re: 24 x 7 x 365
As I mentioned a few minutes ago in another thread, there is an application using Oracle Rdb on an HP OpenVMS cluster located at HP in Colorado Springs that has been up and available continuously for the past 11-12 years.
on 12/10/03 2:49 PM, Goulet, Dick at [EMAIL PROT
VARCHAR2 started with Oracle7 v7.0.x (circa 1992-ish). Prior to that,
Oracle6 had just VARCHAR with the exact same semantics/definition/behavior
as current VARCHAR2.
At the time, the explanation was that the ANSI SQL definition of "VARCHAR"
was slightly different from Oracle's existing implementa
This is a small, static, but fiercely loyal group of VMS users for HP to
milk. OpenVMS is money in the bank for HP, as it was for Compaq and DEC.
Even the bean-counters understand the insanity of shutting off a guaranteed,
endless, and highly-profitable revenue stream upon which they do not have t
they list the new application server and the new
developer suite as '10g', but then say 9.0.4 next to it?
so are they really new versions or just minor
upgrades to the 9i version?
Robert, Robert, Robert, when will you ever learn? You've been listening
to the marketing people again. :)
The whole goal behind this part of the release is not to make the
database look easy to manage (which is good because I've never thought
it WAS difficult to manage!) It's for those lower en
Hello : All
I have a scenario here. I have a database name :
CYBER.
I am using oem to manage this dbase.In this database ,
i have created 4 schema . which is schema A, schema B,
schema C and schema D.
When i login into the dbase using schema A user id
throught oem , i can see all other 3 schema
Hi all,
(B
(Bi have written a small procedure to send e-mail from
(Bmy oracle database [oracle 9.2.0.3/win2k].
(B
(Bmessage := 'Date: ' || TO_CHAR( SYSDATE, 'DD-Mon- HH24:MI:SS' ) ||
(Butl_tcp.CRLF;
(Bmessage := message || 'From: ' || sender || utl_tcp.CRLF;
(Bmessage := message || 'Sub
Hi guru,
Can anyone tell me how to setup a client computer w/ linux as is os to
connect to forms cgi in an ias server using browser ? In win2k ,jiniator is
used to connect to forms in an ias server using browser only.
Best Regards,
Grace Lim
Suy Sing Comm'l Corp
--
Please see the official
How about: Keep re-analyzing your tables and indexes. Run
gather_statistics (or whatever) all the time.
Bobak, Mark wrote:
I think this subject has been done to death. We should talk about less contentious issues such as:
- The buffer cache hit ratio, your friend in expert Oracle tuning!
- Reb
Wednesday, December 10, 2003, 6:39:33 PM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
JSrc> Can anyone recommend a good, inexpensive web hosting company
JSrc> that runs on open source: Linux, Perl, MySQL, PHP, etc.?
I'm a big fan of Pair Networks, which you can find at
pair.com.
Best regards,
Title: Pipelined functions
Doh !!
I just figured it out .. "set
arraysize 1" was the missing link ... one guy replied to my posting on
forum://Metalink:oracle_plsql that it might be client side caching and that
prompted me to experiment with arraysize.
So, it was an issue with sqlplus se
>> Doesn't matter if there's 30 or 300, you don't usually mess with
>> them other than at database create time.
Shh Oracle thinks this is a marketing coup They want to make the
database look easy to manage...
"Parameters? Ha, you only need configure a few basic parameters and the
d
Sorry for the off topic, but I don't have any one locally to ask this of.
My co-workers that are developers tend to be somewhat MScentric.
Can anyone recommend a good, inexpensive web hosting company
that runs on open source: Linux, Perl, MySQL, PHP, etc.?
This is to be for my personal use, an
Thanks for all the responses. As I figured, everyone has a different
method, but the common thread seems to be automation. I'm not sure exactly
what approach I'm going to take yet, but I'll definitely try to automate
it as much as possible...
I'll add one of my own documentation tricks that
Much seems to be made of this 'less than 30 init parameter to tune'.
Who really spends much time doing that anyway?
If you do, you're probably going after the wrong end of a problem.
Doesn't matter if there's 30 or 300, you don't usually mess with
them other than at database create time.
Jare
Friends --
Perhaps you can help me out with this... I don't understand why the CPU time
should exceed the elapsed time here... Do you?
1 select a.username,
2 a.osuser,
3 round(elapsed_time/100,2) elapsed_seconds,
4 round(cpu_time/100,2) cpu_seconds,
5
Title: SQL Area Reloads
You'll have reloads if your SQL is invalidated
because of DDL or analyzing on tables.
- Original Message -
From:
Ashish Sahasrabudhe
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 11, 2003 12:14
AM
Subject: SQL Area Reloa
Vordos, Suzy wrote:
A very long time ago, there was a whitepaper on implementing Veritas for Oracle systems. I think it was published by Veritas. I've googled and searched veritas.com and can't find it anywhere.
IIRC, one of the recommendations in the whitepaper was to not use rootdg for datab
On 12/10/2003 04:34:25 PM, Tanel Poder wrote:
> > Pete, I'd like to clarify my position first: I don't have any burning
> problem
> > that would compel me to start testing 10g. I want only to learn the new
> > features.
>
> Btw, if you want to learn some of the 10g database engine new features (n
Has you db_file_multiblock_read_count changed due
upgrade?
What are your optimizer_index_cost_adj and
optimizer_index_caching parameter values?
If they're default you should perhaps change them
according to Tim Gorman's CBO article (or in 9i, gather system stats
instead)
Tanel.
-
I think this subject has been done to death. We should talk about less contentious
issues such as:
- The buffer cache hit ratio, your friend in expert Oracle tuning!
- Rebuild your tables regularly to reduce the number of extents and improve
performance!
- Disk access is at least 10,000x slo
The failure to do the 90/10 split is a bug (it worked
properly in 8.1) which is currently being investigated.
I can't remember the number, but I passed it to Oracle
some time ago.
As to the original question - no idea, 100/0 seems
to be the correct strategy; however, there was an
earlier version
LOL,
This made me think of the Simpson's Halloween episode where Monty Burns
says,
'Smithers, this isn't rocket science, its brain surgery'.
-
Alan Davey
Senior Analyst/Project Leader
Oracle 9i OCA; 3/4 OCP
w) 973.267.5990 x458
w) 212.295.3458
-Origi
ROTFL! Completely blocked the fact out of my mind that this app started out
using InterBase (aka "StarBase"). It didn't change to Oracle until we lost
a day's worth of ERP because a Windohs PC crashed that was running a telnet
session to the server and didn't disconnect from the app/DB properly.
> BTW, does anyone know what a rocket scientist refers to when
> they say "Hey,
> this is all quite easy, it sure ain't ?" ?
>
> Cheers ;)
>
> Richard
Surely the Rocket Scientist version must be "Hey, this is all quite easy, it sure
ain't index rebuilding"
Ciao
Fuzzy
:-)
--
Please see
When you want true 24x7 without compromises, then you have to step closer to
the client anyway.
This means, you have two databases for example and your app server
multiplexes all transactions to both ones.
This should be faster than sync standby or sync replication, because app
server can send req
Hi!
Try if you find the alert.log of your database and
see what are the last messages there. Maybe Oracle failed to mount or open the
seed database, thus leaving instance in "initialization or shutdown"
mode...
Tanel.
- Original Message -
From:
Natalia
Laracca
To:
Title: SQL Area Reloads
The statspack report is showing 10,684 reload for SQL AREA with 2.2% misses.
==
Library Cache Activity for DB: MAIN Instance: MAIN Snaps: 18089 -18090
->"Pct Misses" should be very low
Unless Oracle has plans of buying IBM and decommissioning DB2
;-)
Murali.
|-+>
| | Jonathan Gennick |
| | <[EMAIL PROTECTED]|
| | .com>|
| | Sent by: |
| |
Title: Pipelined functions
Hi!
How did you test it? From sqlplus or external app?
Then check whether you have array processing turned on (it should be off if you
want to get rows one-by-one).
Or if in PL/SQL, are you using bulk
collections?
Tanel.
- Original Message -
From
Tanel,
Whthough they may not have the sqlplusw.exe for windoes is the sqlplus.exe
still there?
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, December 10, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L
d
Excellent slide show Ta
Wednesday, December 10, 2003, 3:19:24 PM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
JSrc> I didn't realize that parentheses would affect to optimizer to change the
JSrc> join order.
But is it just a performance thing? Given a situation with
all inner joins, I can't conceive of the order makin
True
24x365 is just about impossible. No if, ands. or buts about it. Why
is because of the number of factors outside your control that affect system
availability. Sure your web sever and database are up 24x365, but your ISP
has 1 hour down time each month for maintenance. OOPS!! from a
I read that section of the manual not that VARCHAR may go away, but that
that the "functionality" of the VARCHAR datatype may one day differ from
that of the VARCHAR2 datatype.
I forsee something like what happened with the CHAR type between v6 and v7.
Just my 0.02eur
Kevin
-Original Messag
Excellent slide show Tanel!
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/10/2003 3:34 PM
dc_histogram_defs)
> Pete, I'd like to clarify my position first: I don't have any burning
problem
> that would compel me to start testing 10g. I want only to learn the
A very long time ago, there was a whitepaper on implementing Veritas for Oracle
systems. I think it was published by Veritas. I've googled and searched veritas.com
and can't find it anywhere.
IIRC, one of the recommendations in the whitepaper was to not use rootdg for database
files, inste
I don't have any experience with Netbackup, just Legato, but there is a
utility called "sbttest" that may help in troubleshooting the
problem. Here's an example from something I wrote up a while
back:
/ora01/V901$ sbttest osmtab01.dbf -dbname V901 -trace
/oracle/sbtio.log
The sbt function pointers
Wednesday, December 10, 2003, 3:39:26 PM, DENNIS WILLIAMS ([EMAIL PROTECTED]) wrote:
DW> 2. I have been curious about Oracle's statement that you should use
DW> VARCHAR2.
I am too, now. That statement in the docs about the meaning
of VARCHAR maybe changing someday has been there as far back
as my
> I remember Oracle saying that char was going away - about 6 years ago.
> That's when they created varchar and varchar2.
>
> Is this a new rumor?
VARCHAR3 type coming?
Tanel.
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -Original Message-
> Sent: Wednesday, December 10,
> What good reasons might an application have to use and
> depend on CHAR variables?
There was a recommendation in Oracle's intro to SQL training materials
several years ago, that you can use fixed-len char columns to make sure that
your rows never grow once inserted, thus reducing row migration p
> Pete, I'd like to clarify my position first: I don't have any burning
problem
> that would compel me to start testing 10g. I want only to learn the new
> features.
Btw, if you want to learn some of the 10g database engine new features (not
the marketing buzzwords), then check out one of my prese
Hi,
I'm in the middle of
migrating oracle 7.3.4 to oracle 9.2.0.4
In process of testing we
encounter a big query that is now taking full table scans
Where it
used to take indexes.
When we compare plans this is evidently so,
Optimizer_mode is on both choose, tables and indexes are ana
Hi!
SQL> select * From v$sysstat where name like '%split%';
STATISTIC# NAME
CLASS VALUE
--
-- --
195 leaf node splits
128612
196 leaf node 90-10 splits
128209
197 br
Hi,
Unfortunately I'm gonig to add the negative view, like several others
have...
True 24x7x365 (good pick-up Pete on the 7 year thing) will be limited by
much more than database and operating system availability. We just did a
major software upgrade last weekend and part of the upgrade invo
Maybe you all already know that, but HP is planning to support OpenVMS on
their Itanium servers :)
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 09, 2003 10:14 PM
> I'm guessing they're not running Oracle on this VMS
Yes, they keep saying that varchar may change in future releases, so use
varchar2. Maybe they'll finally use it. But for what I don't know.
-Original Message-
Sent: Wednesday, December 10, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L
Raj, Jonathan
1. I have heard rumors that in
Thanks Ron.
No, we use SQL-Backtrack instead of RMAN. However SQL-Backtrack does show a diff
flavor of rogue connections of ###NOBODY.
The remote database systems that are connecting to our database as SYS are not ones we
support. What is common about these databases is they do have logi
Dwayne Cox,
Don't know if this is the same problem, but I did run into this and the there had to
be a re-linking and a softlink set for a library if I remember correctly. Just an idea
to check. I know this stuff is a bugger till you get it working.
Brian
-Original Message-
Dwayne Cox
Raj, Jonathan
1. I have heard rumors that in other databases the VARCHAR performance isn't
good. In fact, some people that are converting from other databases to
Oracle are pleasantly surprised that Oracle handles VARCHAR well.
2. I have been curious about Oracle's statement that you should use
VA
Brian,
Netbackup does indeed have to be linked to Oracle. I performed this and
it seemed to go well (no obvious error messages).
-DC-
Spears, Brian wrote:
Dwayne Cox,
Don't know if this is the same problem, but I did run into this and the there had to be a re-linking
and a softlink set for
Tracy, both OPS (8i) and RAC (9i)support independent node shutdown.
Both support listener based load balancing so that incoming connections
will be evenly spread on all nodes. That still doesn't give you the true
24 x 7 x 365 availability. For that, you need two replicated copies of the
database,
Suzy,
Do you use RMAN to perform backups? Do you use a catalog with RMAN?
Rman uses sys to perform the connections to the target database.
Just a thought,
Ron
>>> [EMAIL PROTECTED] 12/10/2003 3:09:33 PM >>>
Solaris 2.8 Oracle 8.1.7.0. We have session auditing enabled, and see
rogue connections
You can get some better diagnostic information by doing the following on the client box:
cd /usr/openv/netbackup/logs
./mkdirs.sh
if the following directories were not created by the script, create them:
/usr/openv/netbackup/logs/user_ops/dbext/oracle
/usr/openv/netbackup/logs/user_ops/dbext/
Jonathan,
I didn't realize that parentheses would affect to optimizer to change the join order.
A little experimentation shows that it can indeed be done.
For anyone that wants to see it, the joins are below.
I learn something every day around here.
Jared
select
e.ename
, e.empno
,
Dwayne,
Doesn't the Veritas backup exec Oracle client perform a "HOT" backup
of the database? If that is the case then the RMAN backup is performed
differently that the hot backup. Read the script that the Oracle client
uses to see what is happening.
I may be off base with this version of backup
i was at an oracle group meeting and one of the RAC specialists at oracle was talking.
he said that that kind of thing 'can' be done, but is incredibly expensive. you need
redundancy and fail safes like crazy.
any time you do an upgrade, bad things may happen.
>
> From: "Tracy Rahmlow" <[EMAIL
have you _sourced_ your .profile? cron won't do it automatically for you.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having
Solaris 2.8 Oracle 8.1.7.0. We have session auditing enabled, and see rogue
connections as SYS from several remote databases. The os_user of the remote system is
always oracle and there are several different remote hosts involved.
I can't figure out how they are gaining access this way. Our
The reason that vendors often use LONG RAW is that that datatype meets the ANSI SQL
standard, while BLOB doesn't. That way, they can use the same DDL against most SQL
databases. Sometimes you can modify the vendor's DDL before or during installation.
Sometimes you can re-create a table right
Probably by Howard Dean and Bertie Gore.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 10, 2003 10:34 AM
> Not as long as DB2 has it. Oracle needs to be compatible, in order
> for the people to convert. In addition to that,
Title: Could not run export utility from cron job
Make
sure that you source your environment variables in the script. At the
least, set the $PATH variable to include the Oracle bin
directory.
Jobs
executing from CRON do not automatically source the .profile when they kick
off.
-Or
Title: Could not run export utility from cron job
You
need to load user's .profile in your cronjob (to set ENVs), becuase the unix
user who executes cronjob does not have it's profile loaded.
HTH.
Guang
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Beh
You mean 2004/02/31, the 31st of February?
On 12/10/2003 02:19:34 PM, Whittle Jerome Contr NCI wrote:
> As 2004 is a Leap Year, in February you have a one day window of opportunity to do
> upgrades. ;-)
>
> Jerry Whittle
> ASIFICS DBA
> NCI Information Systems Inc.
> [EMAIL PROTECTED]
> 618-622-
I think he's skipping that one to go direct to "Do you really need
Oracle?" :)
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-Original Message-
Denny Koovakat
On 12/10/2003 11:34:36 AM, "Jamadagni, Rajendra" wrote:
> Another myth ... maybe. I also heard that in 9i DBA will be no longer needed.
>
> Raj
And it became reality. DBA jobs were outsourced. The only necessary people
belong to the damagement. Oracle 10g will create the need for fewer IS profes
I apologize for this *basic* question but I have searched the manuals,
Robert Freeman's RMAN book and MetaLink as well as Googled and cannot
find the answer. I know its something simple.
We have Veritas Netbackup 4.5 running on Red Hat Linux 7.2. It has been
backing up our netowrk for a coupl
In Austin, Texas
--
Original Message
Date: Tue, 09 Dec 2003 06:14:30 -0800
>System Manager:
>
>Where are these positions located geographically?
>
>Me
>
>
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>S
Title: Could not run export utility from cron job
I am able to run export utility from CLI manually but when I schedule it to run from cron job on SUN Solaris8 it fails to run as it does not recognize exp command. Does someone have any idea? Below is the command I run export manually.
$exp
Title: RE: 24 x 7 x 365
As 2004 is a Leap Year, in February you have a one day window of opportunity to do upgrades. ;-)
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Tracy Rahmlow [SMTP:[EMAIL PROTECTED]
Se
How about setting it up to execute in 10 minutes? Testing things this minute
isn't exactly the point with cron.
On 12/10/2003 02:09:24 PM, Bricklen Anderson wrote:
> Simpson, Ken wrote:
> >
> > I'm pretty sure that jobs running out of cron do not source in .profile
> > so you probably don't
> > ha
Simpson, Ken wrote:
I'm pretty sure that jobs running out of cron do not source in .profile
so you probably don't
have the Oracle environment set and therefor exp is not in your PATH.
Ken
How about adding the line:
source /.(bash_)profile
to the shell script that runs exp?
Unfortunately, I'm not in
Oracle has varchar and varchar2 both ...
The VARCHAR2 subtypes below have the same range of values as their base type. For
example, VARCHAR is just another name for VARCHAR2.
STRING
VARCHAR
You can use these subtypes for compatibility with ANSI/ISO and IBM types.
Note: Currently, VAR
Ken:
When running from cron the user's .profile does not get executed. So your
ORACLE_BASE, ORACLE_HOME etc does not get created in your os environment.
So on the line that you want to execute the export. Before the exp command
add ". ~/.profile &&" (without the double quotes) exp user/password
DW> If your application is COBOL-based, using CHAR
DW> simplifies things quite a bit.
True enough. I'd forgotten about COBOL. The semantics of
COBOL's PIC X fields match up pretty closely (exactly?) to
SQL CHAR fields.
DW>My understanding is that VARCHAR2 is not even a SQL standard
The keywo
I looking for a good, simple example of when parentheses
matter when writing a join query using the new, SQL92 join
syntax. For example, I could write:
SELECT *
FROM county y JOIN city c
ON y.county_id = c.county_id
JOIN attraction a
ON c.city_id = a.city_id;
and I could use parens
How's about applications written in ancient awful 4GLs like PowerHouse that
do not handle variable length fields (aka "columns") in their own files, and
therefore do not directly support them in relational DBs either?
Did I mention that this application also RELIES on the OCI bug that allows a
dat
Dennis,
According to my copy of 'A Guide To SQL Standard (Author: C. J. Date), 4th ed, pp292,
section 19.4"
CHARACTER(n) - fixed length string of exactly n characters (n > 0)
VARYING(n) - varying length string of up to n characters (n > 0)
So, I guess it is.
Raj
--
Group,
I have just been given a project / database
where a vendor will implement a table
with a LONG RAW field in it.
Oracle manuals state clearly that this datatype
is outdated and should be replaced by BLOB,
I quoted the manuals to vendor-support, but they
will not move on this.
>From the
They will think differently after Mogens comes out with the "Do you really
need 10g" presentation ;)
--
Denny Koovakattu
Quoting Nuno Souto <[EMAIL PROTECTED]>:
> The interesting fact of course is that the beta program
> of 10g was "announced" in newsgroups AFTER it had closed
> for all in
Title: Pipelined functions
I have a question related to pipelined functions ...
I have a function which performs a task in a loop. I have piped messages at the beginning and end of the loop and expect them to appear as soon as they are piped. But there seems to be a difference of opinion be
On 12/10/2003 12:44:26 PM, "Jesse, Rich" wrote:
> Did I mention that this application also RELIES on the OCI bug that allows a
> date column to contain a zero (as opposed to the zero-date) that can't be
> done thru normal SQL?
That is, probably, because your application supports conversion to sta
Mark,
My guess is, that the new OS re-instated the file system caching.
By default, 41% (yes, it should have been 42%) of physical memory will be allocated to filesystem caching, as W2K thinks it a fileserver (and domain controller, web server, print server, etc) until you tell it otherwise.
Th
Indeed, my todo list includes an item for automating RDA on several servers.
The problem is, that RDA is rather difficult to automate, at least on Windoze.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/09/2003 05:24 PM
Please respond to ORACLE-L
To: Mul
On 9i:
select * from v$statname
where name like '%leaf%';
Yong Huang <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/10/2003 07:39 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:
-Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Nguyen, David M
> Sent: Wednesday, December 10, 2003 12:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Could not run export utility from cron job
> I am able to run export utility from CLI man
You mean you still need a DBA in 9i?!!? :)
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-Original Message-
Jamadagni, Rajendra
Sent: Thursday, December 11, 2
Well, first
thing that needs to be noted is that “24 x 7 x 365” indicates
uptime for 7 years, which always gives me a chuckle when people say it. Mind you, I’ve been guilty of
saying it too! J
And probably
the second thing that needs to be said is that no single product addresses true
Grace
Take a look at Lawson Software -- http://www.lawson.com
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, December 09, 2003 9:34 PM
To: Multiple recipients of list ORACLE-L
can anyone recommend accounting software for mid-range distributio
Alan,
That sounds like a good candidate for a simple database application written
in PL/SQL. Create a schema and model your app. It shouldn't require too many
tables. Since you have Oracle and non-oracle information to store, most of
the Oracle information could be extracted from the data dictiona
Jonathan
My understanding is that VARCHAR2 is not even a SQL standard, and some
databases don't handle VARCHAR very efficiently, so if you are trying to
sell a product that can adapt to several databases besides Oracle, you might
stick to CHAR.
If your application is COBOL-based, using CHAR s
-Original Message-
Sent: Wednesday, December 10, 2003 10:35 AM
To: Multiple recipients of list ORACLE-L
Wednesday, December 10, 2003, 11:09:27 AM, Gene Gurevich ([EMAIL PROTECTED])
wrote:
GG> Someone told me that Oracle is planning to retire char
GG> variable and therefore they need to
Hello,
Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC sol
Wednesday, December 10, 2003, 11:09:27 AM, Gene Gurevich ([EMAIL PROTECTED]) wrote:
GG> Someone told me that Oracle is planning to retire char
GG> variable and therefore they need to be replaced by
GG> varchar2. Has anyone heard anything about it?
I've not heard anything like this. I'm skeptical t
1 - 100 of 149 matches
Mail list logo