Hello,
It's found in:
http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html
Thanks.
ltiu
On Friday 30 August 2002 23:03, ltiu wrote:
> Hello guys,
>
> Forte for Java version 4 comes with jdbc to odbc driver (Windows only!??!).
> But it does not come with the Oracle thin driver to co
Congratulations! :-)
With Warm Regards,
Manav.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, August 31, 2002 7:48 AM
> MY SISTER IS PREGNANT!!!
>
> Early days yet, and she will be very very very careful for a long time
>
On 2002.08.30 22:18 Rachel Carmichael wrote:
> MY SISTER IS PREGNANT!!!
>
> Early days yet, and she will be very very very careful for a long time
> yet but she's pregnant!
>
> Rachel
>
Congratulations! You should start planning OCP for your niece/nephew before her/his
1st
birthday.
Hello guys,
Forte for Java version 4 comes with jdbc to odbc driver (Windows only!??!).
But it does not come with the Oracle thin driver to connect directly to an
Oracle instance through the listener.
Does anyone here know where to get this?
Thanks for any info.
ltiu
--
Please see the offic
What's the file name format of the RMAN backup set? I see files in there that
I suspect are my backup sets but they have wierd file names.
Such as:
01e1el7h_1_1
with no file name extensions.
ltiu
On Friday 30 August 2002 19:53, Philip Douglass wrote:
> Hmmm... IIRC they should be in $ORACLE_
Interesting. Longs always caused a lot of
problems. Not just with imports...
Did you get any relevant info from sar itself?
I mean, it appears your problem was one of I/O
wait, did it show up in the OS monitoring tools?
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
>
> the re
On Fri, 30 Aug 2002 08:23:27 -0800, you wrote:
>Anyone else hear that SQL*Plus is going away in 10i??
The story I heard is that only the Windows version, the one that wraps
a GUI around the command-line, goes away. The DOS version stays (or so
I've been told, but I forget by who).
Jonathan Gen
Thanks to Scott and everyone else who replied. You'd think I'd have
known how to create the scott schema, but I haven't created it in
years and I'd forgotten where the script was located. Someone at
Oracle recently sent me some demo scripts that make use of the scott
tables, and that's why my ques
Hmmm... IIRC they should be in $ORACLE_HOME/dbs
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 30, 2002 10:28 PM
Hello,
I took an RMAN backup of a database (for testing purpose only, thank
goodness). The question is, where did
Hello,
I took an RMAN backup of a database (for testing purpose only, thank
goodness). The question is, where did RMAN put the backup set files?
I read through an RMAN book and the official Oracle RMAN User Guide and
neither mentions the location of the RMAN backup ?!!
Thanks for any input.
I wonder why there is no Oradim under Unix/Linux?
ltiu
On Friday 30 August 2002 19:23, Rachel Carmichael wrote:
> does oradim work in Unix boxes? I've never used it
>
> And it took a LOT of releases and warnings before they got rid of
> svrmgr.. they started saying it was going away in version 7
No it doesn't. oradim is used to create/start/stop oracle services.
There is no such thing as NT services on Unix.
-Original Message-
Sent: Friday, August 30, 2002 10:23 PM
To: Multiple recipients of list ORACLE-L
does oradim work in Unix boxes? I've never used it
And it took a LOT of
Congratulations to your Sister!!! My wife and her sister are trying too.
With their respective husbands, of course... :)
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 30, 2002 10:18 PM
MY SISTER IS PREGNANT!!!
Early day
I LOVE that idea
I miss the monitor function :)
--- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote:
> We only need to start it. It usually stops itself without human
> control.
> That is why we have ora-600 and ora-7445 features implemented in PMON
>
> and SMON. As for starting and stopping, let
Congratulations!
Richard Ji
-Original Message-
Sent: Friday, August 30, 2002 10:18 PM
To: Multiple recipients of list ORACLE-L
MY SISTER IS PREGNANT!!!
Early days yet, and she will be very very very careful for a long time
yet but she's pregnant!
Rachel
___
I can't code scripts to be run by the operations staff via OEM. I
don't want to give that much access to non-DBA staff.
I told Ken Jacobs this years ago when he said at an NYOUG meeting that
"soon your database will be controlled from the web"
--- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
>
does oradim work in Unix boxes? I've never used it
And it took a LOT of releases and warnings before they got rid of
svrmgr.. they started saying it was going away in version 7 I believe.
--- ltiu <[EMAIL PROTECTED]> wrote:
> oradim -startup -sid -pfile ???
>
> They got rid of SVRMGR.
>
> l
Stephane you are more than welcome to disagree with me. Of course, when
I tried to find the sql, I was on version 7.3 so autonomous
transactions were unavailable.
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> Alan Davey wrote:
> >
> > Thanks Rachel.
> >
> > I spent the train ride reading t
MY SISTER IS PREGNANT!!!
Early days yet, and she will be very very very careful for a long time
yet but she's pregnant!
Rachel
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
--
Please see the offi
You need oracel client on your PC
can you connect from sqlplus?
On Fri, 30 Aug 2002, Seema Singh wrote:
>
> Hi
> I want to use QUEST TOAD software free version.I have Databases on UNIX and
> I want to connect from my desk top to UNIX DB box but I am unable to.can
> Some one help me if they have?
I'll say! Here's another example:
-Original Message-
Sent: Friday, August 30, 2002 3:18 PM
RUNDATE ADDRESS HASH_VALUE EVENT
SECONDS_IN_WAIT WAIT_TIME
-- --
--- ---
Title: RE: Table Locks
> -Original Message-
> From: Alan Davey [mailto:[EMAIL PROTECTED]]
>
> Jacques, v$locked_object shows the table, but I already knew
> which table was locked. I was hoping to find the offending
> SQL statement.
Sorry, I misunderstood. I thought you were tryi
That's not really a show stopper as far as I'm concerned.
-Original Message-
Sent: Friday, August 30, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L
Importance: High
Just tried it.
Took 5 minutes to break it with this:
set sqlprompt '&&umachine - &who_var@&instance_var SQL>
AN excellent idea, i'll put it out tonite more than likely.
joe
Freeman, Robert wrote:
>just throw it out on ebay for auction Joe! :-)
>
>Robert G. Freeman - Oracle OCP
>Oracle Database Architect
>CSX Midtier Database Administration
>Author
>Oracle9i RMAN Backup and Recovery (Oracle Press - Oc
Seema, you dont give us enough information, so I am
not sure what your problem is, I think you dont have
the configuration of your DB in your TNSNAMES.ora file
in your desktop, look at your ORACLE_HOME dir and then
in /net80/admin (oracle 8.0.x), just configure there
your BD and then choose which
Mladen,
Could you please speak more on the serious problems of 8.1.7.4 on HP/UX
11/64 with OPS?
Thank you,
Bryan Rodrigues
DBA
Elcom, Inc.
-Original Message-
Sent: Friday, August 30, 2002 4:24 PM
To: Multiple recipients of list ORACLE-L
Speaking of the recursion, now 8.1.7.4 has some
Are u running into a specific problem or you just don't know how to set
it up?
-Original Message-
Sent: Friday, August 30, 2002 6:03 PM
To: Multiple recipients of list ORACLE-L
Hi
I want to use QUEST TOAD software free version.I have Databases on UNIX and
I want to connect from my des
Greetings,
Does anyone know of a backup package that can act as an MML for Oracle's
RMAN on OpenVMS?
Thanks,
Mark Stahlke
Denver Newspaper Agency
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stahlke, Mark
INET: [EMAIL PROTECTED]
Fat City Network Services-- (
Ian,
We looked at this statistic for several days of dedicated research. The
statistic is updated by LGWR. As you've noticed, the numbers are
difficult to use for two reasons:
1. It's difficult to predict when seconds_in_wait will be updated. From
an individual session's perspective, the update
What is wrong in: select user from dual;
Waleed
-Original Message-
Sent: Friday, August 30, 2002 3:09 PM
To: Multiple recipients of list ORACLE-L
Hi,
I am trying to put together a package that uses the AUTHID current_user
directive to decide whether to let people kill a session or not
Hi
I want to use QUEST TOAD software free version.I have Databases on UNIX and
I want to connect from my desk top to UNIX DB box but I am unable to.can
Some one help me if they have?
Thx
-Seema
_
Chat with friends online, try MSN
Hi all,
I have following query
SELECT SPT_SPCA_CAT||SPT_PGM_CODE SPORT_CODE,
Spt_Spca_Cat,
Spt_Pgm_Code,
Est_DT Start_Date,
Est_TM Start_Time,
EST_DURA DURATION,
Bc_DtTm, --CR_Start_DT,
Bc_End_DtTm, --CR_End_DT,
LIFE_CYCLE_STATUS STATUS,
Title: RE: Creating Scott/Tiger
The why not run the SCOTT.sql script in the RDBMS\admin directory. That's the script to just create scott, and the table emp, dept and salgrade with their data. That's the original script If I remember correctly. Sorry for coming into the convo so late.
-Or
And how will they support automated jobs (i.e., cron) that use sqlplus??
I've already had to rewrite scripts from svrmgrl to sqlplus. I don't
want to go through that again.
I'm hoping, Robert, that you're just pulling everyone's leg :)
--
| Bri
>> McNealy, Ellison and Gates
Sounds like one of those injury law firms that advertises on late night
TV...
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracl
Patrice,
I've just tried your idea out and it seems to work well. I tried on Oracle
9.0 but it should be the same on 816 or 817.
Here is the procedure that kills the sessions. It uses ora_login_user to
identify the calling username.
create or replace procedure endsession2 (sid_in in number)
as
Just tried it.
Took 5 minutes to break it with this:
set sqlprompt '&&umachine - &who_var@&instance_var SQL> '
Jared
"Orr, Steve" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/30/2002 01:28 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[E
Yeah, let's break the backbone of many dba's toolbox.
This must be one of the stupider things they've done lately.
Reminds of a time when I repaired computers, and the mfgr
wanted to remove test points from boards to save $0.25.
I would guess we could make use of IOUG to take up this issue.
J
I've been looking for something like this too -- unfortunately it doesn't
work on my platform (UnixWare 7) out of the box, and I haven't had time to
figure out why not.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 30, 2002 4:28 P
They are going to have iSQL*Plus (or however it's spelled) and you can use
that (and OEM)
for startup and shutdown. The SQL*Plus text and windows clinet I hear will
be gone.
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backu
And as for OEM, I've heard from several sources that Oracle is going to
position that product more and more to be "THE" database management
interface. It's going to start feeling like we are working on a
SQL Server database before you know it.
RF
Robert G. Freeman - Oracle OCP
Oracle Database A
There are differences in the two scripts as I recall. The sqlplus demo
scripts
do not build the scott account, and only build the basic dept, emp tables
with
some data.
The utlsampl.sql script is much more encompassing, creating users
scott, adams, jones, clark and blake, granting privs, creating
Aren't you looking at only half the picture? -0.875 in Oracle is rounded down to
-0.88. +0.875 is rounded up to
+0.88. I don't think of changing 0.870 to 0.87 as rounding. It is expressing the
+exact same value using only the significant digits.
Ian MacGregor
Stanford Linear Accelerator Cent
Having McNealy, Ellison and Gates working for the same company?
It would be somewhat like Heller's "Milo Enterprises"
> -Original Message-
> From: ltiu [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 30, 2002 3:59 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: SQL*Plus in
Speaking of the recursion, now 8.1.7.4 has some serious problmes,
especially on HP-UX 11/64 with OPS.
> -Original Message-
> From: Miller, Jay [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 30, 2002 3:58 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: upgrade 8.1.6.2 t
Bill,
Where are you trying to load the data to? Do the tables already exist? If
so, then use the ignore=y option and it won't complain if the table already
exists when it tries to create it, but it will load the data into it.
Bill Conner wrote:
> Hi All,
>
> i am starting to feel real dum
> BTW: Anybody's using gqlplus?
Whoa, I've been looking for something like this. Is it any good?
-Original Message-
Sent: Friday, August 30, 2002 12:28 PM
To: Multiple recipients of list ORACLE-L
Yes, Oracle will sell it as standalone product because it is most useful and
most used c
I assume that the schemas, tables, synonyms, roles, grants, etc already
exist and you just want to populate the tables with the data from your
other database.
In your parm file set IGNORE=Y. This will ignore errors caused by already
created objects and just load the data.
Type: imp help=y
to
just throw it out on ebay for auction Joe! :-)
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
The avalanche has begun,
Bill
Ignore=Y is that what you're looking for?
Mike
-Original Message-
Sent: Friday, August 30, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L
Hi All,
i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp
3
times but don't seem able to get the imp to just
Alan Davey wrote:
>
> Thanks Rachel.
>
> I spent the train ride reading the chapters on Instance Tuning and Dynamic
>Performance Views hoping to find something, but no such luck. I learned a lot of
>other useful things though, so it wasn't a waste of time.
>
> Jacques, v$locked_object shows
Bill,
I assume from the way you state this, you already have the tables built and
don't want imp to blow up trying to recreate them. Correct? If so, try
ignore=y. Also, if the user is changing, are you using "fromuser= touser="?
Output from your problem might be helpful.
HtH,
John P Weatherm
Rumor ...
They might as well buy SUN along the way (and get rid of Java for good).
SUN's market cap is only $13B. MS got $300B.
On Friday 30 August 2002 12:44, Gogala, Mladen wrote:
> Connected to that, there is a rumor tha M$ will buy Oracle Corp., with
> Larry Ellison taking the place of Stev
My understanding is that 8.1.7.3 is the buggy one. It was supposed to be
the terminal 8.1.7 release but it had so many problems they had to come out
with 8.1.7.4
-Original Message-
Sent: Thursday, August 29, 2002 5:44 PM
To: Multiple recipients of list ORACLE-L
DBA's
I have to upgrade
Why not? It's easy to use. It will increase Oracle's market share to the dumb
and dumber.
ltiu
On Friday 30 August 2002 12:24, you wrote:
> oradim is only a windows thingy. Those of us on real OS's use svrmgrl
> or sqlplus depending on version. Are you saying that they are going to
> port ora
thats the Stupid WINDOZE way.
joe
ltiu wrote:
>oradim -startup -sid -pfile ???
>
>They got rid of SVRMGR.
>
>ltiu
>
>On Friday 30 August 2002 11:08, you wrote:
>
>>How do they expect you to start and stop the database if it goes away?
>>and please don't say OEM...
>>
>>--- "Freeman, Robert"
Absolutely
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas Day
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Naveen,
>
> If you specify a hint Oracle is forced to use the index.
>
Not 'forced'. Hence the name 'hint'.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network
Connected to that, there is a rumor tha M$ will buy
Oracle Corp., with
Larry
Ellison taking the place of Steve Ballmer.
-Original Message-From: Rodd Holman
[mailto:[EMAIL PROTECTED]]Sent: Friday, August 30, 2002 3:24
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
S
Hi All,
i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3
times but don't seem able to get the imp to just load the data and not the
tables as well. Am running solaris 8 &oracle 8.1.7 anything that i might
not be seeing would be very much appreciated!!
TiA!!
Thanks Raj.
I'll give these a try.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 8/30/2002 10:08 AM, Jamadagni, Rajendra <[EMAIL PROTECTED]> wrote:
>I created following two views for developer's use and so far there
>have been
>no complaints ..
>
>CREATE OR REPLACE FORCE VIEW SYSTEM
Title: Missing Redo Log Files and Control File
Hi,
We were almost done setting up a new server for the developers when a hard drive crashed. MTBF sure took a hit on that one! We had a replacement drive installed.
Fortunately we really only lost a control file and redo logs on that disk and
oradim is only a windows thingy. Those of us on real OS's use svrmgrl or sqlplus depending on version. Are you saying that they are going to port oradim to *NIX??
Rodd
On Fri, 2002-08-30 at 13:33, ltiu wrote:
oradim -startup -sid -pfile ???
They got rid of SVRMGR.
ltiu
On Fri
Hi,
I am trying to put together a package that uses the AUTHID current_user
directive to decide whether to let people kill a session or not, and I ran
into a problem.
One procedure will run as SYS, but I need to double-check the requester's
username to ensure he/she isn't trying to kill their ne
What would be the replacement??
-Original Message-
Sent: Friday, August 30, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L
Anyone else hear that SQL*Plus is going away in 10i??
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Aut
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Denis Vasconcelos
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
We only need to start it. It usually stops itself without human control.
That is why we have ora-600 and ora-7445 features implemented in PMON
and SMON. As for starting and stopping, let me be innovative:
What do you say to call the start/stop program "IOR" and have
database startup performed
Just my guess, look at the registry parameter ORA_SID_PWFILE(Sorry my
knowledge is limited to NT only) and see if it is pointing to the right file.
Try restarting the service.
Are you running more than one DB on the same server?
by the way, if you find out the exact reason why this is happening
Nope.
-Original Message-
Sent: Thursday, August 29, 2002 7:47 PM
To: Multiple recipients of list ORACLE-L
If you can't do it in hardware, do it in software. Right?
ltiu
Ji, Richard wrote:
>There is no such hardware limitation like that. Those are the OS i.e.
>software limitations.
oradim -startup -sid -pfile ???
They got rid of SVRMGR.
ltiu
On Friday 30 August 2002 11:08, you wrote:
> How do they expect you to start and stop the database if it goes away?
> and please don't say OEM...
>
> --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> > Anyone else hear that SQL*Pl
Yes, Oracle will sell it as standalone product because it is most useful and
most used client software on Oracle. The licence model is 'per session'.
:-)))
BTW: Anybody's using gqlplus?
http://gqlplus.sourceforge.net/
JP
On Friday 30 August 2002 18:23, you wrote:
> Anyone else hear that SQL*Pl
Hi Jonathan
> I need to create the Scott/Tiger schema in Oracle9i. Does anyone
> recall off the top of their head just where the script to do this is
> located?
The creation script can usually be found in
${ORACLE_HOME}/sqlplus/demo/demobld.sql
Regards
Dale
--
Need instant s
I find that the worst problems I have with SQL*Loader tend to be
language related. The same goes with export/import. I wish there were
better documentation on the NLS parameters.
and yes, it was characterset. What I didn't understand was why when I
selected from NLS_DATABASE_PARAMETERS it showed
I've been sampling active SQL at a rate of 5 Hz and saving the wait information to a
table. Here is one example.
SELECT RUNDATE, EVENT, SECONDS_IN_WAIT, STATE, SEQ#
FROM STATEMENT_WAIT_INFO WHERE USERNAME = 'ARF' AND
ADDRESS = '8992E2C8' AND HASH_VALUE = 3642756738
RUNDATE
Ruth, i got it as i've not file 13'd the email acct yet.
thanks, joe
Ruth Gramolini wrote:
>Does that mean you didn't get my email about presenting my rman paper?
>
>Ruth
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Thursday, August 29,
Check init.ora parameter,remote_login_passwordfile should be exclusive.
regards,
---
Atin Kumar Jain
OCP 8i DBA
IBM Global Services
SO Jamshedpur
0657- 424478,147074
[EMAIL PROTECTED]
[EMAIL PROTECTED]
---
Nooo!!!
On Friday 30 August 2002 09:23, Freeman, Robert wrote:
> Anyone else hear that SQL*Plus is going away in 10i??
>
>
> RF
>
> Robert G. Freeman - Oracle OCP
> Oracle Database Architect
> CSX Midtier Database Administration
> Author
> Oracle9i RMAN Backup and Recovery (Oracle Pre
How do they expect you to start and stop the database if it goes away?
and please don't say OEM...
--- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> Anyone else hear that SQL*Plus is going away in 10i??
>
>
> RF
>
> Robert G. Freeman - Oracle OCP
> Oracle Database Architect
> CSX Midtier Dat
EXCELLENT! This is EXACTLY what I was looking for. Thank you very much!
Erik
-Original Message-
Sent: Friday, August 30, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L
Someone had asked this question ... maybe this will help ..
Batch mode report generation
~~
$ORACLE_HOME/rdbms/admin/utlsampl.sql
Jonathan Gennick <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/30/2002 09:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Creating Scott/Tiger
I need
The same way Digital did. The best product doesn't always win...
-Original Message-
Sent: Friday, August 30, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L
Lotus Notes is good enough and for a time were the number one (and the
only
one). How the hell did they lose market shar
Are you kidding? So what do we use to startup and shutdown db? OEM?
I don't think there is any truth to this one.
Richard
-Original Message-
Sent: Friday, August 30, 2002 12:23 PM
To: Multiple recipients of list ORACLE-L
Anyone else hear that SQL*Plus is going away in 10i??
RF
Rob
I don't know about the user scott/tiger, but the scripts to build the tables
(emp, dept, etc) are in $ORACLE_HOME/sqlplus/demo
/opt/oracle/product/9.0.2/sqlplus/demo> ll
total 16
-rw-r--r-- 1 oracle oinstall 3565 May 13 2001 demobld.sql
-rw-r--r-- 1 oracle oinstall 573 May
Hi Genninck,
9i and 8i
$ORACLE_HOME/rdbms/admin/utlsampl.sql
Alessandro Guimarães
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 30, 2002 9:53 AM
I need to create the Scott/Tiger schema in Oracle9i. Does anyone
recall off the t
Someone had asked this question ... maybe this will help ..
Batch mode report generation
To run a report without being prompted, assign values to the
and the report name before running spreport.
The variables are:
begin_snap ->
HERE... herd mentality... Microsoft rules... Microsoft Rules... Oracle
Applications are buggy and user GMT in their log files... Access is better,
Microsoft doesn't sell buggy software... mooo... hey... look at that really
cool cliff... Let's follow those other buffalo ... the jump looks like
fun!
Here's a ksh script that dumps backup files to a remote server. It also
accounts for multiple datafiles per tablespace, which I didn't see coded
in the Velpuri scripts.
Suzy
#!/bin/ksh
#
--
Hi All,
I have a system with 2 databases, both running on the same server 8.0.5.
OS - Windows NT
When i connect thru server manager to TEST, and then issue STARTUP, it starts
up the PROD database using the initPROD.ora file.
On querying V$instance it shows INSTANCE_NAME = TEST
On querying V$datab
On Mon, 26 Aug 2002 13:41:50 -0800, Rachel wrote:
>I am not, by any means, a SQL*Loader expert (Jonathan, I keep meaning
>to get your book!)
Sounds like you've solved this one already, but since you invoked my
name (and in vain too, since I was of no help ), I'll just chime
in to say that my bes
Anyone else hear that SQL*Plus is going away in 10i??
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
The avalanch
I need to create the Scott/Tiger schema in Oracle9i. Does anyone
recall off the top of their head just where the script to do this is
located?
Jonathan Gennick --- Brighten the corner where you are
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com *
http:
Lotus Notes is good enough and for a time were the number one (and the only
one). How the hell did they lose market share?
ltiu
On Friday 30 August 2002 08:28, April Wells wrote:
> found some way to fake out Linux to run Lotus Notes in a shell if I am not
> mistaken, too...
>
> -Original Me
Good morning, everyone.
A running Oracle server contains both library cache locks and library
cache latches. What are the criteria for using a lock vs. a latch for
protecting objects in the cache? For example, at the moment we're
trying to create a new version of a package, but a running sessio
Title: RE: IMPORT sl
I like the way you found the root cause. If
I may paraphrase, you asked the database how it was spending its time, and the
answer guided the remainder of your performance improvement project. I contrast
this method with the traditional approach, which is to try
I had the same issue in a 8.1.6 database and found that was bug related to
the cost based optimizer and materialized views. Never did resolve it but
found that the problem occurred when the table in question had a
materialized view selecting data from in.
Thanks,
caj
- Original Message ---
The universe exists according to our beliefs. If you believe that you have
no choice, then you have no choice. But only because you believe it.
Happy Friday,
Mark "There is no spoon" Stahlke
Denver Newspaper Agency
-Original Message-
Sent: Friday, August 30, 2002 7:58 AM
To: Multi
Wine can run lotus notes. I tested it and it works fairly nice. The only
problem is that I cannot resize the window, so I have to use another
workspace
for it.
> -Original Message-
> From: April Wells [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 30, 2002 11:29 AM
> To: Multiple reci
found some way to fake out Linux to run Lotus Notes in a shell if I am not
mistaken, too...
-Original Message-
Sent: Friday, August 30, 2002 9:49 AM
To: Multiple recipients of list ORACLE-L
oh no, you can always use Lotus Notes with W2K, XP or NT... we are here
such lovely choices we
1 - 100 of 138 matches
Mail list logo
