Is anyone planning on going to IOUG conference in
Toronto, CA, next
spring(2004)???
Joe
Some papers submitted ...
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services
Hi good people-
Does anyone out there know of the equivalent of oracles
RMAN in MS SQL server environs.
Im investigating the possibility of having my SQL
server dump the backups direct to a third party tape library VERITAS to
be specific.
Your input on this thread will be highly
All,
I just purchased a Oracle9i Fundamentals I exam guide published by Oracle
Press and am very disappointed with the quality of the publication. There
seems to be quite a few mistakes, misleading sentences and typos (not in
the Errata) which is very frustrating.
Also, there is a question
There is no MSSQL utility that is directly
equivalent to RMAN. You use Enterprise Manager or Query Analyzer to manage
backups.
Gudmundur
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, September 16, 2003 9:39
Hi,
My target instance is 9.2.0.4 on Host A ( Ms-win2k + SP3 ).
My recovery catalog is also 9.2.0.4 on Host B ( Ms-win2k + SP3 ).
My target destination for backup files is R:\ which resides
on Host C (WinNT).This drive R:\ is common to both Host A and B.
Things work fine accessing R:\ from
Title: Message
Hi
Plan of the
Benchmark = ? If you mean an action plan of important steps ?
We have just
started. I Shall send it to you shortly.
Monitoring of
Actual Bandwidth thruput (MBPS) used versus that set on WAN will be done .
(other than actual
application transaction
You can actually use Database Maintenance Plans, to mimic RMAN to a certain
extent. Database Maintenance Plans is basically a wizard that generates a
load of MSDB jobs that get run by the SQL*Agent. This does have some
limitations though. It has no support for differential backups, doesn't
support
This
beast does not exist. You can use the Database Maintenance Plans in EM to
manage your backups. I have found these to be flaky and prefer writing my
own custom backup plans in scripts and schedule these as jobs. >From my
experience on SQL Server I recommend doing a native SQL Server
(reposting)
Hi!
I think you should focus on why you do have bad performance/CBO decisions
when all tables have been analyzed. Finding most expensive operations
(v$sql, 10046 trace, tkprof) - comparing their execution plans with
different statistics (tkprof, explain plan, v$sql_plan in 9i) -
(reposting)
Afaik, vi can run in non-interactive, batch mode too.
But I'd go with tail +6
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, September 14, 2003 10:49 PM
Mladen ,I want to automate this thing. So don't want
to go with
No. I mean the goals of the benchmark. What are you measuring and why.
On 2003.09.16 06:10, VIVEK_SHARMA wrote:
Hi
Plan of the Benchmark = ? If you mean an action plan of important steps
?
We have just started. I Shall send it to you shortly.
Monitoring of Actual Bandwidth thruput (MBPS)
(reposting)
Hi!
In 9i, you can actually dbv files online. No blocks are falsely detected
as corrupt, they're just rescanned in case block header tail SCN and wrap
bytes don't match. If the block is continuously in change, then block is
reported as being in flux not corrupt.
Tanel.
-
Hi, friends:
We plan to purchase a HDS 9570 storage system with 4Gb Cache/14 Disks to
replace current Sun T3 storage.
Our database is an OLTP system with 80%read/20 write.
But decision has to be made whether HDS 9570 really worth its price and
how much it outperforms sun T3.
Those
If I mark a job as broken to prevent its being run and later mark it as
being unbroken, it appears that by default the "next run date" is set as
the current date. If I want to have the job rescheduled back to its
original date/time, is there a way to do that. Let's say the job runs
daily at
Title: Configuring RMAN
You
have to create the catalog. Check the docs to see how to do this. In
8.1.7 I think it is simply create catalog. Then you have to register
the databases you want to use this catalog for, etc. The docs are quite
good.
HTH,
Ruth
-Original Message-From:
It looks like your 8i database is defined with national char set of
WE8ISO8859P1 and your target is defined with AL16UTF16 as national char set.
They have to match if you want to transport tablespace.
See in metalink:
Note:66320.1 Subject: Changing the Database Character Set or the Database
If my presentation gets accepted. I can't afford it otherwise.
Ruth
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Joe Testa
Sent: Monday, September 15, 2003 4:49 PM
To: Multiple recipients of list ORACLE-L
Subject: I know its early since OOW
Hallo,
anyone whom could help me with this.
I am trying to use crontab -e to start a procedure. but I cant get it right.
Anyone whom could help me with the command how to write if I want a program in unix to
be scheduled to run
every monday at 6 o´clock in the morning?
Thanks in advance.
Title: RE: Cron question
$ man cron
That is all!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 16, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L
Subject: Cron question
Hallo,
anyone whom could help me with this.
I
Ian,
Thanks for sharing (seriously).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
MacGregor, Ian A.
Sent: Monday, September 15, 2003 11:34 PM
To: Multiple recipients of list ORACLE-L
Last Friday was hot here, and rumor has it our 230 KV power line
sagged and touched
Hi,
have you considered free or commercial search engines to save you the
effort of building the search capabilities into the database, it might
be easier to meld an existing search and index into your oracle app?
just a thought considering you want to concentrate on cost.
kind regards
Pete
--
Hi Nancy
One way we did it three / four years ago whilst working on a finance
system was to build a second archive database. The main database table
in the production system held details of the financial transactions and
was partitioned into 13 partitions split on months, at each month end
the
Title: RE: I know its early since OOW is just over BUT
-Original Message-From: Adams, Matthew (GECP, MABG,
088130) [mailto:[EMAIL PROTECTED]Sent: Monday, September 15,
2003 5:17 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: I know its early since OOW is just over
Hi List
I am trying to automate Number of Oracle Connections
using cronjob.
$ crontab -l
0 8 * * *
/export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sh
/tmp/xyz_conn_monitor.lst 21
$ cat xyz_conn_monitor.sh
/u02/app/oracle/product/8.1.7/bin/sqlplus
user1/[EMAIL PROTECTED]
I asked my manager if I can go, maybe I can present a paper.
Now I just have to decide what topic to present on.
I don't want to do something that is on the bleeding edge, I want to do
something that would be useful to the largest number of people.
I leave the marketing to Oracle Corp., they
Try out self study materials from http://www.selftestsoftware.com they are simply
outstanding.
I have always found them helpful for all my exams. But at same time I never totally
rely on them,
I first complete my ground work with standard syllabus (available on Oracle OCP site)
and Oracle
Right now we are still planning / testing a migration to 9iAS 9.0.2. on
Windows (I know, no comments please), maybe I can do a paper on how to
install, configure, secure, and manage 9iAS effectively.
Yes, a presentation type solving and avoiding problems during 9iAS R2
installation would
Title: Message
Thanks Ruth
and Belinda,
That's what
I'm trying to do, connect to the DB to create the catalog and register the
DB.
This is what
I get when trying to connect to rman
[EMAIL PROTECTED]
oracle]$ rman rman/[EMAIL PROTECTED]rman: can't open rman/[EMAIL PROTECTED][EMAIL
Hopefully, you've read the fine manual and, therefore, know that
.profile, .kshrc and alike are not executed, so you don't have
ORACLE_HOME, ORACLE_SID and alike?
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Oracle
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] on Tuesday,
September 16, 2003 8:19 AM said;
Hallo,
anyone whom could help me with this.
I am trying to use crontab -e to start a procedure. but I cant get it
right.
Anyone whom could help me with the command how to write if I want a
program in
While exporting synonyms , export hangs.
Help ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
Title: RE: SQLPLUS with cronjob is giving problem
oops ... someone forgot to run
. ./.profile in the sh file ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are
Ryan
Will this link help you?. Let me know.
http://asktom.oracle.com/pls/ask/f\?p=4950:12:5406168887273966472::NO::F4950_P12_DATE_MMDD:20010430#tag586600793569
HTH
GovindanK
I am catching up on the mail from the list and I think you can use dynamic
sql.
Something like:
mysql := 'insert
Sami,
You need to set your Oracle Home inside your shell script before you run
SqlPlus. Cron runs as a syetm user, not as your local Oracle user - the
user you log in with.
You could simple add . $HOME/.profile right before your sqlplus
statement, or set your ORACLE_HOME environmental. Type
I encountered this before and it turned out that I had to add the Oracle
environment variables to the shell script. It worked fine when I was
already logged in because my environment variables were already set
through .login or .profile. Add it to your shell script.
-Original Message-
Probably because you need correct command argument. Try rman catalog=
mailto:catalog=rman/[EMAIL PROTECTED] rman/[EMAIL PROTECTED]
or rman traget= mailto:traget=rman/[EMAIL PROTECTED] rman/[EMAIL PROTECTED]
anyone whom could help me to tell what difference is between this mail and mail sent
by [EMAIL PROTECTED] on Thu, 25 Apr 2002 12:46, as it can be found in the list archive.
So the above mentioned message is:
*
Date: Thu, 25 Apr 2002 12:46:07 +0200
Subject:
Define hang. What is export waiting for?
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 10:25 AM
To: Multiple recipients of list ORACLE-L
Subject: exporting
i figured it out a while ago. thanks guys.
From: Govindan K [EMAIL PROTECTED]
Date: 2003/09/16 Tue AM 10:24:38 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: how to do a variable in-list of numbers?
Ryan
Will this link help you?. Let me know.
they are not outstanding. they are ok? They are also expensive. I have found the
Coriolis books to be better than the Osborne books in quality. They dont have 9i ones.
you can get the 8.0/8i ones for $9/each at maryland-merchant.com
Im using those myself, then the docs. I didnt like the osborne
Whenever I talk to DB people or read DB articles/books the consensus is to use a
database centric application. A person who just started recently says he has had alot
of success with 'caching' in a middle tier using BEA Weblogic and limiting calls to
the database.
Does anyone have any
[EMAIL PROTECTED] Outlook. The mailto:; thingy was added by the lovely M$ product, not
me.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mladen Gogala
Sent: Tuesday, September 16, 2003 10:45 AM
To: Multiple
Title: Message
You are not running the RMAN you thought you are -
check your $PATH.
Original Message -
From:
Ramon E.
Estevez
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, September 17, 2003 2:19
AM
Subject: RE: Configuring RMAN
Thanks
Ruth and
Title: Message
September 2003.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Jamadagni, RajendraSent: Tuesday, September 16, 2003 10:44
AMTo: Multiple recipients of list ORACLE-LSubject: Is
Cary's new book
For the curious, what brand/model RAID 1 are you using? Size?
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]
Sent: Monday,
Hello list , I am using oracle 9.2.0.1.0 enterprise edition on windows
A user in my database is able to create materialized views with query
rewrite enabled. But I have not given him 'query rewrite' system privilege.
Isn't it required to create a mat. view with query rewrite enabled ?
drop user
I wouldnt know since i filter any message starting with Hallo to bit
bucket. :)
joe
Gints Plivna wrote:
anyone whom could help me to tell what difference is between this mail and mail sent
by [EMAIL PROTECTED] on Thu, 25 Apr 2002 12:46, as it can be found in the list archive.
So the above
Hi,
I have a column with carriage returns (chr(13) ) and line feeds (chr(10)). I
want to select this column replacing the chr(13) with 'R' and chr(10) with '
' .
Whats the best way to do this?
Regards
IA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Imran Ashraf
Bill, you submitted and didnt get an acknowledgement that it was submitted?
if not, resubmit the info, you should get an email at least saying it
was received(if i remember correctly), now who's paper got accepted is a
few months out still.
joe
Thater, William wrote:
-Original
Title: Message
Does anyone have an
example of connecting to a remote database without a database link? I
think that I have seen it done before by putting in the username and password
and tnsnamesconnection information right into the select statement.
Can it be done?
Tom
Title: Is Cary's new book shipping now?
Anyone know? Hotsos says expected in 09/2003 Oreilly shows info as if it is shipping, bookpool tells me my order is still partially out of stock.
Cary any ideas when it is going to be published?
Thanks
Raj
Resending , didn't seem to have reached the list the first time.
Hello list, I am unable to get a value in dba_indexes(pct_direct_access) for
a bitmap index I created on an iot. I am using Oracle 9.2.0.1.0 enterprise
edition on windows .
Can someone help me by telling me what I need to do.
Title: Message
I believe the official publication date is
09/17.
Tomorrow, Tomorrow Youre
only a Day Away
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mladen
Gogala
Sent: Tuesday, September 16, 2003
10:05 AM
To: Multiple
Title: Nosort parallel dml uses TEMP tablespace
Apologies if this has been covered before but metalink is not clear on the reasons behind it
The database is running version 9204 EE on WinNT Sp6; and the statement is a parallel direct load into partitioned table selecting from a 12.2GB
Weblogic is an application server. Beans are java snippets executed by the
httpd
proces themselves. Beans cannot access/generate HTML. If you wand Java code
do HTML,
then we are talking servlets. Servlets are executed by separate processes
spawned
by the httpd processes (servlet engine).
My guess is that just because the Mat View is enabled for query rewrite
doesn't mean that it's going to happen. The Query Rewite attribute on the
Mat View probably indicates that it is eligible for rewrite.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday,
Nope. It's required to use it, not to create it. By enabling query rewrite,
you
enable the RDBMS to rewrite your query and use it to resolve your select,
even if
the view itself was not mentioned in it. You can always create material view
and do select from it. Material views are snapshots with
Joe Testa scribbled on the wall in glitter crayon:
Bill, you submitted and didnt get an acknowledgement that it was
submitted?
yup. i tried 4 times with 3 different browsers and 3 different email
addresses. i'll give it one more try.
--
Bill Shrek Thater ORACLE DBA BAARF Party
Hi, what is your OS and filesystem?
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.cnoug.org
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 12:34 PM
Last Friday was hot here, and rumor has it our 230 KV power line sagged
The COPY command does NON-dblink connect to the remote database.
-Original Message-
Does anyone have an example of connecting to a remote database without a
database link? I think that I have seen it done before by putting in the
username and password and tnsnames connection
I'll agree with Tom Kyte to a point. Caching database rows in the middle tier
is a bad idea since you have no idea if they've been changed at the database level by
another non three tier application, read that as SQL*Plus for instance. To get around
these problems WebLogic it's
Title: Message
Just
try entering rman. When you get the rman prompt just connect to the target
( which will be the previously set oracle sid. Then you can create the
catalog, register the databases, etc.
Ruth
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL
Title: Message
$ rman
target sys/password catalog
rmanadmin/password
RMAN create catalog
RMAN register database
That's
all.
-OR-
$rman
RMAN connect target sys/password
RMAN connect catalog rmanadmin/password
RMAN create catalog;
RMAN register database;
-Scott
Stefick
Title: Meddelande
Try
this instead:
$ORACLE_HOME/bin/rman rman/[EMAIL PROTECTED]
If you
don't use $ORACLE_HOME/bin it finds another "rman" that exists in the
O/S.
Med vänliga hälsningar/ Kind
regards --
Veriba AB
Per
Title: Message
You
can always use sqlplus copy command to bring back some data without a db
link.
Stephane Paquette
Administrateur
de bases de donnees
Database
Administrator
Standard
Life
www.standardlife.ca
Tel.
(514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]
Title: Is Cary's new book shipping now?
Raj,
The book will be in the OReilly
warehouses tomorrow (9/17), presumably outbound to stores on the same or next
day. Id expect preorders to arrive at customers homes on or near
this weekend.
Cary Millsap
Hotsos Enterprises, Ltd.
only on some OS, like linux.
joe
Per Berghäll wrote:
Try this instead:
$ORACLE_HOME/bin/rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED]
If you don't use $ORACLE_HOME/bin it finds another rman that exists
in the O/S.
Med vänliga hälsningar/ Kind regards
Everyone:
Speaking as a Focus Area Manager, we are missing the following types of
presentations:
1. Presentations for beginners, i.e.: the basics - too many of our
presenters concentrate on the intermediate or advanced. Let me tell you
that we WANT to see more beginner presentations.
2.
Title: Message
This is on
an old 7.3.4 database. I can't find the same error on Metalink.
Anybody have any ideas what might be the cause?
ORA-00600: internal error code, arguments: [17114], [1074346728], [], [],
[], [], [], []
Ron
Smith
Hi Listers,
I have two transactions one embedded into another.
The inner transaction have commit. Is it possible to
rollback all (the inner and the outer) transaction if
the outer one fail?
Thank you for your help,
Kader
__
Do you Yahoo!?
Yahoo! SiteBuilder -
Title: RE: Embedded transactions
no.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
Lets not forget about the vernerable ed...
#
# strip of the header of the input file
#
ed $data_filename EOF
1,5d
w
q
EOF
#
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
Doc ID:
Note:34782.1
Subject:
ORA-600 [17114]
KGH Bad magic
number in
header
Type:
REFERENCE
Status:
PUBLISHED
Content Type:
TEXT/PLAIN
Creation Date:
29-FEB-1996
Last Revision Date:
29-OCT-2002
Note: For additional ORA-600 related information please read
[NOTE:146580.1]
Ramon E. Estevez scribbled on the wall in glitter crayon:
Tks Joe and Per
But the same results
Red Hat Linux Advanced Server release 2.1AS/i686 (Pensacola)
login: oracle
Password:
DELL-installed Red Hat Linux Mon Aug 25 09:59:40 CDT 2003
Profile ejecutado
[EMAIL PROTECTED] oracle]$
Hi!
cd'ing to a directory doesn't help in unix unless directory . in PATH is
before /usr/bin or whereever the redhat linux rman is located.
Type which rman in your prompt and you'll see which rman is being used.
You have to run $ORACLE_HOME/bin/rman if you want to get right rman. Or
modify your
Type which rman. If the answer is /usr/X11R6/bin/rman then you're not
dealing
with oracle utility, but the lovely thing described below. There is also a
utility called spam, which serves to prepare spam, spam, egg, bacon and
spam.
PolyglotMan(1)
Title: Message
Sure
there is, remove the inner commit and commit them both together. The fact
that you want to roll back the inner one dependant on the state of completion of
the outer one indicates that what you have is really one transaction that has
been mistakenly divided into two.
if you need to 'rollback' everything, then you should make it one transaction. You can
add savepoints and rollback to: if you want to limit it that way.
commit means complete. You should not commit unless you are sure you may not want to
rollback.
why are you committing in the inner
Deprecated? Already? That sure didn't last long.
As far as what data types, I think it is whatever you can grab with a select
statement. If you have long datatype, you need to do a
set long 12345 (or whatever)
other stuff to set are
set arraysize 100 (or whatever)
set copycommit 1000 (or
Thanks Mogens,
It works great with no parallelism set.
But when parallelism is set to DEFAULT it fails
(intermittently). The tables are imported from a
Non-Rac production environment.
Found a note on Metalink last night which says DEFAULT
is calculated as : CPU_COUNT*PARALLEL_THREADS_PER_CPU
and
Tks Joe and Per
But the same results
Red Hat Linux Advanced Server release 2.1AS/i686 (Pensacola)
login: oracle
Password:
DELL-installed Red Hat Linux Mon Aug 25 09:59:40 CDT 2003
Profile ejecutado
[EMAIL PROTECTED] oracle]$ cd $ORACLE_HOME/bin
[EMAIL PROTECTED] bin]$ export ORACLE_SID=BDRP
Thanks Mladen,
But the same result
--- -- --- - --
1 BDRP LOBO
8.1.7.4.0 01-SEP-03 OPENNO 1 STARTED
ALLOWEDNO ACTIVEPRIMARY_INSTANCE
1 row selected.
SVRMGR exit
Server Manager
Hi Stephen,
The COPY command is a SQL*Plus command and allows SQL*Plus to act as a
pipe for want of a better description between two databases to copy
data. It is deprecated as far as I know? and i don't think it handles
some of the newer data types.
I think the OP meant from within SQL rather
Title: Message
Aw, man, now that stupid Annie
song is gonna be running through my head for the rest
of the day.
Thanks a lot, Brian.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Brian McGraw
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003
9:20
Title: RE: Configuring RMAN
Try it without the equal sign:
$ rman catalog rman/[EMAIL PROTECTED]
RMAN create catalog;
-Scott Stefick
-Original Message-
From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 16, 2003 10:50 AM
To: Multiple recipients of list
The OS is Solaris 5.8. The file systems is Veritas.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, September 16, 2003 8:25 AM
To: Multiple recipients of list ORACLE-L
Hi, what is your OS and filesystem?
Regards
zhu chao
Can someone tell me the restriction on the # of columns in the select
clause of the statement.. We are running into sort key too long -
ORA-01467. I am told there is no order by or group by in the query. I need
to look @ the query to make sure there are no references in the statement
that
Preordered: Qty 1
:)
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
Sent: Tuesday, September 16, 2003 11:05 AM
To: Multiple recipients of list ORACLE-L
Raj,
The book will
Title: Message
http://tinyurl.com/njtq
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
the big question is when will the .pdf be available for download on kazaa?
(Im kidding and Im buying a copy).
From: Jesse, Rich [EMAIL PROTECTED]
Date: 2003/09/16 Tue PM 01:44:35 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Is Cary's new book shipping now?
Title: RE: restriction on the number of columns in select statement.
it means total length of column sizes in group/order by cannot exceed your block size.
See http://tinyurl.com/nk93
Raj
Rajendra dot
All -
I am implementing RMAN on my unix boxes. The dbs are already in
archivelog mode for about a year. The system admin was backing up the
files from cold backups. Today we realize the backups are no good. The
tape is unreadable. Most of the archived logs (.arc) files have been
removed from
I believe that a number of threads have already discussed how to equate the
total runtime of a given session to its individual stats as shown in
v$sesstat, but I could not find on my collection of threads relating to this
subject.
The stats below shows that the individual session stat is more
Thanks guys for your inputs,
I just want include a procedure (which include commit)
into my package testing.
Have nice a day,
Kader
--- [EMAIL PROTECTED] wrote:
if you need to 'rollback' everything, then you
should make it one transaction. You can add
savepoints and rollback to: if you
The stupid song fixer: http://load.pquinn.com/binaries/fries/
It's @#%!$*( Flash, but there's a link to an MP3 remix at the bottom of the
page.
Enjoy! Christmas is coming!
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech
Will there be an MP3 version, with Cary singing?
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE:
go to the bookstore and pick up rman book by robert freeman, thats a
good start.
joe
PS: i just went thru this weekend with some co-horts, restoring
database with loss of all controlfiles and rman repository, excellent
learning experience(glad i did it on my laptop about 6 months ago).
Woop! Dumb question. Never mind.
Original Message
Date: Tue, 16 Sep 2003 12:02:54 -0500
To: ORACLE-L ORACLE-L [EMAIL PROTECTED]
All -
I am implementing RMAN on my unix boxes. The dbs are already in
archivelog mode for about a year. The system admin was backing up the
Okay, core questions:
-as someone asked, what's the make/model of storage?
-has your raid array lost its config? In other words, is the storage there,
just with an empty vtoc/volume table/partition table (insert your particular
OS nomenclature)
-Is the filesystem good, just empty? When you say
your path could still be pointing elsewhere first and not the current
directory.
$ORACLE_HOME/bin/rman
joe
Ramon E. Estevez wrote:
Tks Joe and Per
But the same results
Red Hat Linux Advanced Server release 2.1AS/i686 (Pensacola)
login: oracle
Password:
DELL-installed Red Hat Linux Mon Aug
1 - 100 of 154 matches
Mail list logo