list, we are looking for a fast tape drive to backup all the volume groups
on our IBM H70..
around 100GB+, our current backup takes around 5-6 hours !!!
any ideas about a faster tape drive ? or an optical one ?
regards
-Rahul
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
With Online Redo Logfiles placed on Memory Based File system i.e. tmpfs on Solaris 8
with Oracle 8.1.7.2) can Heavy / Data Intensive SQL Loads (DIRECT=TRUE , PARALLEL)
Cause Other
regular File systems to Crash ?
SQL Loading happening for 5 Tables Concurrently
Also Within Each Table 16
Hi,
Pardon me for such a naive question, coz I am a novice when it comes to Oracle.
This is basically got to do with how Oracle parses a query.
Consider the following queries:
a)
SELECT column1, column2 FROM table WHERE column0 = 5;
b)
SELECT COLUMN1, COLUMN2 FROM TABLE WHERE COLUMN0
Scott Wrote :-
This software configuration is only supported on EMC 8XXX series towers
(firmware 5567.35.20 or higher) and the Hitachi HDS 9910 and
9960 series( firmware 01-16-40-00/00 or higher). It
also recommended you use JNI controllers. Your disk
drives will also have to support SCSI-3
it works
hukangang
What if we need Extent SIZES Greater than 20 MB to Check Fragmentation ?
-Original Message-
Sent: Thursday, September 26, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L
We tend to use multiples of 1Gb and add 1 Mb to the file so that we get
2001, 10001 Mb etc
Solaris 2.8
LMT
Hi ALL
Is there any way with RMAN to overwrite the backup files if they already
exist.
Example generating backup files with the same names each time.
Thans
Kamel B.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: GL2Z/ INF DBA BENLATRECHE
INET: [EMAIL
Same here ;P
-Original Message-
Sent: 27 September 2002 21:53
To: Multiple recipients of list ORACLE-L
H...even after flushing the cache, MS is still the top link for me on
Google (except for the news stories).
Rich
-Original Message-
From: Thomas Day [mailto:[EMAIL
DENNIS, I think that I did not explain my idea.
I do not understand the complain of Thomas.
I do not see any harm in a company choosing its dealers based
on their commitment to the goals of my company.
Microsoft has a right to prefer dealer who embrace the .net,
or do you think that anybody
with evenly sized extents, there is no such thing as fragmentation
anymore
and Oracle can deal with objects with numbers of extents up to about
4000 before it starts to slow down a bit.
--- VIVEK_SHARMA [EMAIL PROTECTED] wrote:
What if we need Extent SIZES Greater than 20 MB to Check
Hello
all,
I have
a query -
i have 2 tables
- client and project
fields in project
table - clientid/projectid
fields in client
table - clientid/name
i want to get the
maximum orders one client has got. i mean a project having the
greatest clients
how to write it in
single query ??
HELP
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Hi
I got a question from a co-worker about opening an 8.0.5 database using
8.1.7
Since I don't have 8.1.7 here to test it, does anybody know wether this is
possible or not ?
I guess not, maybe it can exclusively mounted/opened followed by some script
to upgrade it to 8.1.7 ?
Regards,
Stefan
Under NT when doing the upgrade from 8.0.5 to 8i the database will be
mounted once the 8i services are created (assuming -startmode auto has been
supplied). There are various data dictionary objects that need upgrading via
the upgrade script (u0800050.sql) so it's a good idea to restrict access
ARE YOU AN IDIOT?
-Original Message-
Sent: Monday, September 30, 2002 6:33 AM
To: Multiple recipients of list ORACLE-L
Subject:
HELP
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Title: RE: Help can't restore archive logs from networker through RMAN
Guys, hanging on restoring archive logs only and need for urgent recovery. Oracle suggest doing a trace on allocate channel but can't find syntax for 8.0.6 just 8i which doesn't work.
Help!
Title: RE: datafile sizing question
Rachel,
Are there any studies or papers that test and explain this new magic 4000 extents number? My manager is excited about LMT, but no so excited about number of extents. So, if there is a good paper, I can make him feel happy about this ...
Thanks in
As long as you stick to either (a) or (b) you will be okay ... if you
mix-n-match that will make Oracle do more work.
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
personal
Paula,
Your experience sounds very similar to mine which I documented on
http://www.hcresources.co.uk/ocp.htm http://www.hcresources.co.uk/ocp.htm
. I used the Exam Cram series and was very happy with them.
I am booked for the 8i upgrade next week but despite using 8i for however
long it has been
Title: RE: Determine process of index build - HOW
v$session_longops select with last_update_time desc and use the sid ... it is pretty cool .. it will also tell you for current operation how many seconds are remaining.
Raj
__
Rajendra
Title: RE: Determine process of index build - HOW
This is a query I build to see this, midnight Saturday
Comment welcome
column % Done format 999.99
column opname format a15
column sql_text format a70
column T Left format 9
select
a.sid,
(a.sofar/a.totalwork)*100 % Done,
try it:
select
name
from
(select c.name, count(p.id) p_count from clients c, projects p
where c.id = p.cl_id
group by c.name) a,
(select max(count(id)) p_max from projects
group by cl_id) b
where a.p_count = b.p_max
Regards,
Leszek
At 03:23 2002-09-30 -0800, you wrote:
Hello
No, there will not be any noticable difference in performance.
-Mark
On Mon, 2002-09-30 at 03:58, Shantanu Datta wrote:
Hi,
Pardon me for such a naive question, coz I am a novice when it comes to
Oracle. This is basically got to do with how Oracle parses a query.
Consider the
Oracle
sees (a) and (b) as two different queries and parses them both. For them to be
identical the text must match, including the white spaces.
I
suggest a small test under *identical conditions* to see if execution time
varies ;)
-
Kirti
-Original Message-From: Shantanu
Title: RE: datafile sizing question
Do your own testing. Don't rely on
papers. Prove it yourself. It's easy.
There are two types of "performance" implied in
this discussion about extent allocation and deallocation:
performance of SQL statements like SELECT, INSERT,
UPDATE, DELETE (i.e.
Fragmentation or tablespace fragmentation does not simply mean more
than one extent, as it appears you are assuming. Also, it is an obsolete
concept where LMTs are involved, in all but a few difficult-to-imagine
situations.
Please read one or more of the following: Craig Shallahamer's All
Raj,
Do you
have any test cases or white papers to support your statement? Especially
the part about
"if you mix-n-match that will make Oracle do more
work."
never heard of this before and I am interested if it is
true.
Tom Mercadante Oracle Certified Professional
-Original
No, you can't do that. I just run a OS job everyday which removes the old
backups to make room.
HTH,
Ruthg
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 30, 2002 5:28 AM
Hi ALL
Is there any way with RMAN to overwrite the
Raj
Print http://otn.oracle.com/deploy/availability/pdf/defrag.pdf
http://otn.oracle.com/deploy/availability/pdf/defrag.pdf - very
well-written, direct from Oracle's site, so he will accept it as official.
BTW - In this paper, for Oracle 8 and above, the correct extent sizes are
120-k, 4-m,
Yechiel - Sorry, I was reacting to your analogy of the paper company. I
agree that dealers are an entirely different matter.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, September 30, 2002 5:33 AM
To: Multiple recipients of list ORACLE-L
I haven't seen any papers.. I was told this (4096 is the exact number)
in an Internals class.
However, there are lots of papers out there saying multiple extents are
not a problem, and you should be able to find them on the web.
--- Jamadagni, Rajendra [EMAIL PROTECTED] wrote:
Rachel,
Are
Microslop is not a private company, and has not
been for quite some years now.
Jared
On Monday 30 September 2002 03:33, Yechiel Adar wrote:
DENNIS, I think that I did not explain my idea.
I do not understand the complain of Thomas.
I do not see any harm in a company choosing its dealers
On Mon, Sep 30, 2002 at 04:23:22AM -0800, Farnsworth, Dave wrote:
ARE YOU AN IDIOT?
I think so.
-
ListGuru GENERAL Command HELP
-
This help file contains basic
Title: RE: Determine process of index build - HOW
And if
you have OEM/DBA Studio, you can watch the progress graphically.. :)
-
Kirti
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Monday, September 30, 2002
7:38 AMTo: Multiple recipients of list
List,
I have a package that creates files on the server. The directory
location and file name are obtained from tables in oracle. The procedure
works as designed on Novell 7.3.4 and no changes were needed when the
database way loaded on Linux Oracle 8.1.7. I am trying to move the
database from
Title: RE: data file sizing question
Thanks Tim,
I'll try to do this exercise today/tomorrow ...
The reason I mentioned papers is Managers are easily impressed by thing that are done by outsiders (they are considered experts, in-house knowledge is never sufficient). You probably know
With as much interest as i'd seen, i'd thought it would have been above
$102.50, oh well unless you all run up the price in the last few days, guess
i'll just be holding onto it for a while.
joe
Title: extremely long parse time
Nope, Oracle 8.1.7.2 on HP-UX 11. 148
seconds
on the wall clock to parse:
select
null as table_cat, owner as
table_schem, table_name,
0 as NON_UNIQUE, null as
index_qualifier, null as index_name,
0 as type, 0 as ordinal_position,
null as column_name,
Title: RE: Does the case of an Oracle query statement affect query perfo
Tom,
Well it simply comes to when Oracle will parse the query and try to find a matching sql to hash to in SGA, if it finds one, it will hash to the same one, else it will have to create a new hash entry.
In pre-8i
Thank, Jared,
Service.sap.com has a limited number of notes on Oracle partitioning (even
though they went to great lengths to negotiate that option into their
customer's Oracle licenses). And none that I've found that combine the
topics of data archive partitioning. If I do find something,
It wouldn't Cause Other regulat File systems to Crash.
However, if the Server crashes, you wouldn't be able to restart your
database !
Database Instance recovery requires the online redo logs which wouldn't be
available
when your server restarts.
Hemant
At 11:53 PM 29-09-02 -0800, you wrote:
Title: RE: datafile sizing question
Thanks you Dennis, Rachel, Tim for the pointers.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
I believe Raj is referring to the fact that Oracle will reuse SQL
from the SQL Cache if the statement has been parsed already, but they
must match verbatim.
for example:
a)SELECT column1, column2 FROM table WHERE column0 = 5;
b)SELECT COLUMN1, COLUMN2 FROM TABLE WHERE COLUMN0 =5;
will
What are you hoping to get for it?
-Joe
--- JOE TESTA [EMAIL PROTECTED] wrote:
With as much interest as i'd seen, i'd thought it would have been
above $102.50, oh well unless you all run up the price in the last
few days, guess i'll just be holding onto it for a while.
joe
All that he is referring to is the possibility that
"mixing-n-matching" will cause the same SQL statement to be hashed differently,
thus stored individually in the Shared SQL Area cache, thus more "hard parses"
unnecessarily. More "hard-parses" is indeed "more work"...
Though technically
Hi list,
oracle 8.1.7.2
os AIX 4.3.3
Occasionally we had hang situation on our Financial production database.
The batch job supposed to finish within 2 hours at 3:30 am. But
sometimes it just hang there and never finished the process. We have to
kill the job in oracle session and os level.
I don't have papers to substantiate this, but in our 9012 database
before we
started using cursor_sharing we used to run out of our 600M SGA, but
since
we started using CS, it went down.
That should have nothing to do with the case of a statement and
everything to do with using literals.
Title: RE: datafile sizing question
If Next Extent Sizing is NON-Uniform for an LMT , will
the Larger Number of Extents cause Fragmentation Performance Degradation ?
If so What Number of Extents may be Considered as a
Candidate for DE-Fragmentation ?
NOTE - We have been Manually
Hi dba's,
I have the following questions about partitioning.
Whe have a 20 million row's table (about 2G) and we are
thinking if it's worth tho partition it.
The table doesn't contain historical data , the data are inserted or deleted
(very few updates) (about 20 insert/deletes per day) and
Dr. Evil voice
One million dollars... BWAHAHAHAHAHAHAHAHAHAHAHAHAHA
-Original Message-
Sent: Monday, September 30, 2002 10:33 AM
To: Multiple recipients of list ORACLE-L
What are you hoping to get for it?
-Joe
--- JOE TESTA [EMAIL PROTECTED] wrote:
With as much interest as i'd
-Mensaje original-De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]En nombre de Tim GormanEnviado el:
lunes, 30 de septiembre de 2002 17:04Para: Multiple recipients of
list ORACLE-LAsunto: Re: Does the case of an Oracle query statement
affect query perfo
All that he is
Title: RE: Does the case of an Oracle query statement affect query perform
Thanks Tim, I didn't knew these differences between PROC/PLSQL and other modules ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Title: RE: Remember me? Oracle DBA veteran considering getting certifi
Ah - brethren - nice and complete adventure documented - thanks.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 8:38 AM
To: Multiple recipients of list
Rachel,
This is what I thought, but list members say differently.
I just tried a simple test:
Ran the following two queries:
select count(*) from tomsqltest;
SELECT COUNT(*) FROM TOMSQLTEST;
and then:
select hash_value,executions,sql_text from v$sql
where upper(sql_text) like '%TOMSQLTEST%'
H, also running on 8.1.7.2 on HPUX 11, this comes back to me sub-second.
My explain plan pukes in TOAD, but that's a TOAD issue...everything looks
good in SQL*Plus.
1) Are you using CBO?
2) If yes from 1, verify that there are no stats gathered in SYS.
3) Try init.ora
Hello,
Does anybody out there run Oracle 8.1.7 and Oracle 9.2 on the same NT (or
Windows 2000) box? Is it running smoothly. Any difficulties installing or
running both versions on the same box?
I ask because one of my colleagues has encountered difficulties installing
and running Oracle 8.1.7
At 06:58 AM 9/30/02 -0800, you wrote:
With as much interest as i'd seen, i'd thought it would have been above $102.50, oh well unless you all run up the price in the last few days, guess i'll just be holding onto it for a while.
joe
Well, just for fun I bid on it (so at least it's not
Title: RE: datafile sizing question
I don't know if you intended to "shout", but using
color for your reply certainly does
so...
Can you prove any benefit from the
extraordinaryactions of overriding LMT extent control and using EXP/IMP,
ALTER TABLE ... MOVE, ALTER INDEX ...
This is interesting.
I have installed and run multiple Oracle versions on the same Unix box
but not NT.
Sam Bootsma wrote:
Hello,
Does anybody out there run Oracle 8.1.7 and Oracle 9.2 on the same NT (or
Windows 2000) box? Is it running smoothly. Any difficulties installing or
running both
Hi All,
I needed some help here involving shareplex.
We run two databases (an OLTP type, and a repository type) on the same E10K
domain
which has 8 CPUs and 8GB of RAM, using Hatachi SAN (RAID 5). Shareplex is
being used
to replicate a table from the OLTP type to the repository. The current
I never said both wouldn't be listed separately... in fact I said they
WOULD.
I said cursor_sharing would NOT change case, but would only affect the
statement if you used a literal in it.
--- Mercadante, Thomas F [EMAIL PROTECTED] wrote:
Rachel,
This is what I thought, but list members say
Wow! What a Freudian slip.
I had intended to type 'Microsoft', though I
was *thinking* Microslop.
Jared
Jared Still [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/30/2002 07:03 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Oh, and I forgot to add that the table that's being replicated is
partitioned in the repository database.
with local indexes. Each partition holds a day worth of volume.
-Original Message-
From: Ji, Richard
Sent: Monday, September 30, 2002 12:08 PM
To: Multiple
Hey Kent,
I just saw your e-mail address and was curious...what does MPS use Oracle
for? Big DBs? Little ones?
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent:
You may find this article interesting:
http://otn.oracle.com/oramag/oracle/02-sep/o52sql.html
Jared
Gary Chambers [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/27/2002 11:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Title: RE: extremely long parse time
We are using First_rows for the optimizer mode,
but the last_analyzed column in DBA_TABLES and
DBA_INDEXES is NULL for all objects owned by SYS.
The really wierd part is: Changing the query
to use rule based optimization (via the /*+ RULE */ hint
Well, if oracle stores all the meta data in UPPERCASE, then for a query in
which object names are written in lowercase characters will force the parser
to convert it into UPPERCASE for comparison, in which case there should be a
negligible difference if the name of the objects referenced by the
Joan,
You may be able to diagnose this when it happens again by logging
in as SYS using svrmgrl.
Run the following SQL statement if the logon was successful:
select
s.username username,
e.event event,
s.sid,
e.p1text,
e.p1,
e.p2text,
e.p2,
e.wait_time,
Yes, I am. I needed an 8i client because some programs still can't talk 9i.
The only issues I've run into are with the products themselves. Some Quest
products have problems with multiple Oracle Homes. Their solution is to
hack the Registry to make the LAST_ORACLE_HOME the one to point the
Anyone tried this one?
http://soldc.sun.com/articles/oci_cache.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
Hey Ron,
If I'm not mistaken, access to the UTL_FILE directories needs to be given to
the account that started the Oracle instance and not an Oracle schema name.
Also, make sure that your entries for the filenames and directories in the
UTL_FILE packages are UPPER CASE, or at least match the
Hmmm...anything SYS in DBA_TAB_COL_STATISTICS or DBA_ANALYZE_OBJECTS?
Is the COST column in your PLAN_TABLE null???
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Monday,
I am currently running 8.1.5, 8.1.7, 9.0.1.2 and 9.2 on the same Win2k Pro
machine. I rarely have more than 2 running at the same time due to memory
considerations, but I have not encountered any problems related to
install/runtime. I always make sure I install in order of oldest to newest.
I
I got a call from a customer earlier. He said that he was trying to
run a query and it was taking way too long. He ran the same query last
Friday and it came back in seconds. I looked at it in OEM and noticed
that two of the tables were being accessed by full table scans. These
tables
Title: RE: extremely long parse time
OK, I think we're on to something here.
The DBA_TAB_COL_STATISTICS shows no rows for tables
owned by sys (although strangely, owner is not a column
of this table). However, the DBA_ANALYZE_OBJECTS view IS
listing objects owned by SYS, which implies that
Joe,
What are you trying to do with rman?
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 26, 2002 2:17 PM
so i took the first 2 stories and put them on
http://www.oracle-dba.com/bdbafh
nothing pretty, maybe i'll mess
Yes, obviously this wasn't meant to go to the list... blush
Rich
-Original Message-
From: Jesse, Rich
Sent: Monday, September 30, 2002 12:28 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT: oracle-dba.com domain auction
Hey Kent,
--
Please see the official
The phone rings. Another user. Still pissed off, I pick it up...
Database Administration, can I help you? I answer professionally.
Troubled silence on the phone. Politeness is a very bad signal from me and they know
it. He was rattled.
Uh, hi, this is Joe, technical lead on that
I have seen something like this in the past and it was because there were
two tables - named the same in two different schemas (public synonym,
private synonym and all that mess)..
Do you know whether this could be the same case as yours?
Also check to see if the explain plan differs when u run
I have seen something like this in the past and it was because there were
two tables - named the same in two different schemas (public synonym,
private synonym and all that mess)..
Do you know whether this could be the same case as yours?
Also check to see if the explain plan differs when u run
I have seen something like this in the past and it was because there were
two tables - named the same in two different schemas (public synonym,
private synonym and all that mess)..
Do you know whether this could be the same case as yours?
Also check to see if the explain plan differs when u run
LMAO
-Original Message-
Sent: Monday, September 30, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L
The phone rings. Another user. Still pissed off, I pick it up...
Database Administration, can I help you? I answer professionally.
Troubled silence on the phone. Politeness
Title: disable validate on a partitioned table?
I read the following in the Oracle 8.1 manual:
Oracle8i SQL Reference, Release 3 (8.1.7), Part Number A85397-01
SQL Statements:
CREATE SYNONYM to DROP ROLLBACK SEGMENT, 3 of 31
DISABLE VALIDATE disables the constraint and drops the index
List
I have the opportunity to learn first-hand
about TSPITR today. I need to recover a good bit of data that was recently
deleted, and do not have a recent enough export to work from.
My question is this Im reading the documentation
now, and one of the big, bold Notes is that you
I will up the price to $150.00
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Monday, September 30, 2002
10:58 AMTo: Multiple recipients of list ORACLE-LSubject:
OT: oracle-dba.com domain auction
With as much interest as i'd seen, i'd thought it would
Hi
Does some one set up data guard in oracle 8.1.7?
can some on send stuff how to administor data guard?
If Data guard has set up in between server1 and server2 then how to stop and
restart instance and data guard?
Thx
-Seema
_
Hey all,
We've just changed our charactersets on our 8.1.7.2 (and 8.1.7.4) DBs from
US7ASCII to WE8ISO8859P1 using the Oracle-approved ALTER DATABASE CHARACTER
SET WE8ISO8859P1 and accompanying commands. Everything works like a champ,
but our Perl::DBI connections now all cause an invisibile
I don't know how he can live with himself
LMAO
-Original Message-
Sent: Monday, September 30, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L
The phone rings. Another user. Still pissed off, I pick it up...
Database Administration, can I help you? I answer
OK, this is still bombing. nslookup gts214.us.oracle.com fails here as
well as thru Telocity (DirecTV). Feedback from MetaLink says to flush my
cache sigh.
Anyone else having problems getting images from Metalink?
-
Or do I need to talk with our networking group about the firewall?
Title: RE: STILL HAPPENING: Metalink problems loading images?
On what kind of page do you see the error?
I can't get to gts214... either but when I go to the Metalink start page I don't see any images missing.
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
OK,
Title: disable validate on a partitioned table?
As you
know for a partitioned table: unique constraints could be enforced by a local
index or global index.
For
local index: the unique key will be part of the partitioning
key.
So for
a partitioned
Title: RE: disable validate on a partitioned table?
-Original Message-
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
As you know for a partitioned table: unique constraints
could be enforced by a local index or global index.
For local index: the unique key will be part of the
Ruth, just some experiments, going to implement it for ERP at
longaberger, so i need to do proof of concept.
not stuck(yet) just experimenting.
joe
Ruth Gramolini wrote:
Joe,
What are you trying to do with rman?
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L
Brian - Since nobody seems to have responded to your question, yes, there
are plenty of opportunities for gotchas with TSPITR. To recover deleted
data, you may want to take a look at LogMiner. Less risk. Normally, to
recover deleted data, you will be performing the TSPITR on a test (or
recovery)
Hi guru ,
I need your advise , currently our customer have a production and
development system , if there is a problem log being raise , then we need to
port the data from development to production but not the whole database
sometime is only certain record.
Is there any method to use
Rich,
Do you have export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 in the client
environment where perl is running?
-Mark
On Mon, 2002-09-30 at 17:48, Jesse, Rich wrote:
Hey all,
We've just changed our charactersets on our 8.1.7.2 (and 8.1.7.4) DBs from
US7ASCII to WE8ISO8859P1 using the
Title: RE: extremely long parse time
Matt,
optimizer_mode = FIRST_ROWS means CBO, and for SYS schema without statistics.
Oracle 8.1.7.2 on HP-UX 11.
optimizer_mode = CHOOSE
I run your original SELECT, then with the hint FIRST_ROWS.
From trace file:
PARSING IN CURSOR #1 len=888 dep=0
1. You can use SQL*Plus COPY command to copy data from Production into
development database.
2. You can create a link from Development database to Production database,
and then use insert into Development database table by selecting data from
table@Production database.
3. You can use export with
Title: RE: disable validate on a partitioned table?
This
is probably b/c the unique key does not include the partitioning
key.
Waleed
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]]Sent: Monday, September 30, 2002
8:33 PMTo: Multiple recipients of list
cannot perform an aggregate function on an expression containing an
aggregate or subquery
is the error i am getting while i am executing the query.
SELECT name
FROM (SELECT c.name, COUNT(p.clientid) p_count
FROM client c, project p
WHERE c.clientid = p.clientid
GROUP BY
100 matches
Mail list logo
