read ?/rdbms/admin/cataudit.sql
insert into audit_actions values (102, 'LOGOFF BY CLEANUP');
insert into audit_actions values (103, 'SESSION REC');
insert into audit_actions values (104, 'SYSTEM AUDIT');
Scott Shafer
San Antonio, TX
210-581-6217
> -Orig
Come on, Jared, its more fun to:
crontab < /dev/null
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 4:19 PM
> To: Multiple recipients of list ORACLE-L
> Subject
"man kill"
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 9:29 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Cronjob
>
> Anyone whom
Beer is a very good refreshment option.
Seriously, have you configured your job_queue_processes parameter in your
init.ora? Are there any ora_snpx_SID processes running for your database?
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Seema Singh [SMTP:
dbms_job. See the SQL guide for your particular version of Oracle at
http://technet.oracle.com
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Nelson Flores [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 19, 2002 2:53 PM
> To: Multiple r
-syncing, I'd investigate someof the replication management
software from Sybase, Quest, Oracle (generic or heterogeneous services), SQL
Server's utility (I forget the name), etc.
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Ray Gordon [SMTP:[EMAIL PR
> http://www.sapdb.org for the google-impaired...
>
> Looks like cool stuff. Thanks, Emery.
>
> Scott Shafer
> San Antonio, TX
> 210-581-6217
>
>
> -Original Message-
> From: Gordon, Emery {PDBI~Palo Alto} [SMTP:[EMAIL PROTECTED]]
&
Cool! Happy querying...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Jay Hostetter [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 18, 2002 1:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Help with Locking Issue
>
Or use the fromuser=CTXSYS touser=CTXSYS clauses on your exp command?
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Seefelt, Beth [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 18, 2002 1:24 PM
> To: Multiple recipients of list ORACLE-L
> S
How many CPU's will the box hold? This # should be your "requirement", as
you can always negotiate down...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: YTTRI Lisa [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 18, 2002 10:58 AM
>
o it (Created Bug No: 2327827),
and we're working the iTAR with them. Just a heads up, and if anyone has
seen this before please sound off.
Happy DBA'ing,
Scott Shafer
San Antonio, TX
210-581-6217
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAI
How familiar are they with using trace, tkprof, and tuning the SQL they
write?
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Maria Aurora VT de la Vega [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 15, 2002 10:43 PM
> To: Multiple recipients of l
Got to www.google.com and search for "Oracle 7.3 documentation".
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 12, 2002 2:03 AM
> To: Multiple recipients of list ORACL
***inline...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
>
> I think this is good news, Oracle accepting these user groups.
>
*** Assimilation can not be far off. This is a bad thing.
vi.
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Yahoo [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 08, 2002 5:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: How to read user dump file
>
> Hi:
> Can anyone of
As safe as giving your info over the phone. If they're going to sell it,
they're going to sell it...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Brad Weiner [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 05, 2002 10:37 AM
> To: Multi
Do not let the kiddo hit until you've reviewed what is typed on
each line. Kudos for making the effort, although a DBA's day would probably
create emotional scarring in young children...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Dunge
Raj,
I have to agree with your order here. I've seen horrendous problems with
Sun OS upgrades and Sun hardware. HP has been rock-solid. AIX is well, AIX
- 'nuff said.
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Sakthi , Raj [SMTP:
OK, any other details missing frorm your post? Like Oracle version, whether
or not you use a password file, OS type/version, etc.?
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: paPIpapupapePO [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 200
That's because you didn't read the documentation for Oracle. If you do not
have the cd, you can find the sqlplus guide online at
http://technet.oracle.com which details all variations, restrictions, and
abilities of the "connect" command.
Scott Shafer
San Anto
Try either:
man at
OR
at -f r2 -t200204021510.00
Where date is in the form: MMDDhhmm.ss (at least on HPUX). This is in
the man pages (man at).
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Janet Linsy [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesd
Mama always said, "Anal is as anal does..."
--Forrest Gump
PS -- You're right. They're not.
> -Original Message-
> From: Paul Baumgartel [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 01, 2002 4:48 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Seeking opinions
>
>
Well, they're running the same basic product...
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
> Sent: Sunday
Keep the rollback segments out of the cold water. Shrinkage is bad.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Seema Singh [SMTP:[EMAIL PROTECTED]]
If you're running Microsoft SQL Server, then you can be sure it is installed
in the database.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Seema Singh [
Drop and recreate your temp tablespace.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Hamid Alavi [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26,
Yeah, it just follows the old Windoze paradigm of "crash and hope to rebuild
when I come back up".
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Far
ord.
fix:
Upgrade to Oracle 9.0.1 or apply the 8.1.7.2 patchset.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Seefelt, Beth [SMTP:[EMAIL PROTECTED]]
> Sent:
Pick up a couple Shell books at bookpool.com for < $100 and save yourself
some time and money.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Michael Bush [SM
I have some past experience with MUMPS - Run like h@#$ and don't look back.
If CACHE=MUMPS it most definitely is false advertising.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original M
Experience says that nothing is as robust as the marketing trolls would like
you to believe. It is impressive add copy, though.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Messag
Have you tried connecting internal and running @?/rdbms/admin/utlrp.sql
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Praveen Sahni [SMTP:[EMAIL PROTECTED]]
&
Doh! disregard. Brain #$%^ in effect...
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: [EMAIL PROTECTED]
> [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March
Do a:
desc dual
SQL> desc dual
NameNull?Type
---
DUMMYVARCHAR2(1)
SQL>
You are trying to do a bitand on a varchar2 column.
Scott Shafer
San Antonio, TX
210-581-6217
"C
Anjo, if you don't mind me asking, where can these values be found in TFM,
books, or on the web?
Thanks,
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: A
Funny, I have 35 sites working with global_names=FALSE doing snapshot
replication (7.3.4 and 8.1.7 sites), without specifying the domain name at
link creation time. Are you refering to advanced replication/multi-master
replication only?
Scott Shafer
San Antonio, TX
210-581-6217
"Common
And you need to wonder why I stay away from Adv Replication? Oracle needs
to work on these bugs, er, I mean _features_ to make Adv. Rep. ready for
primetime...
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desp
set GLOBAL_NAMES to false from sql prompt and in the init.ora file.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Denham Eva [SMTP:[EMAIL PROTECTED]]
> Sent:
The Vampire-D sucked him dry.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Walter K [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 01, 2002 1:13 PM
> To:
Run, don't walk.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Don [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 27, 2002 12:48 AM
> To:
Why not bring up a dos window, ftp to the unix server and get the files in
question. Easier than trying to ftp back the other way.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Messag
Java will go a lot sooner
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Jason Rowski [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, February 12, 2002 4:03
Solaris. Languages come and go (flavor of the month like java), but servers
will be there always.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Jason Row
The tnsnames.ora on your windows box does not have the correct connect
string in it.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Daiminger, Helmut [SMTP:
See http://www.orafaq.com and poke around the scripts area.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Quamrul Polash [SMTP:[EMAIL PROTECTED]]
> Sent:
Good to know. Thanks, Bambi. How's the store going?
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Bellows, Bambi [SMTP:[EMAIL PROTECTED]]
> Sen
Umm, how do you really feel about it?I have to concur though -
OPT101 is excellent!
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: K Gopalakrishnan [SMTP:
Poor thing got spanked a lot, eh?
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, January 23
Its supposedly the terminal patch, so yer guess is as good as mine. Of
course, v10.3 will solve world hunger...
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: J
Version:8.1.7.3
Last updated:16-OCT-2001
Size:626K (641360 bytes)
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great t
Knock-knock.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858
.
# create a named pipe
mknod exp.pipe p
# read the pipe - output to zip file in the background
gzip < exp.pipe > scott.exp.gz &
# feed the pipe
exp userid=scott/tiger file=exp.pipe ...
Scott Shafer
San Antonio, TX
210-581-6217
"Co
Surveys paid for by who? See who's footing the "Bill" so to speak.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: DENNIS WILLIAMS [SMTP:[EMAI
on hakon:
scp user@hardy:/prod/sas/data/file /dir/on/hardy/
is one way if you have ssh/scp installed.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: [EMAIL
Be afraid. Be very afraid...
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: JOE TESTA [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, January 08, 2002 2:01
Or just a lack of supervision/QA.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Johnston, Tim [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, January 07, 2002 6:16
How about changing it in one location, and then scp/rcp/ftp the file out to
all the other servers. You could script it to loop through hosts.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Ori
t; (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the o
Your manager is full of sh** (in technical terms). Poorly written queries
are usually the problem, more so than any data model. Let me guess, he's
the manager for the development team?
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Sim
Title: Export via pipe ksh script
From http://www.orafaq.com (in the sig for this
list):
Can one export to multiple files?/ Can one beat the Unix 2 Gig
limit?
From Oracle8i, the export utility supports multiple output
files. This feature enables large exports to be divided into files w
___
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Shafer
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (8
the HELP command for other information (like subscribing).
_____
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
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 HE
--
To REMOVE 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
Title: Data Archiving
On new db:create a db link from the new server to
the old server.
create table history_table as select * from orginal_table
where criteria = meets_my_criteria_for _archiving;
On old db:
delete unneeded (archived) records from the original
tables.
--Scott
-
OK, who works for textron? And how did answers to "database administration
questions" turn out to be "sensitive"? Hehehe...
--Scott
- Original Message -
To: "'Scott Shafer'" <[EMAIL PROTECTED]>
Sent: Monday, December 24, 2001 5:49 PM
tak
*** inline...
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 24, 2001 1:15
AM
Subject: database administration
questions
Hi! I'm looking into getting
into the field of Database Administrati
u want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gene Sais
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Pub
D] (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 command for other information (like subscribing).
_____
ng Lists
>
> To REMOVE 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 li
information (like subscribing).
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Shafer
INET: [EMAIL PROTECTED]
Fat City Network
e recipients of list ORACLE-L
> Sent: 12/15/01 10:15 AM
>
> Yes. See the DB Administrator's Guide online at
> http://technet.oracle.com
> Its often easier to do it by hand, rather than let the crappy wizards
> screw
> it up.
>
> --Scott Shafer
>San Anton
Yes. See the DB Administrator's Guide online at http://technet.oracle.com
Its often easier to do it by hand, rather than let the crappy wizards screw
it up.
--Scott Shafer
San Antonio, TX
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAI
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Shafer
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 53
ike subscribing).
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Shafer
INET: [EMAIL PROTECTED]
Fat C
> > > San Diego, California-- Public Internet
> > > access / Mailing Lists
> > >
> >
>
> > > To REMOVE yourself from this mailing list, send
> an
> > > E-Mail
implementation?
>
> Ron Smith
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Shafer
INET: [EMAIL PROTECTED]
Fat City Network Services
OTECTED] (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 se
; (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
Please see the official ORACLE-L
cess / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY
g).
______
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Shafer
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-
com)
>
> ** The opinions and statements above are entirely my own and not
> those of my employer or clients **
>
>
> > -Original Message-
> > From: Scott Shafer [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, December 03, 2001 7:50 PM
> > To: Multipl
> > Hallo,
> >
> > Can anybody tell me simply how the listener works?
> >
> > Thanks in advance
> >
> > Roland S
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Ple
e 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).
_
Do You Yahoo!?
Get your free
ee @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Shafer
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Interne
t;
>
> "Khedr, Waleed" wrote:
> >
> > Thanks,
> >
> > Waleed
>
> _
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Autho
hoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Shafer
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Inte
, 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).
_________
Do You Yahoo!?
Get your free @yahoo.com addre
; San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the m
t your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Shafer
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / M
According to Oracle, this is a
> bug. Does someone know of a work-around?
>
> Jeff
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
I seem to remember Ralph Kimball writing in one of his DW books that the
RI and constraints should be enforced in the app layer as well. However
I might be wrong (once this year isn't too bad, eh?) ;-P
Scott Shafer
San Antonio, TX
Henry Poras wrote:
>
> That is probably true t
Try sumthin' like:
EDATE=$(date +%C%y%m%d)
FILENAME=name${EDATE}.dmp
exp / file=${FILENAME} ...
Do a 'man date' to see the different formatting options.
HTH,
Scott Shafer
San Antonio, TX
Jared Still wrote:
>
> -- Forwarded Message --
> D
; script to split the compressed file into smaller chunks using the
> standard UNIX split utility.
>
> HTH
> Tony Aponte
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORAC
h) - its worth it! Check bookpool and amazon...
--Scott Shafer
San Antonio, TX
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, November 19, 2001 6:10 PM
> Hi Bruce,
>
> I thought of that but we have many VER
Have you analyzed the indexes in question? Isn't there an 'analyze
index validate' command?
--Scott Shafer
Converse, TX
[EMAIL PROTECTED] wrote:
>
> We have some block corruption on indexes in a copy of a database that was
> restored
> to an alternate host?
>
(SA) has been hit, but definitely not as hard as
> > > > Austin/Dallas/Houston. I'll probably regret this (if I end up
> > > > competing for
> > > > a job), but anyone looking for a job could do a lot worse than
> > > > looking in
> > &g
Make the parfile readable only by the oracle user (or whatever user is
running the export).
Scott Shafer
San Antonio, TX
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, November 15, 2001 10:20 PM
But (while perform
> > Sent: Wednesday, November 14, 2001 12:13 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Linux or Solaris Intel. And maybe (gods help me! ) NT?
> >
> > Scott Shafer
> > San Antonio, TX
> >
> > Regina Harter wrote:
> >
>
> This is 8.1.7 on Solaris.
>
> Thanks,
> Helmut
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Shafer
INET: [EMAIL PR
101 - 200 of 409 matches
Mail list logo
