Hi gurus,
Greetings.
c:\> sqlldr80 userid=msalah/msalah@qtel control=c:\test.ctl
ORA-12203: TNS:unable to connect destination
SQL*Loader-704: Internal error: ulconnect : OCIServerAttach [-1]
But am able to connect with SQL*Plus with the same username/password.
Why it's showing this error, the
Does anyone know why a USE_HASH hint that's properly coded might not work?
Without it my query uses nested loops, but with it the plan changes to
sort-merge, not a hash join like I want.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTE
Okay, first the rant they want me to build a new database to hold logs
of every time someone hits a page on our website or uses one of the
functions on the site. Without a new server or disk, on a box that
currently holds the OLTP database, on a disk array that is RAID 5 and that
EMC want
if 40 is small, is 16 microscopic? (and of that 16, 5 are consultants)
>From: Jared Still <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: !! Keeping the list alive
>Date: Sat, 01 Sep 2001 12:35:23 -0800
>
>
>Just to add
Jared,
You are so incredibly lucky. I work for VoiceStream - a bazillion
duhvelopers and DB-ehs?.
~Ruth
Chaos, panic, and disorder - My work here is done!
-Original Message-
Sent: Saturday, September 01, 2001 4:35 PM
To: Multiple recipients of list ORACLE-L
Just to add to my previo
Another way of saying it -
Nothing is impossible for the person who does NOT have to do it.
Jared Still wrote:
> Hmm, lemme try again.
>
>
>
> S*u*b*s*c*r*i*p*t*i*o*n service is definitely not an option.
>
> Neither Bruce or I can manage something like that.
>
> Jared
>
> On Wednesday
Hmm, lemme try again.
S*u*b*s*c*r*i*p*t*i*o*n service is definitely not an option.
Neither Bruce or I can manage something like that.
Jared
On Wednesday 29 August 2001 12:35, Jacques Kilchoer wrote:
> -Original Message-
>
> >Alex, that is an excellent idea! I second that not
Didn't??
Got news for you, they still need it.
Jared
On Friday 31 August 2001 11:45, Rachel Carmichael wrote:
> oh, just about never :) but it would do basically the same thing. It's
> just that Oracle rarely ever needs to do this and Sybase rarely DIDN'T need
> to do this
>
> From: [EMAIL
You got it.
Jared
On Friday 31 August 2001 15:40, MacGregor, Ian A. wrote:
> One will definitely need a separator so one can tell course 111 from course
> concat(course 1, course 11). I should have indicated that. If you are
> asking why you used a colon specifically, I don't know.
>
> Ian M
Just to add to my previous comment:
I'm working at a company with small ( 40 or so ) IS shop.
The weak do not survive in this environment. The developers
I work with here are great. They're bright, hard working and
un-egotistical. They are even will to take direction from the
DBA in database
I *said* I wasn't sure it was drop datafile or drop tablespace :)
I sit corrected
>From: Joe Testa <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: file/tablespace deleted at the OS level
>Date: Sat, 01 Sep 2001 09:46:
Charlie,
What I have used in the past in testing only.
For this example, lets call them fodder_data and fodder_index.
startup mount
alter database datafile 'F:\ORACLE\ORADATA\TEST\FODDER_DATA01.DBF'
offline drop;
alter database datafile 'F:\ORACLE\ORADATA\TEST\FODDER_INDEX01.DBF'
offline drop;
a
ÌÌÌ
X-Declude-Sender: [EMAIL PROTECTED] [63.
startup mount
alter tablespace offline drop;
alter database open;
drop tablespace including contents;
create tablespace
shutdown and do another backup
offline drop tells oracle to ignore the fact that it's not there, you're
going to get rid of it anyway.
I'm doing this from memor
A modern day classic!
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 31, 2001 4:20 PM
> I am in charge of 273 databases at sites throughout the world, some of
them
> in places with no electricity where we have an elephant on a tr
Oracle V9.0.1 Solaris 2.6 a development instance
I made more than one mistake which resulted in me
deleting a file that held single table tablespace. Now
the instance won't STARTUP (naturally). Since I
can easily recreate the data, I'd like to know how
to convince Oracle to ignore the missing fil
tran wrote:
>
> Hi Guy,
>
> Could someone kindly tell me what's difference between 8.1.6 & 8.1.7
>
> Tran
one of them is supported after 31-OCT-2001.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Drake
INET: [EMAIL PROTECTED]
Fat City Network Services
Ian,
Stephane mentioned the possibility of using analytical functions. I know
that you have used the analytical functions in the past so you may have
already taken Stephane's idea and run with it, and maybe Stephane has as
well. If not, here is Stephane's solution modified so that the DB function
okay, I'm in awe here.
>From: "Don Granaman" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Duhvelopers and DB-ehs?
>Date: Fri, 31 Aug 2001 17:26:24 -0800
>
>RE: Duhvelopers and DB-ehs?OK. I've resisted the temptation
> I got calls from six different recruiters within two days
So none of them had a handful of resumes on their desk from Oracle DBA's
desperately seeking work
;-)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Netwo
20 matches
Mail list logo