Hi ,
if I'm not wrong,
it's because there is another instance use the same db name.
check ur initSID.ora
regards
-Original Message-
Setiawan
Sent: Wednesday, March 28, 2001 2:45 PM
To: Multiple recipients of list ORACLE-L
Dear Listers ,
yesterday , I've created 2nd database for Test u
Tom Kyte (asktom.oracle.com) kindly posted me a reply
to my question on the above latch. For anyone
interested, the description is below
Cheers
Connor
-- START QUOTE
Event Group Latch
Usage
This latch is used during the following operations :
An "alter system set events.." command.
During
Is this problem specific to the cluster solution or has it manifested itself
on non-clustered setups ?
We are about to implement a Tru64 5.1 Oracle 8.1.7 system.
As I cannot access the tar you mentioned could you please forward on the
instructions.
Regards
Lee
-Original Message-
Sent
I have read the same : different blocksizes per
tablespaces in Oracle 9i.
--- Rachel Carmichael <[EMAIL PROTECTED]> a écrit :
> no flame supposedly in 9i you will be able to
> change the block size
> while the db is up and will also be able to have
> different blocksizes -- I
> think it's b
Hello,
I need some clarification. What is the significance of the Oracle variables, TNS_ADMIN
& LD_LIBRARY_PATH?
When are the 2 used or what effects what in the environment?
Also please if some one knows how do I monitor an Oracle Parallel Server? Any good
book where I can read about OPS?
R
Rocky !
I guess you are talking about his OCP TEst prepration guide.
I think it is published by new riders.
A quick search on AMAZON.com will give you more
detaiils
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, March 28, 2001 2:45 AM
Helmut,
I believe that SQL*Loader is the quickest way to load your data. You could
write a procedure that uses UTL_FILE also. And there is another choice, but
truly brute force - you could edit your file into INSERT statements and load
it through SQL*PLUS. :-(
Ron Morton
Union Switch & Signal
Hi ,
destroy=y option doesn't meet the requirement . I checked the oracle docs
and didn't find any option to overwrite data.I think i have to truncate
data and then insert into appropriate tables as william pointed out.
Thnaks to every one who responded.
Azhar Siddiq,
We have some 8.0.4 databases running on Sun Solaris.
I believe that 8.0.4 has been desupported as of December 31, 2000.
We are unable to upgrade one of our apps at this time that is
running on an 8.0.4 database.
Is the terminal release of 8.0.x still supported? If yes, what is
that terminal rel
Sinardy Xing wrote:
>
> Hi guys,
>
> I am a new DBA, can you please tell me what are the common task list as DBA
> for Oracle8i on Solaris 7. I mean things that I should do and check
> regularly.
> I know backup is one of them.
get the book _Oracle DBA 101_ it has not only that kind of list,
Thank you Winnie. Thats exactly what I was looking for!
Gene
>>> [EMAIL PROTECTED] 03/27/01 04:42PM >>>
I am not quite sure that you can reference a LOB in a remote database
through a database link. You are very likely to get the ORA-22992 error
when you attempt to do so.
22992, 0, "cann
Murali,
I will not have the rights to see your TAR. Could you tell me what patches you had
to apply?
Thanks,
Jay
>>> [EMAIL PROTECTED] 03/27/01 04:43PM >>>
We use COMPAQ tru64 5.1 with Oracle 8.1.7. we had noticed corruption in some
all files and had to apply some O/S level patches.
We fol
Hi Doug , (and all) ,
Just curious - the PS environment, do you put finance and HR on the same DB?
Do you share the sysadm user? I'm new to this PS stuff, so this interests
me. Also, in production, do you have the PS databases separated from the
other OLTP databases?
Thanks
Mike Lanteigne
To change the block size you have to recreate the database.
How you are going to copy the data that's another issue. You can use full
database export/import (pretty long downtime, or problems with data
consistency) or you can do a live copy. More on a live copy you can see in:
Venkat S. Devraj,
Lee,
Be sure to check the alerts on Metalink for Tru64 (Product Lifecycle, Alerts).
There are OS level patches requried for nonclustered systems. See Note 132391.1.
Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA
>>> [EMAIL PROTECTED] 03/28/01 03:00AM >>>
Is this probl
Or you can write a program in (C, Perl, Java, etc) to parse the file and do
inserts.
Richard
-Original Message-
Daiminger
Sent: Tuesday, March 27, 2001 10:36 PM
To: Multiple recipients of list ORACLE-L
Hi!
Is SQL*Loader the only way to move the contents of a comma-delimited ASCII
file
Also there is a book by Heidi Thorpe Oracle 8I Tuning and Administration
where there is a big chapter about database monitoring.
Alex Hillman
-Original Message-
From: Joseph S. Testa [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 9:20 PM
To:
Can anybody give me pro and con for having let say several Peoplesoft
schemas in the same database versus in different databases. Should objects
of different schemas be in the same tablespaces or every schema should have
it's own set of tablespaces etc.
Alex Hillman
--
Please see the official
Have any of you received one of those lately?
I remember last year they used to check with us to see whether we were happy
with the service, but I have received nothing in a long time.
Someone soft closed one of my TARs, saying he had sent me the information I
requested, but I can't find anythin
Here is a quick list:
Daily checks
- Oracle Alert file logs
- system resources
- backups
- archive logs
- error logs
Weekly checks
- free space in Tablespaces, Tables, Indexes and Clusters
Monthly checks
- fragmentation in Tables, Indexes and Clusters
Ben Poels
Queen's University
-Original
I put mine right before I do an archivelog backup, which I do at the end of
my level 0 and level 1 backups.
But if I was not doing an archivelog backup I would not even archive my
current log because there would be no reason to do so,.
HTH,
Ruth
- Original Message -
To: "Multiple recipie
dang, now I owe you a quarter :)
>From: "Thater, William" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: New born DBA.
>Date: Wed, 28 Mar 2001 04:26:26 -0800
>
>Sinardy Xing wrote:
> >
> > Hi guys,
> >
> > I am a
Hi there :)
After a rather interesting start of my week, I have a question for you about
the backup of local PC test databases.
At the end of last week I deleted my current test database along with all
Oracle files, and went for a fresh install, due to having some rather
interesting ora-600's
Thanks for the heads up.
We are also planning upgrades from 40F to 5.1 nonclustered with Oracle
8.0.6. Has anyone considered or implemented Compaq's SAN architecture?
Mike Hand
Polaroid Corp
-Original Message-
Sent: Wednesday, March 28, 2001 7:56 AM
To: Multiple recipients of list ORACL
Oracle, by default, uses $ORACLE_HOME/network/admin to stor the tnsnames.ora,
sqlnet.ora, listener.ora, snmpro.ora and snmprw.ora files for configuration
of the Net8 services. If you declare a TNS_ADMIN variable oracle will use
that location for these files. It allows you to keep your network
Just my $.02. I agree separate tbs for different app schema's. However, I would
separate applications to their own db, especially if they are 3rd party apps. You
have much less control on COTS. Some run their install scripts as sys. I don't agree
w/ it, but I am not going to rewrite their
Joe,
No flame. There are other methods of doing the job, but the work!!!
Spooling all the data out to comma delimited files, creating all those DDL
scripts!! You'd have to be a masochist or else into some HEAVY re-engineering!
Dick Goulet
Reply Separator__
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
---
Hi Gang,
Happy Wednesday! Has anyone read this book? I'm interested in what you
thought of it.
Thanks,
-Rocky
--- K Gopalakrishnan <[EMAIL PROTECTED]> wrote:
> Rocky !
>
> I guess you are talking about his OCP TEst prepration guide.
> I think it is published by new riders.
>
> A quick search
try elance.com
--
email: [EMAIL PROTECTED]
Oriole Corporation (http://www.oriole.com/)
Oracle Performance Tools and Free Scripts
Tel: +44 (0)20 7872 5480
Faxes: UK +44(0)705 066 8661 / US +1 240 526 5946
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]
You could also download and use the following checklists which are always
handy to refer to when starting up:
http://www.geocities.com/tbcox23/dba_checklist13.doc
http://pillango.sirma.bg/oracle/N008_dba_checklist.pdf
Good luck on that HUGE rollercoaster of a learning curve ORACLE!!
HTH
Mark
Ian,
From what I've seen on 8.1.6 & 8.1.7 it still does the non immediate kill
changing the session status from active/inactive to sniped, but it does release
locks a whole lot faster.
Dick Goulet
Reply Separator
Author: "MacGregor; Ian A." <[EMAIL PR
I'd be interested in seeing that presentation, when are you presenting?
I'll be there doing the logminer thing on tuesday late afternoon, last
session before BIG BASH.
thanks, joe
>
>To change the block size you have to recreate the database.
>
>How you are going to copy the data that's anoth
Hi. I had some problems with getting Intermedia to work after patching
to
8.1.7. I got a
ORA-04045: errors during recompilation/revalidation of CTXSYS.CONTEXT
ORA-29835: ODCIGETINTERFACES routine does not return required
interface(s)
When trying to create an index. Searched Metalink, and eventu
Title: RE: 'Event Group Latch'
Thanks, Connor!
-Original Message-
From: Connor McDonald [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 2:56 AM
To: Multiple recipients of list ORACLE-L
Subject: 'Event Group Latch'
Tom Kyte (asktom.oracle.com) kindly posted me a reply
to
My firm is currently using Oracle Applications 10.7SC and are in the planning stage
for 11i. I have been tasked with finding the Workstation requirements for 11i. The
Workstations will be running Windows 2000 with Microsoft Office, email client and a
number of smaller financial applications. I
Hi Alex,
Are you sure in Unix you do not need password for internal if you
are member of DBA group ?
-- neena
"Hillman, Alex" wrote:
> If you are on unix - you do not need internal password if you log in as
> member of dba group. On NT before 8.1 you need internal password b
I'm kind'a thinkin' out loud on this one. but suppose we have say 3
servers, with 8.1.7 Standard edition, is there any point in paying for
Oracle support for all 3 or having problems with "any" one of them logged
via one support package. Where are the gotcha's on this line of thinking
(I'll
DBA's,
Has anyone been able to automate secure ftp "sftp"?
I have several cron jobs that move an ascii file from one box to annother via cron
jobs & shell scripts. The security gestapo is now making us use ssh and sftp. I
haven't been able to figure out the syntax to get sftp automated.
Su
I would say no Celeron processor for sure, I would go with PIII's 500 or
above, minimum 128 RAM 256 would be better, at least a 10 gig hd. We use
Dell Optiplex workstations, most of them are 500's and we don't run into any
problems, most of them have 10 to 20 gig hd's and 256 mb's of RAM.
Kev
--
Check out First Steps on our site.
--
email: [EMAIL PROTECTED]
Oriole Corporation (http://www.oriole.com/)
Oracle Performance Tools and Free Scripts
Tel: +44 (0)20 7872 5480
Faxes: UK +44(0)705 066 8661 / US +1 240 526 5946
- Original Message -
To: "Multiple recipients of list ORACLE-L" <
I have W. Baird's book, "Oracle OCP". Unless there is a newer edition out it
only covers Oracle 7.x, not 8 or 8i. I used it to help me pass the first OCP
exam, SQL and PL/SQL. It was adequate for that if you also have considerable
SQL experience with Oracle or other DBMS's.
For the second exam, D
Title: Standard vs Enterprise Edition
Due to Oracle's licensing shenanigans, we are looking at the use of the Standard
edition to save . In fact, our management may even make Standard the de facto
standard while requiring justification for Enterprise.
If anyone is currently using Stan
Alex,
We've done both. Is there a down side, yes on both counts.
With multiple Peoplesoft schema's your tablespaces need to be bigger, like
initial size times number of schema's plus fudge factor. Also you can get IO
bound on certain tablespaces, like PSINDEX real fast. You really can
Access User Groups...
Sure, most High Schools have Groups that meet to discuss such things...I
think they call them Clubs though! I've heard they provide some really neat
technical discussions like..."How to Convert your Parents Paper-based
Contact List into Access"..."Access 2000: Breaking the
I had a call from Oracle Support about three weeks ago for a telephone Metalink
customer satisfaction survey. What an opportunity;-)... I let them know it was
unusably slow, inconsistent (call something the samething throughout what a concept),
can't fing basic things like patches, no respons
Ravindra, try using 'trunc' on your group by clause.
-Original Message-
Sent: Wednesday, March 14, 2001 7:11 PM
To: Multiple recipients of list ORACLE-L
Can we use the group by clause on a date column.I am written a query to get
a count(*) of records with a group by clause on the date
Hi,
I'm in digest mode, so here's reply to those OPS questions...
I don't think you can set up OPS without a hardware cluster. In fact,
if you don't turn on the Lock manager at the os level the Oracle
installer won't even show OPS as an installation option!
As for other other question re. conv
Title: Standard vs Enterprise Edition
We
also have a client that wants to use Standard because it is less
expensive. I tried to install 8.1.6 SE on an NT server that already had EE
on it. I made it a multihomed machine but ran into a problem with a
dll. Seems to be a known bug, needless t
Jeff,
Yes we use Standard and Enterprise. Do you lose some things, yes. Does it
matter, depends on the application. In our case we could work around those
restrictions without problems. Otherwise it's a good ploy to save a buck.
Dick Goulet
Reply Separator___
Title: OFFTOPIC RE: sqlplus
This post would have been ALOT funnier, if Ravindra's
name was, instead, "Ganesh".
(Sorry about all you folks that don't like Hindu Mythology based
puns.)
-Original Message-
From: Bala, Prakash [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 200
We batch load data into an application called Oracle Clinical.
The batch load failed and gave the error: "Error: Failure to get normalized
flag."
Could low tablespace indirectly cause this error?
Any help/ suggestions would be appreciated.
Jenah Sigurdson
--
Please see the official ORACLE
Mark,
I might suggest that you look into a "Ghost" product for making an image of your PC.
I "ghost" my pc and keep the image on the network where it is backed up each night and
stored on tape. If I have problems with my PC I load the image to the second drive and
I have access to all of the o
Hi All,
I am running a test query with different db_file_multiblock_read_count to test the
overall throughput.
environment: oracle 8.1.6 on hp-ux v11
db_block_size : 16k
system is using LVM and file system is using buffered I/O and disk is mirrored but not
stripped.
I was expecting that
Regina, try sqldbcode. This will give the exact Oracle return code.
Prakash
-Original Message-
Sent: Wednesday, March 21, 2001 9:05 PM
To: Multiple recipients of list ORACLE-L
We have a number of Powerbuilder applications for which we have been using
the SQLCode returned from a sql st
The terminal release of Oracle8 is 8.0.6. Not sure of the desupport
date, even though I have 4 databases running it. I really don't worry
to much about the desupport date. As a general rule if it ain't broke
I don't fix it. Granted we are going to 8.1.7 on most of them but that
is to get a lot
Actually I meant Dick, nor Doug, sorry
Mike
> -Original Message-
> From: Lanteigne, Mike [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, March 28, 2001 8:35 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: What is best practice - differenet schema/different dbs
>
> Hi Do
well the concept of support is you pay for it and it covers all versions(at
leats until desupported which seems quick nowadays).
hence the concept of "free" version upgrades :)
joe
>From: "O'Neill, Sean" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE
Another option is to create a table with a large varchar2 column and insert
the data row by row.
You can then spool a SELECT from that table to a file.
e.g.
create table hold_output
(mytext varchar2(4000)
tablespace ts_small;
-Original Message-
Sent: Tuesday, March 27, 2001 4:09 PM
To: M
We use it for all of our small, under 10 gig, NT databases (at last count
we had 13). Many of the features of Enterprise are just not needed for
these systems because the user/data volume is small and we are not using
replication or fine-grain access control. All of the 3rd party applications
(ex
Maybe there are several things you want to check on your table in database
B
1) Do you have any trigger on that table?
2) Do you have any foreign key constraints on that table?
3) Is that table structure the same on 2 databases?
Winnie
"Helmut Daiminger" <[EMAIL PROTECTED]> on 03/28/2001 11
Thanks for the suggestion, Prakash, but SQLDBCode is also returning 0 for
no rows found.
At 08:25 AM 3/28/01 -0800, you wrote:
>Regina, try sqldbcode. This will give the exact Oracle return code.
>
>Prakash
>
>-Original Message-
>Sent: Wednesday, March 21, 2001 9:05 PM
>To: Multiple reci
We are doing that here, we have a 7 ft. tall SAN frame with dozens of hard
disks laying about in boxes, with two es-40s also in boxes.
We plan to have that put together by mid April.
Regards,
Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Cana
Did someone change the password of the app logging into the db?
>>> [EMAIL PROTECTED] 03/28/01 11:40AM >>>
We've been running iAS 1.0 for several months without problems. Now users who have
already been verified are at times getting the following error when they move to a
new URL.
Hi!
I'm having weird problems with exporting/importing tables...
First I run an export on database A
About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > tbclocktimes
. . exporting table TBCLOCKTIMES 29
Thanks
>>> [EMAIL PROTECTED] 03/28/01 12:05PM >>>
I would say no Celeron processor for sure, I would go with PIII's 500 or
above, minimum 128 RAM 256 would be better, at least a 10 gig hd. We use
Dell Optiplex workstations, most of them are 500's and we don't run into any
problems, most of them
Sometimes I forget that unhappiness is only based on perception.
"Thater,
William"
Prasad,
the difference here is :
select count(*) does not require the data in all of the columns.
if you are going to be including columns that return a large amount of data,
then the larger reads should help.
As its most likely that the OS read size is 64 KB, it makes sense that a
local minim
Hi gurus
I am new to this group.
What are those files need to backup in online backup mode?
how we know the database is setup in OPS mode?
Please help me.
Thanks in advance.
Seema
_
Get your FREE download of MSN Explorer at http://exp
The authentication is via the users' oracle passwords. One user just got the error,
and she doesn't use cookies. It is intermittent, but once it occurs, the users need
to be reauthenticated before it works successfully.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-
Hi!
Is there a tool available that allows me to read data from a comma-delimited
flat file into Oracle and if a row already exists, updates that record. If
the row does not exist, it should insert a new record into the table.
Looks to me like SQL*Loader can't do this.
How could this be done?
T
Regina, did you try using the ODBC driver that you used earlier.
-Original Message-
Sent: Wednesday, March 28, 2001 1:46 PM
To: Multiple recipients of list ORACLE-L
Thanks for the suggestion, Prakash, but SQLDBCode is also returning 0 for
no rows found.
At 08:25 AM 3/28/01 -0800, you
Solaris V2.6 Oracle V8.1.8
Previously I logged in as username "HR" & did
SQL> GRANT SELECT ON EMPHEADER_MASTER TO BCM;
Within a PL/SQL package the following lines exits.
EXECUTE IMMEDIATE 'TRUNCATE TABLE HR_EMP';
EXECUTE IMMEDIATE 'DROP TABLE HR_EMP';
EXECUTE IMMEDIATE 'CREATE TABLE HR_EM
Anyone using storage area networks for an Oracle database. Who is the vendor and what
is your opinion of the product.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204
Anyone using storage area
Helmut, have you thought about using UTL_FILE package?
-Original Message-
Sent: Wednesday, March 28, 2001 2:37 PM
To: Multiple recipients of list ORACLE-L
Hi!
Is there a tool available that allows me to read data from a comma-delimited
flat file into Oracle and if a row already exists,
Mike,
We are using the SAN architecture.
Jay
>>> [EMAIL PROTECTED] 03/28/01 10:36AM >>>
Thanks for the heads up.
We are also planning upgrades from 40F to 5.1 nonclustered with Oracle
8.0.6. Has anyone considered or implemented Compaq's SAN architecture?
Mike Hand
Polaroid Corp
-Origin
Hi gurus
Is it necessary to take full backup when we change the database from
archivelog mode to noarchivelog mode and vice versa.
Thanks
-seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the
We're not connecting via ODBC, we're using the native drivers, but yes, we
have tried both the 7.3 driver we used to use and both the 8.0 and 8.1 drivers.
At 12:12 PM 3/28/01 -0800, you wrote:
>Regina, did you try using the ODBC driver that you used earlier.
>
>-Original Message-
>Sent:
Can you have a before-insert trigger on your table to do whatever you want
and then use conventional sqlldr to load it?
winnie
"Helmut Daiminger" <[EMAIL PROTECTED]> on 03/28/2001 12:38:10 PM
Please respond to <[EMAIL PROTECTED]>
To: "Oracle DBA List \(Lazy DBA\) \(E-mail\)" <[EMAIL PRO
Yes, it is necessary to take a full backup when you change your database
from noarchivelog mode to archivelog mode. Or else you will never have a
"base" to perform recovery if it is needed.
Winnie
"Seema Singh" <[EMAIL PROTECTED]>@fatcity.com on 03/28/2001 01:25:26
PM
Please respond to [EM
Helmut,
Use SQLLOADER to load the file into a temporary table. Then write a
script/procedure to scan the contents of temporary table, compare this info
with base table, if row exists, update, else insert.
IMME (In my modest eperience) this is the easiest way.
HTH Some
Raj
__
Yes. Unless you can risk having a time where you can't recover your
database.
Michael Armstead
Database Administrator, OCP-Certified
Corporate & Finance Information Systems
Glaxo SmithKline
> -Original Message-
> From: Seema Singh [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, Marc
In V$INSTANCE, there is a column named PARALLEL which will tell you whether
the instance is in OPS mode or not.
In online backup mode, you will need to backup
1) all datafiles
2) a binary backup of the controlfile
3) all archivelog files generated during the online backup period of time
4) I wil
You can't query or modify the same table as the trigger is firing on (The old mutating
table problem). What you could do is set up a temp table with a before insert trigger
which would query the other table and take the appropriate actions, this would solve
you having to run a separate procedur
Hi,
I would appreciate if someone could pass me a script
which compares table structures?
Johnson
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/?.refer=text
--
Please see the official ORACLE-L F
Oops !!! forgot to send the attachment.
Jeff,
We have a retail application (JDA) using Oracle 8.1.6 using the Standard
Edition.
It works fine with very few problems. Size of the database is 70GB.
The application uses very limited database features.
No replication, partitioning, OPS, sta
Download free version of TOAD from www.toadsoft.com.
Once installed and logged into look under
View--->Schema Differences you can compare many
aspects of two schemas (eg compare your test and
production schemas). Table comparisons are one of the
many things you can compare.
HTH
--- Johnson Poova
Thanks,
Waleed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Khedr, Waleed
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
Jeff,
We have a retail application (JDA) using Oracle 8.1.6 using the Standard
Edition.
It works fine with very few problems.
The application uses very limited database features.
No replication, partitioning, OPS, standby database, ...
Please see attached document from Oracle Technet for diffe
Title: RE: Standard vs Enterprise Edition
Thanks everyone for the replies.
-Original Message-
From: Suhen Pather [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 6:26 PM
To: Multiple recipients of list ORACLE-L
Subject: FW: Standard vs Enterprise Edition
Oops !!! fo
Hi!
I haven't received a single mail from the
LiST..
Is there a problem?
Please tell
Thanks
- Original Message --
"Rachel Carmichael" <[EMAIL PROTECTED]> wrote:
To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
From:"Rachel Carmichael" <[EMAIL PROTECTED
Is there any place where we can get Oracle books on Tape (Audio tapes or
CD's)
RK
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Apps Sol
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- P
>The cost of the Enterprise Edition compared to the Standard Edition is
large
>(2 x).
The way i figure enterprise is over 6.5 times more expensive. Enterprise =
$100/Universal Power Unit to $15.00/Universal Power Unit. That is quite a
difference.I would sure make sure we used feature avail
I know it is possible when creating a table to specify no logging
so that it doesn't generate redo logs. Is it possible, AFTER
the table has already been created, to change it to nologging?
Also this is a dev database that we don't care about doing any
type of recovery and just want to do some
Johnson,
You could simply create a database link
and run these queries.
select table_name,column_name from user_tab_columns@link
minus
select table_name,column_name from user_tab_columns
/
Do it both ways
select table_name,column_name from user_tab_columns
minus
select table_name,column_name f
Alter database noarchivelog;
will change the entire database.
see the following for detailed information:
http://technet.oracle.com/docs/products/oracle8i/doc_index.htm
HTH, Jim
-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wednesday, March 2
i discuss this in my advanced logminer class but the gist is this,
nologging has no impact on DML.
only the following operations can make use of the NOLOGGING option:
alter table...move partition
alter table...split partition
alter index...split partition
alter index...rebuild
alter ind
that has nothing to do with the question. But anyway, try ALTER TABLE
NOLOGGING instead.
oli
[EMAIL PROTECTED] wrote
> Alter database noarchivelog;
>
> will change the entire database.
>
> see the following for detailed information:
>
> http://technet.oracle.com/docs/products/oracle8i/doc_ind
cos u dont like Air. Ask Jared :)
> -Original Message-
> From: Cyril Thankappan [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 28, 2001 6:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: NOT A SINGLE MAIL!
>
>
> Hi!
>
> I haven't received a single mail from the
> LiS
1 - 100 of 115 matches
Mail list logo