That is correct. TX recovery was done in the background and foreground (if a
user would hit a transaction that needed to be rollback, but wasn't yet by
the background).
Anjo.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, February 08, 2
Title: RE: Version Controlling in Oracle database - Ideas ?
Is it available in the Market OR is there a special
procurement Channel for it ?
Any Details please , Links , Docs ?
Thanks
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Friday, February
So far only had to use RBO, now we are moving towards using CBO. However none of the documents really talk in detail about Histograms, the goods, bads where and where not to use.
I have read that HISTOGRAMS are good for columns that are non unique and that have many duplicate values. While DSS s
ODBC is just another layer on top of Oracle client - eventually it
will call OCI functions. So does OO4O, I believe. So I don't see why
not. Let me know if you have problems.
Friday, February 7, 2003, 11:24:35 AM, you wrote:
IN> Sergey,
IN> Does your utility monitor connections through ODBC inte
For now it's NT platform only (NT/2000/XP)
Friday, February 7, 2003, 9:34:04 AM, you wrote:
B> how can I do it for unix processes ? ...
B> Bp
--
Best regards,
Sergeymailto:[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
Hi Tc,
Just a curious that your OS can't allocate share memory that you set at
large pool, try to decrease your large pool. I ever get this error and that
way is working.
Rgrds,
Sony
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, February 08, 2
Hi Mark,
I'm curious with your procedure or script that using 'open (cursor);'
clauses.
please check whether you forgot to close the opening cursor. just a curious.
Rgrds,
Sony
> -Original Message-
> From: Mark Richard [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, February 07, 2003 6:14 AM
>
Hi Surendra,
We were desperate to streamline our Forms 6i Client/Server installs. With
hundreds of PC users, we couldn't visit each PC every time we needed to
install a new Form/Report or update the Forms/Reports runtime version.
One thing we've done to eliminate release and install hassles is c
You do seem to have tested out different Shutdown or SHUTDOWN ABORT
scenarios !
The TRUNCATE table issue does seem to be serious. However, the
INSERT should have been rolled-back
at the next STARTUP --- unless you had a problem because you issued the
TRUNCATE before the ROLLBACK
was completed ?
Hi Lindon,
You can try this link,
http://www.logicworks.com/
> -Original Message-
> From: Lyndon Tiu [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, February 07, 2003 12:34 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Freeware reverse engineer ER diagram from ODBC connection
>
Hi List,
whats the meaning of the following error
ERROR at line 1:
ORA-04031: unable to allocate 4096 bytes of shared memory ("large
pool","unknown object","sort subheap","sort key")
heres the sql query --->select * from hox12 order by op desc;
Oracle Release -->8.1.6.1.0
OS --> RH 7.1
sort_area_s
John,
In 7.3.4, wasn't background TX recovery already a feature? In other
words, weren't large rollbacks delayed until after the database was
already open and available?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Fri, 7 Feb 2003, John Kanagaraj wrote:
> Just to add another aspect:
It may be found at www.cybcon.com/~jkstill
It may also be found at:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1050919.6
Yes, it's back, still without credit.
Please, no 'piracy' emails to Oracle about it.
Jared
John Dunn <[EMAIL PROTECTED]
Just to add another aspect: I had a problem once with a 7.3.4 database when
we performed a shutdown abort. Now this database was in the middle of a
complete refresh of a rather large Table from another database. The shutdown
abort occurred properly, but the db took its sweet time to come up while i
Hello All,
We have been exploring different options to distribute the Oracle
client to users to deploy an application. Earlier, we used to use
Install Anywhere or do it manually. I am thinking there should be
a better way folks out there must be using. Our present requirement
is to have a mini
No shark flash-copy usage here
I think your going to need a bigger boat!
Cheers!
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/7/2003 3:23 PM
Resending, just wondering if there any Shark FlashCopy users out there.
So far, it doesn't look good.
Gene
>
Hi Robert,
For problem 1, you mean transaction recovery, i.e. rollback, right?
Did this problem happen only with fast start parallel rollback or also
with normal version 7-on background TX rollback? How about user
rollbacks (user 1 rolls back large transaction, user 2 truncates the
table in the m
Ray - Perhaps you misunderstood. You won't find anything in the
documentation saying "our developers didn't have time to test every
installation permutation against alternate userids". I used to be a
developer at a software vendor. I know how the developers think. You don't
like to test. You take t
Here's what I've used:
create session
select_catalog_role
alter database
alter tablespace
alter system
[EMAIL PROTECTED] wrote:
>
> Hi All,
>
> If I create a backup user, what is the minimum requirements to connect as
> that user and do hot backups?
>
> Thanks
> Rick
>
> --
> Please see the
I heard an Oracle product manager (whose product also got rolled into iAS
- or I Am Sorry, as it's known here) mention that Larry had been quoted as
saying "Well, everybody has a database now" - meaning: Now Oracle has to
sell iAS, Apps, anything other than the database, so that kind of support
Resending, just wondering if there any Shark FlashCopy users out
there. So far, it doesn't look good.
Gene>>> [EMAIL PROTECTED] 02/06/03 05:03PM
>>>
Excellent thread on VLDB and backups. I know EMC BCVs/Timefinder
works for quick disk backups from experience. However, EMC is not an
option
Saira,
Excellent feedback. I'll forward it to Jacob Christfort and Martin Graf.
Martin, by the way, sent me a response to your posting (Jacob forwarded my
message to Martin). See below.
Best regards,
Mogens
Mogens,
In deed, Oracle9i Lite has over 10'000 posted
messages on OTN,
Solution would be different users but all having the same group. I
always use a "oinstall" group for all oracle users in a system. I have
Oracle 8 and 9 on the same Sun.
Quoting Stephen Evans <[EMAIL PROTECTED]>:
> maybe multi-user oracle homes would be a problem for stuff that's
> in
> oracle b
Guang Mei wrote:
>
> Hi:
>
> I have a basic sql question about sql. I have the follwing four sqls and I
> am wondering why #3 "costs" less than #4 in explain plan. #1 and #2 cost
> the same. How is "distinct"and "group by" treated internally by Oracle? Is
> #3 a better "optimized" sql than #4?
>
That is why each oracle home has its own oraInventory directory.
I have 10 different instances across 2 machines. Each instance has its own user id
and group.
There have been no problems at all with this setup for 8.1.7.4 and 9.2.0
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a
Hi:
I have a basic sql question about sql. I have the follwing four sqls and I
am wondering why #3 "costs" less than #4 in explain plan. #1 and #2 cost
the same. How is "distinct"and "group by" treated internally by Oracle? Is
#3 a better "optimized" sql than #4?
TIA.
Guang Mei
1.
maybe multi-user oracle homes would be a problem for stuff that's in oracle base such as the inventory.
during an install/upgrade this common data needs to be updated.
i suppose i would work ok if u were careful with permissions, but it would be just one more thing to go wrong.
thanks,
steve
Maybe, but Ray will decide what's best for him. I think we
have offered enough points for him to consider.
File permission is a big headache. In my case, I have two
totally separate environment since one is 32 bit, on is 64 bit.
Regards
Richard Ji
-Original Message-
Sent: Friday, Febr
But ROacle hasn't. 8.1.7 is the terminal release on Slowaris.
> -Original Message-
> From: Richard Ji [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 07, 2003 2:25 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RAC on linux?
>
>
> Sun in fact want to discontinue the Sol
On Fri, Feb 07, 2003 at 11:36:36AM -0800, Scott Stefick wrote:
> I tend to agree also, just because of confusion. We are running on one
> server, 817 (1 instance), 9201 (1 instance), 9iASRel 2 (1 instance) and on
> the second server we have 817 (2 instances), 9201 (1 instance), 9iAS Ver
> 102 (
Philippe
If you are using parallel clause in index creation/rebuilding you need more
space in target tablespace as well as temp tablespace.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 07 Feb 2003 08:09:25 -0800
You a
Gene - I asked the network engineer about this. No reported outages.
Extremely few errors in his log. We've recreated the problem during the day.
Thanks for the ideas, however.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, February
Title: RE: Using Soft Links for Datafiles
Raj-
We used the symbolic links on a regular basis in a previous life.. But we did not have the opportunity to use RMAN, so I am not able to address that right now.
But when we lost sym links; we actually had to "restore and recover". And that's why w
I tend to agree also, just because of confusion. We are running on one
server, 817 (1 instance), 9201 (1 instance), 9iASRel 2 (1 instance) and on
the second server we have 817 (2 instances), 9201 (1 instance), 9iAS Ver
102 (1 instance). So at first we tried different user names:
oracle8i (817
Title: RE: RAC on linux?
Sun
has always been shipping Solaris for Intel, I started with
2.5.
Then they want to kill it a year ago, but the user
community raised hell
with
them, so after a brief stop, they are shipping it again for Solaris
9.
Don't
know if Oracle is going support it again.
how about giving where clause for the export of that table with " where
1=2", This way u will not have any records in export file .
Bp
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, February 07, 2003 3:18 AM
> Craig,
> Assuming you don't
Richard - It was more like Jay mentioned. Just problems with file
permissions. It just always seem to be biting me at every turn. I finally
got everything over to the Oracle username. The other issue is that my guess
is that the Oracle developers test everything with the Oracle username. So
if you
Sergey,
Does your utility monitor connections through ODBC interface(not OCI or
OO4O)?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, February 07, 2003 11:09 AM
> Hello Banarasi,
>
> I'm Sergey
Sun in fact want to discontinue the Solaris for Intel platform a year ago
but receive a lot of critisim from the user community. So they
revived it.
-Original Message-
Sent: Friday, February 07, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L
I first installed Solaris 2.5 on Inte
Title: RE: RMAN without all files?
-:)
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Orr, Steve
To: Multiple recipients of list ORACLE-L
Sent: Friday, February 07, 2003 11:48
AM
Subject: RE: RMAN without all
files?
The below mess
Title: RE: Oracle package that can generate HTML content ???
package of procedure ... htp
package of functions htf
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here i
On Fri, Feb 07, 2003 at 07:54:24AM -0800, DENNIS WILLIAMS wrote:
> Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had
> a bad experience :-)
Would you mind expanding on that, other people say the multiple userid idea
works for them. They may be surprised one day, I can i
Title: RE: SETGID
what are the permissions on the oracle binary in $ORACLE_HOME/bin...
make sure it reads
-rwsr-s--x
-Original Message-
From: Ehresmann, David [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 07, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L
Subject: SE
I agree with Dennis. We tried this several years ago and decided it was best to stick
with one username. I forget what the exact issues were - it might have been file
privileges when you are upgrading a database.
Jay
>>> [EMAIL PROTECTED] 02/07/03 10:54AM >>>
Ray - My 2 cents worth. Don't ever
I first installed Solaris 2.5 on Intel (AMD actually) on a 386/40 with 8Mb
RAM. It ran fine. Sun pretty well shot its Intel market the same way IBM
blew its OS2 market: Overpriced the crap out of the OS and development
tools. By the time they woke up and noticed that the market had moved on to
got it
Thanks,
Dave
-Original Message-
Sent: Friday, February 07, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L
an
Dave
Just add one more line before to shutdown abort...
alter system checkpoint;
SHUTDOWN ABORT
STARTUP RESTRICT
SHUTDOWN IMMEDIATE
Regards
Rafiq
Reply-T
Hemant,
Could you check what happens if all the filesystems that were 'shadow
copied' were VxFS filesystems? I would assume that Veritas maintains the
same formats across *nix versions Btw, I haven't implemented
Heterogenous implementations on a SAN, but am just suggesting an
alternate... Let
Lindows??
-Original Message-
how can I do it for unix processes ? ...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mai
Quoting [EMAIL PROTECTED]:
> Jared,
>
> You had better bet it is! We're right in the middle of
> re-designing the
> back bone of our web site to use
> Linux/Apache/Tomcat/Java/PostgreSql. Instead
> of the usual MS Win 2K/IIS/ASP/Oracle. And seriously, Damn this is
> FUN!!
>
I am doing t
Try this link.
http://www.cybcon.com/~jkstill/util/
Dave
-Original Message-
Sent: Friday, February 07, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L
Where can I get then latest version of Jared's legendary script?
Or is there a better alternative script for dumping and reloa
Title: windows application to show sql being executed by a client program
how can I do it for unix processes ? ...
Bp
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Sent: Friday, February 07, 2003 5:09
AM
Subject: RE: wind
Title: RE: Version Controlling in Oracle database - Ideas ?
I believe this feature coming in new TOAD ... its available in Beta though ... I think it is called 'Team Coding ... something'
Another product is Oracle SCM ...
Raj
__
Rajendra Jam
I've tried your test case on 9.2.0.2 but
it didn't reproduce. Should there any data
in the tables ?
How did you determine that the time was
spent on the parse - and could you tell us
your CPU speed and the times involved.
Also, was there ultimately any difference in
the execution plan ?
Regar
Igor, Sony, Naveen,
Thanks all for your kind help.
Regards,
Waseem.
--
On Thu, 06 Feb 2003 17:43:40
Sony kristanto wrote:
>Hi Waseem,
>
>When you decide to use 'group by' in your query, I can just suggest you to
>not use 'order by' clause, my reason is, it will makes your query running
>slow
Title: RE: RAC on linux?
Anyone have ideas on this?
http://story.news.yahoo.com/news?tmpl=story&u=/cmp/20030206/tc_cmp/iwk20030206s0012
Sun is now going after the intel market too. Is this just a new version of their Solaris x86, or a completely new build?
-Original Message-
Fr
Vivek,
I am wondering why do you have load balancing turned on for BBY01, when you
have just one listener? Whats the MTS_DISPATCHER set to?
Raj
"VIVEK_
Title: RE: RMAN without all files?
The below message was filtered and moved to the spam folder because the letters 'xxx' were found. Maybe that's what happened to your datafiles. :-)
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 07, 2003 8
Dave
Just add one more line before to shutdown abort...
alter system checkpoint;
SHUTDOWN ABORT
STARTUP RESTRICT
SHUTDOWN IMMEDIATE
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 07 Feb 2003 07:28:43 -0800
I do my cold bac
Title: RE: RAC on linux?
Back when I was in discussions about becoming a beta site for Oracle Financials I visisted Oracle HQ at 20 Davis Drive in Belmont, CA. When asked why we should believe that Oracle was really committed to this new "Financials" product we were told that Oracle Corp. was
Dennis,
What bad experience did you had? I wouldn't recommend it but I had no
problem when I run both 32 bit and 64 bit 8.1.7.4 on the same box
using that approch.
Thanks
Richard
-Original Message-
Sent: Friday, February 07, 2003 10:54 AM
To: Multiple recipients of list ORACLE-L
Ray
Hi all,
I saw some Oracle packages that can generate HTML
content. The package looks like ftpk.c (I don't
remember the exact name). Does anyone know what those
packages are, and where to find documents?
Thanks,
Janet
__
Do you Yahoo!?
Yahoo! Mai
Resending. Any takers?
- Forwarded by Rajesh Rao/JPMCHASE on 02/07/03 11:51 AM -
Rajesh
List,
Has anybody else experienced this problem on UNIX. We have seen this issue
on two different servers, one running AIX 4.3.3 and the other running AIX
5.1L. Both have 8i 8.1.7 Ent Edition.
My sysadmin set the gid for the directory in which the Oracle datafiles
reside. Something to do with
> Having to choose between IOUG and HOTSOS, I opted for IOUG
> as I haven't been since 2000.
So we will get to meet at last!
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Kanagaraj
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 ht
Richard,
I agree, Oracle is getting way too expensive. Kinda like EMC, a platinum
plated truck bed liner where a nice rubber one would work just as well.
Dick Goulet
Reply Separator
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= <[EMAIL PROTECTED]>
Date:
guys,
instalation notes on 9ir2 say tht i have to have c 5.1 on this system.
do you know here i can get it?
or at least how i can install a rpm package in aix?
thanks in advance
Paulo
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paulo Gomes
INET: [EMAIL PROTECTED]
Jared,
You had better bet it is! We're right in the middle of re-designing the
back bone of our web site to use Linux/Apache/Tomcat/Java/PostgreSql. Instead
of the usual MS Win 2K/IIS/ASP/Oracle. And seriously, Damn this is FUN!!
Dick Goulet
PS: Teaching an old dog new tricks isn't imposs
Where can I get then latest version of Jared's legendary script?
Or is there a better alternative script for dumping and reloading table
data?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- 85
This is probably more realistic than many of us realize.
Linux and open source in general is seriously threatening MS.
PostGreSQL has been around for awhile, but mySql has much
more momentum than PGS ever had. I look for it to seriously
threaten Oracle in the future.
Maybe not at the high end,
Looking for a solution to version controlling of database objects in Oracle.
The scenario is like this:
Multiple people simultaneously work on the same database object in TOAD.
How can we implement a version controlling feature.
Putting this in simple words,
If X checks out a file from TOAD
Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had
a bad experience :-)
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, February 07, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L
On Thu, Feb 06, 2003 at 05
Another thought, move the table to a different (new) schema, create synonym
and privileges required, then export user=original schema(s), then do your
import.
Gene>>> [EMAIL PROTECTED] 02/07/03 09:28AM
>>>John,A quick check turned up a "medium" parfile for
me - only 1201 tableslisted. The
You are running out of space in the SCOPE_MD_IDX tablespace.
i.e. your index won't fit.
It appears that you are also using up all the TEMP space. Most
unusual, at least to me. I've never seen both the tablespace and
the temp tablespace run out of space at the same time.
Jared
On Friday 07
Hello Banarasi,
I'm Sergey Ten, the one that wrote the tool Jacques is referring to.
Thanks for the feedback. I'd also like to see some functionality like
that, but Quest Software already has SQLab that does it (means I'd
have to compete against my own employer). Besides, my tool does not
establi
We are conducting a disaster recovery test on RMAN. Files backed up to disk,
recovering from disk. We've done this with smaller databases, this is our
largest. RMAN reports that it can't find all the data files on disk (70 out
of 200). We seem to have all backup pieces. Any ideas? Thanks.
RMAN-060
Ed,
thanks for the reference! I'll check into it.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, February 07, 2003 9:39 AM
To: Multiple recipients of list ORACLE-L
Use the ADO Reordset Object PageSize Property to logically divide the
Recordset object in
Thanks for that. Parfile is what I was looking for. I must have skipped
it in the manuals.
Cheers
Craig
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: 07 February 2003 13:04
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Skipping a table on
Title: RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris and
I do
my cold backups at a time when the system is not being used. In the future
I want to learn RMAN for hot backups but for now I do the
following;
SHUTDOWN ABORT
STARTUP RESTRICT
SHUTDOWN IMMEDIATE
You
mention a
Ray - I have always used #2 and never had a problem. I do set
Oracle_Base & Oracle_Home to different values for each version.
e.g.
/oracle1/dbserver/7.3.4
/oracle1/dbserver/8.1.7
/oracle1/appserver/1.0.2
...
hth,
Gene
P.S. The root directory is different on all my servers to support HA, i.e.
Use the ADO Reordset Object PageSize Property to logically divide the
Recordset object into a series of pages,
Each of which has the number of records equal to PageSize (except for the
last page which might have fewer records).
http://members.evolt.org/help/caspdoc/html/ado_recordset_object_absolu
If it is only 1 or 2 tables, maybe create those tables small and make
maxextents = 1? Maybe put them in their own tablespace, then make it read
only? Or take it offline? H.
> -Original Message-
> Is there a
> way to skip
> certain tables during an import?
--
Please see the offici
John,
A quick check turned up a "medium" parfile for me - only 1201 tables
listed. The file size is 14KB, so I guess it's not an issue for 8i. Even
on larger parfiles I've never gotten an error - for neither HP-UX nor
Win2k.
Jack C. Applewhite
Database Administrator
Austin Independent School D
Rajesh , List
tnsping for tbasun Database (below) 10 ms
whereas tnsping for bby01 Database (below) is 10,000 ms
Qs. Is is due to the Multiple ADDRESS Entries with LOAD_BALANCE = yes for tbasun ?
NOTE - tnsnames.ora file put on the Database Server itself & tnsping also being issued
from the SAM
This is it
create or replace PROCEDURE
truncate_table(nom_de_table in varchar2)
AUTHID DEFINER
is
total INTEGER ;
trouve EXCEPTION ;
cursor_name INTEGER ;
ret INTEGER ;
trun VARCHAR2(30) := 'truncate table ' ||
nom_de_table ;
BEGIN
select
Here is a link to IBM site showing a matrix for AIX 4.x support. Fix the link if it
wraps around.
We had a meeting yesterday to begin upgrading Servers to AIX 5.1 first, for a short
duration, and then to 5.2.
http://www2.ibmlink.ibm.com/cgi-bin/master?xh=YUKoCSGfrgPYSK2USenGnN9332&request=sale
On Thu, Feb 06, 2003 at 05:08:55AM -0800, Ray Stell wrote:
>
> Where is it well documented how to install multiple server versions,
> 8i and 9i, on the same unix server?
--
Thanks for you replies. I've never tried this before and it seems like
there are two different approaches on the surface:
Title: Message
Thanks
for the help!
Ron
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06,
2003 5:49 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Help with a truncate command in a
procedure
(pant pant) Will I
So, what's wrong with reference cursors?
Why are you looking for anything different?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, February 07, 2003 7:58 AM
> All,
>
> My current application is
Jack,
I always knew there was a limit on the size of a parfile which I had assumed
was a maximum no of tables allowed. However I recently found out that it is
a byte limit on the overall file parameter. (It was 8K in 7.x )
Do you not hit this limit with several thousand table names (presumably not,
Ray - the one thing we do is always make sure we don't corrupt the Oracle Inventory
files. Whenever we install a new version of Oracle, we copy then delete the current
oraInst.loc file (e.g. cp oraInst.loc oraInst_u03.loc), which on our system is located
in /var/opt/oracle. We have our Oracle
Title: RMAN question
Hi!
How do I make RMAN delete all obsolete backups? We are using a recovery catalog.
Example:
RMAN> report obsolete;
RMAN-03022: compiling command: report
Report of obsolete backups and copies
Type Key Completion Time Filena
Helmut,
This thread came up a couple of days ago
The answers were to use the commands
change datafilecopy delete or change backuppiece delete
Also have a look at the script $ORACLE_HOME/rdbms/demo/rman1.sh to automate
the process from the output of report obsolete
HTH
John
-Original
Title: RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an
Thanks Robert,
I wasn't aware of that issue. Plus now that we have all instances on 9202, we hope it won't bite us. As for adding tablespaces dynamically, no chance. We *require* that development team request space at-
Title: windows application to show sql being executed by a client program
BBabu,
Like he said, talk directly to the developer ... read the README.eng
file.
Thanks Jacques for finding this product ... I already like it and am in
touch with the author with some issues.
Raj
__
Craig,
I had to smile when you stated you had 400 tables and were reluctant to
list them in the export or import parfile. Our 3rd party Student
Information system has over 47,000 tables. I frequently do exports and/or
imports with parfiles listing several thousand tables. It's not a problem
at
All,
My current application is written in VB accessing the Oracle back-end. I
have just been asked about how to execute a query that may return many
thousands of rows, but only display, let's say, 1000 at a time. After the
first set of rows was returned, the user would click a button and request
Whatever you choose, I would recommend a program that has evening classes over a 2-4
month period. Ive always been skeptical of 5-10 days all day classes. Too much
information too fast. That may not be an option for you if you have other obligations,
but its generally the best way to learn when
Hi all,
I need gather some principles for good db design. Do
you happen to have
any or do you good links where I could check some
white papers etc...
rgds
_
Gratis e-mail resten av livet på www.yahoo.se/mail
Busenkelt!
--
Please see the offici
Thanks for the help. But I just checked the note, and it doesn't work
for 8i Standard Edition, only Enterprise and Personal. Guess which one
we've got?
Craig
> -Original Message-
> From: Breno A. K. Magnago [mailto:[EMAIL PROTECTED]]
> Sent: 07 February 2003 10:59
> To: Multiple recipient
Title: RMAN question
Hi!
How do I make RMAN delete all obsolete backups? We are using a recovery catalog.
Example:
RMAN> report obsolete;
RMAN-03022: compiling command: report
Report of obsolete backups and copies
Type Key Completion Time Filena
1 - 100 of 112 matches
Mail list logo