Come on, Rachel - anything named 'La Frog' is bound to taste like the bottom
of a bayou!
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to
Oh no! Not again!!!
Scott
> -Original Message-
> From: Belov Igor [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 4:01 AM
> To: Multiple recipients of list ORACLE-L
> Subject:
>
> HELP
>
--
Please see the official ORACLE-L FAQ: http://w
ME??? Who said anything about me?
Almost... A few more drinks - who knows what would have happened...
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transiti
He, he, he... forget the good beer - last week at a client "get together"
that happened to occur at a karaoke bar... Well, lets just say that a
microphone, feather boa, shots of whiskey, and cheap beer are a dangerous
combination in a dba's hands...
Scott Shafer
San Antonio,
Post the pic! :-P
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grâce via your Ninja
Death Touch
Lisa,
Please! Have a glass of a decent (or at least cheap) Merlot and come back
to the dark side - UNIX BIGOTS UNITE!!!
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, a
A really fat and angry crane - just ask my duhvelopers! LOL!!!
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administe
It didn't, but its usage as such allowed for a better acronym... ;-P
Scott Shafer
San Antonio, TX
> -Original Message-
> From: Mark Leith [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, June 06, 2001 3:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject:
What about young, strong, evil, and twisted?
Scott Shafer
San Antonio, TX
> -Original Message-
> From: Thater, William [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, June 06, 2001 3:03 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: OT RE: organization
Gee, thanks!
Well, work and laziness has kept me out of the gym for a month now, but let
me get a competition cycle started and get back to you... ;-)
Scott Shafer
San Antonio, TX
> -Original Message-
> From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, June 06,
And ammunition...
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grâce via your Ninja
Death Touch
I" is the current flavor in IT marketing. See HPUX 11i, Oracle 9i, etc,
"O" will be for "Oh my gods! How will I ever manage this monster!" in the
next generation of systems,
"U" and "Y" are yet to be determined... Or maybe combined into "YU" (wh
Only if the story line matches up to Pink Floyd's "Dark Side of the Moon" as
well as the original WoZ... Careful taking the bad witch part - monkeys may
have to fly out of your butt!
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can
rained in
administration so you can talk real system architecture with them (not
that I'm an admin or architect, I am neither). IBM's support is also
top notch.
Special thanks
to the following people for their responses:
Scott Shafer
Ron Morton
Lee Robertson
Jerry Hess
Michael Hand
Murali
appropriate
instance when it has been accepted (at least in theory). This often ends up
being the DBA (me).
Not as elegant as a journaling file system -
Can I get an "A-men!" for a journaling RDBMS!?!?!? -
but it seems to work with a minimum of hassle...
Scott Shafer
San Antonio, TX
21
ontaining: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into
Kill the SNP OS process. It will re-spawn itself when needed.
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the
I love it! i'll get my wife (artist type) to draw it up!!!
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer t
YES
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grâce via your Ninja
Death Touch, you step on a
'IF YOU CAN READ THIS, YOU ARE A CERTIFIED PIG FUNDAMENT'
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to adminis
!!!EM PLEH
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grâce via your Ninja
Death Touch, you step
ding the message and opening any attachments,
the recipient accepts full responsibility for taking protective and remedial
action about viruses and other defects. Cendant Corporation or Affiliates
are not liable for any loss or damage arising in any way from this message
or its attachments.
--
Cartesian Join?
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grâce via your Ninja
Death Touch
F "here doc"
and a seperate:
sqlplus user/$PASSWORD << FOE "here doc" immediately following. (this
works fine - go figure).
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of
do this? I spent too many hours in the sun this past
weekend and am drawing a blank...
Thanks,
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Com
Not devoid of content, but seriously in need of: HELP
Am I stupid?
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administe
E yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP comm
How about:
"Oh bother!", said Pooh, as the police closed in...
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to
Isn't that (removing Steve from Lazydba) akin to removing your brain to
spite the space between your ears?
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you tra
You need... HELP
> -Original Message-
> From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 10:46 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Steve Adam's Removal
>
> Oh Well ... I'll go hide now ... the Politically Correct po
Kneel mortals! The Goddess hath spoken!!!
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grâce via
Did you try th "./" syntax? i.e.:
$ ./test1
Sorry, I'm not more familiar with Uwin. If the above syntax works, you can
set your unix $PATH variable to include "." (dot - no quotes) to specify
the current working directory, i.e.:
export PATH=$PATH:.
Scott Shafer
San
Thanks to Patrice B. for that...
I am not worthy - I am pig fundament...
HELP
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monk
Selectively, to individual email addresses. Or is everyone getting hit?
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monk
If anyone receives mail from this individual, please scan any attatchments
as it contains the W32/BadTrans@MM vi*us...
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, a
presume because it has a
> comma before it and it assumes that it is a different field. I can't
> figure out any way to get this loaded with the trans_date field
> containing both the date and time.
>
> This is on Oracle 8.1.6.0 on Sun Solaris.
>
> Any suggestions?
ERTIES ...
2) DROP TABLE MICROSOFTDTPROPERTIES;
3) see who/what/if anything breaks, whines, or snivels...
All assuming this is a development instance. You WERE NOT letting them poke
around in a production instance, correct?
Your Friend in Evil,
Scott Shafer
San Antonio, TX
210-581-6217
&quo
And managing the concurrent managers is an art in itself...
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Co
Title: RE: Database Down
Here some help from Paul Drake on NT
diagnostics tools you can put in place to send yourself event
logs.
Sample code to email event logs
C:\>blat -install mail.mydomain.com
[EMAIL PROTECTED]
Failed to open registry key for Blat profile , using
default.
SMTP server s
7;||chr(34)||'CMD /C DEL /Q @FILE'||chr(34)||';');
HTH, (hazardous terminal halitosis)
Scott Crabtree
-Original Message-
Sent: Wednesday, May 23, 2001 11:45 AM
To: Multiple recipients of list ORACLE-L
DBAs
How do I delete files from NT which are older than a week. I
date and time.
This is on Oracle 8.1.6.0 on Sun Solaris.
Any suggestions? Thank you.
--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer
--
Please see the official ORACLE-L FAQ: http://www.or
wap system is currently
using.
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup d
mailx -s "Backup Log file" [EMAIL PROTECTED] [EMAIL PROTECTED] <
/dir_path/db_backup.log
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
Are you stupid?
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, May 21, 2001 3:26 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Galactically OT - job offer from MARTIAN ICECAP
&
How about "User Pot Pie"?
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Glasrot, Nechama [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 18, 2001 3:53 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: OT: RE: job offer f
I disagree with the restriction of no users. After all, what better dietary
plan than "all the users you can catch, kill, and eat!" Otherwise, I'm in.
I can haul some of our ordinance in my F-150 - it'll even be dry with the
hardtop on the bed...
Scott Shafer
San Anto
Blame Canada!
Seriously, you won't lose a hand in Saudi if you don't steal. If you can't
handle the consequence, don't do the crime. Its not a bad law - it just
needs to be enforced in a transparent, rule-of-law judicial system.
Scott Shafer
San Antonio, TX
210-581-6
http://www.oracle.com/oramag/code/tip01168.html
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, May 16, 2001 2:57 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Export Spli
HANGE#
ARCHIVE_CHANGE#
- --
---
XX03/29/01 15:35:01NOARCHIVELOG 4.2975E+12
4.2975E+12
You don't get the "connected" message.
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
&
ase see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Boivin, Patrice J
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
Are you stupid?
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 15, 2001 12:27 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Mean/Median
>
> geez louise,
&
e view and
join my_all_cons.tname = A.table_name in the outer. Great for watching
recursive sql for those with Unabridged Data Dictionaries
HTH,
Scott Crabtree
-Original Message-
Sent: Monday, May 14, 2001 11:31 AM
To: Multiple recipients of list ORACLE-L
Dick,
That's the best parable I've read in longer than I can remember...
Thanks,
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, May 14, 2001 4:06 PM
> To: Multiple recip
ftp the file to the server again in binary mode instead of ascii...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Mohit Goyal [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2001 6:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject:
Diana,
Sounds like an excellent alternative to higher end systems (shoots self in
oracle-foot). Have you tested how well it scales yet?
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2
NSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it"
ULL VARCHAR2(30)
COLUMN_NAME NOT NULL VARCHAR2(30)
POSITION NUMBER
SQL> select constraint_name , table_name, column_name from user_cons_columns
ord
er by constraint_name;
Above query is crude, but effective...
Scott Shafer
San Antonio, TX
2
4
INDEX RANGE SCAN AD_24_IDX_1
FILTER
TABLE ACCESS BY INDEX ROWID AD_25
INDEX RANGE SCAN AD_25_IDX_1
Scott Crabtree
Veritas Certified Survivor
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Cra
VNC works great with Linux and Solaris. All available all the time... gotta
love it.
Scott Hayes
I downloaded VNC sometime ago. Works very nicely, especially on NT servers
instead of PC Anywhere. Haven't tried the Unix variants though. One
irratating
habit it has is on screen refres
Hola, Dirk!
So what was the "final combination" that fixed things? That info might make
it easier for one of the list gurus to tell you why it worked...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Nuno Souto [SMTP:[EMAIL PROTECTED]]
> Sent
Eric,
Are you thinking of a little UFO chasing at night? They can shoot you for
going too near Groom Lake...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 3:26 PM
> To: Multipl
I was thinking Spetznaz, but I guess the 82nd will do... ;-)
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Thater, William [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 12:46 PM
> To: Multiple recipients of list ORACLE-L
> Subject:
Yeah, but its good for "color" and the occasional comic relief. After all,
dba'ing is pretty high pressure at times...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, M
Certifiably!
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 12:33 PM
> To: Multiple recipients of list ORACLE-L
> Subject: OT RE: sorry,
>
&
Why does it have to be an either/or choice? Lets do 'em all!!! ;-)
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, May 07, 2001 4:52 PM
> To: Multiple recipients of list ORACLE-L
> Sub
h the list
can interpret it differently.
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: William Beilstein [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, May 07, 2001 4:52 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE:
>
> That
Most importantly, DO NOT forget the nose ring! A large one...
(no nose ring here, just the occasional goatee and a few interesting scars)
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Marianne Brooks [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, May 07,
And my bill will be in the mail! ;-)
I find the combination of size, scowl, and shaved head to be an effective
"management behavior restructuring" tool. LOL!!!
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Adams, Matthew (GEA, 088130) [SMTP:
Or tables were imported with compress=y? Or an alter index rebuild (into
one extent for an index)? Anyone?
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Patricia Ashe [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 24, 2001 3:47 PM
> To: Multipl
SET ECHO OFF;
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 24, 2001 3:12 PM
> To: Multiple recipients of list ORACLE-L
> Subject: spool command
>
> Hi All!
> I
Make an entry in your tnsnames.ora like the one below:
DBSID_LOOP = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1601)
(HOST=127.0.0.1))(CONNECT_DATA=(SID=DBSID)))
Then create your db link with: using 'DBSID_LOOP';
It should work, this is on HPUX, Oracle 7.3.4.
Scott
Can you edit the install scripts to change the pasword? Just curious as I
haven't seen OID yet...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Paul Baumgartel [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 2:11 PM
> To: Multiple r
Start running explain plan for your queries. Sounds like you have a
cartesian product somewhere in the code...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Seley, Linda [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 12:41 PM
> To
and
Sorry for the long post
(I didn't include the query because it make this post even
longer, if anyone would like to see it I will email it offline)
Scott Crabtree
Professional Software Systems
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Crabtree
IN
CalendarString's definition is spelled differently
than in the instances where you are referencing it.
- Original Message -
From:
Neil MacDannald
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, April 04, 2001 2:41
PM
Subject: PL/SQL - invail declare of
Have you tried running the scripts as 'su - oracle -c ' from
root? Or is this not possible with your current solution?
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: steve mcclure [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 3:23
True. ;-) But considering my foot-in-mouth disease lately, I figured I'd
phrase my response as a question...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Tim Sawmiller [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 2:41 PM
&g
needed for
recovery in the online logs has been overwritten, then the database will be
unrecoverable.
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Zhou, Tapiwanashe [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 10:05 AM
> To: Multiple recipi
60 seconds * 60 minutes =3600 secnods per hour.
3600 * 24 hours = 86400 seconds per day.
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Ravindra Basavaraja [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 02, 2001 11:00 PM
> To: Multiple recipients of
(Oracle8i Supplied PL/SQL Packages Reference)
HTH,
Scott Crabtree
-Original Message-
Sent: Saturday, March 31, 2001 7:00 PM
To: Multiple recipients of list ORACLE-L
Hi!
Is there a function in Oracle that returns a random number, when it's
called?
e.g. rnd (1,1000) should return a r
That was Dina Myer. Denise Richards was the prissy, Mr. Ed/Nancy
Kerigan-looking starship pilot...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 30, 2001 4:15 PM
> To: Multiple recipi
Helmut,
Try
update tablename set column1 = value1, column2 = value2 where rownum < 1
Scott Crabtree
-Original Message-
Sent: Thursday, March 29, 2001 6:51 PM
To: Multiple recipients of list ORACLE-L
Hi!
Can I update two columns in a single update statement? What is the ex
For dedicated server connection, this is part of process memory (PGA). For
multi-threaded server, the UGA is allocated from either the Shared Pool or the
Large Pool, if the Large Pool is configured (recommended).
Regards,
Scott
Crabtree
-Original Message-From:
Chuck Hamilt
Thanks for the correction. I'm away from the doc CD at the moment as we are
moving offices...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: William Beilstein [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 1:19 PM
> To: Multiple r
IIRC, there is a flag for import "destroy=y" to do what you want. This is
very dangerous and you should research all the implications before trying
it. If you don't have the docs, try http://technet.oracle.com and read up
on the import options.
Scott Shafer
San Antonio,
S' ???
I have been trying this for a while and cant get it..
Thanks for the help. This is a DB that is limited in Hard drive space so I
need to conserve..
Scott Hahn
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Hahn
INET: [EMAIL PROTECTED]
Fat City Ne
, if you are
just trying to build a logical model you can strip most of the columns out
of the text file and start from there.
HTH,
Scott Crabtree
-Original Message-
Sent: Friday, March 23, 2001 8:21 AM
To: Multiple recipients of list ORACLE-L
Hallo,
I am doing a reverse
I am not at my terminal where my online docs reside and I can't get out to
metalink ATT - or I wouldn't ask, but:
Can a simple snapshot be created on a view? View on master site tables, I
want a snapsot of the view data on the remote system. Oracle 7.3.3, HPUX.
Thanks,
Scott
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what yo
Todd,
Sorry, I spoke too soon,
we are patching to 8.1.7.0.2 on NT
MetaBlurb Quote about 8.1.7.1
"No date on Windows NT, it is still listed as delayed
HP-UX 3/23/01
AIX 3/23/01
Compaq 3/16/01 "
Sorry about the disinformation.
Scott
-Original Message-
Sent:
Todd,
Your skepticism is healthy, but Metalink is not:-) 8.1.7.1 is the
latest patch AFAIK.
Scott
Support Status
~~
Release Comments
8.1.7.0 Oracle8i Release 3 Base Release
See [NOTE:120801.1] if installing on Unix.
8.1.7.1
Be afraid... Be VERY afraid!
Actually, considering the German, Czech, and Polish influence in TX,
sausages of all variety are exceptionally good here.
Scott Shafer
San Antonio, TX
"2 + 2 = 5, for very large values of 2..."
> -Original Message-
> From: Warthlin
Mark,
My wife thanks you. She was just wanting chocolate cake...
Scott Shafer
San Antonio, TX
"In /dev/null no one can hear you scream..."
> -Original Message-
> From: Mark Leith [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 16, 2001 9:27 AM
> To: Multi
message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Scott Canaan ([EMAIL PROTECTED])
"Life is like a sewer, what you get out of it depends on w
Are you doing a consistent=y export? Was there significant activity on the
system?
Scott Shafer
San Antonio, TX
"In /dev/null no one can hear you scream..."
> -Original Message-
> From: Charlie Mengler [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 16, 2001 8:42
No recipes, but the occasional orneriness shows through. Wouldn't have it
any other way - perfection is boring...
Scott Shafer
San Antonio, TX
"In /dev/null no one can hear you scream..."
> -Original Message-
> From: Andy Duncan [SMTP:[EMAIL PROTECTED]]
> Sent
Because NT is patently incapable of cleaning up after itself.
Scott Shafer
San Antonio, TX
"In /dev/null no one can hear you scream..."
> -Original Message-
> From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 1:16 PM
> To: Multi
Andy,
Good to see you back!
--Scott Shafer
"In /dev/null no one can hear you scream..."
> -Original Message-
> From: Andy Duncan [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 4:21 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE
Missing a , at m099VARCHAR2(104)
HTH,
Scott Crabtree
-Original Message-
Sent: Thursday, March 08, 2001 11:48 AM
To: Multiple recipients of list ORACLE-L
__
Pat Gorden-Ozgul BNL-ISD Systems
[EMAIL
use 1-6 for every day except Sunday and
1-5 for every day except Saturday and Sunday.
Days in cron are labelled 0-6, starting with Sunday, respectively.
i.e.,
00 17 * * 1-6 /opt/oracle/admin/scripts/
00 17 * * 1-5 /opt/oracle/admin/scripts/
--Scott Shafer
San Antonio, TX
> -Origi
501 - 600 of 614 matches
Mail list logo