Title: RE: last column in a table is added with a DEFAULT
David,
The
best way to see if this works is to create a test table. populate it with
some data. Add a column with a default value.
and
observer what happens.
best
way to learn.
Tom Mercadante Oracle Certified Professional
What do you have as an example of an attribute?
Vernaillen Tim
Thanks for the replies so far. Considering the fact that my database is
tiny ( just around 3 GB ), How many of them can work on same server? I can just
test with 5 instances, with limited hardware. Will the CPUs be able to take load
of 100 instances? Is it worth experimenting this?
I am
Heard an Oracle rep last week say that 10G was mostly
hype. If you want to watch what's for real at Oracle
it's Linux.
Only time will tell if he is right, but he has a
better inside track to the Oracle gossip that I do.
--- [EMAIL PROTECTED] wrote:
Could someone reach over and turn the Grid
Hello,
I am trying to make a temp table with no logging as select * from table.
Does anyone have a good example? THanks a ton!
Jake
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and
I know, with earlier version of Oracle, columns likely to have null values
were placed at the end of the table, to save on some minuscle bytes of
space. If the null columns fall between columns with data values, then one
byte is used for their storage. Else, they require no storage. But no,
if this is 9i, anyone with DBA privs can grant access...
grant select, update, delete, insert on table_owner.table_name to
grantee;
we have a hosting company that manages the staging and production
databases. I do not hard-code passwords into scripts when I pass them
to the hosting company. They
is anyone using tivoli to do oracle monitoring, good/bad, etc.
thanks, joe
--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
INET: [EMAIL PROTECTED]
Fat City
Title: RAC interconnects
Hi all,
Is it possible to somehow tell Oracle to use all available interconnects (between nodes) for the GC traffic? We have 2 private interconnects but we see all the traffic only on one of them. The other is used only if the first one is not available.
If Oracle
As for the datafiles and indexfiles being distributed over different
physical disks, well I can not confirm you are wrong, in our site id DID
boost the performance, and specially if you locate in separate physical
drives your redologs and datafiles (both indexes or data). Of course it
depends on
Title: Message
I
already have :)
-Original Message-From: Jamadagni,
Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday,
August 07, 2003 12:04 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: possible Bug in Oracle
9.2.0.2
Tell them ...
Raj
Title: Message
Doh! Thanks for pointing out the obvious to me. I'm sure that
will work. I'll go crawl back in my cave now :ol
Thanks
Tom!
-Scott
Stefick
-Original Message-From: Mercadante,
Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August
07, 2003 1:29 PMTo:
The benefits of spreading the data over as many physical access paths ( ~
disks ) using multiple datafiles notwithstanding, there is always the case
of too much. Keep in mind that at checkpoint time the DBWR need to visit
the header of every ( non read-only ) datafile. That's unlikely to be an
Sorry, I skipped mentioning that, but we did try it, for the members.
Got an ORA-01514: error in log specification. No such log.
ORA-01517: log member: 'F:\ORACLE\ORADATA\TCP1\LOG3TCP1.ORA'
When we used the group number, we got an:
Title: Implementing different document types with different attributes
Hi!
FlexFields are used in Oracle E-Business Suite,
they aren't nothing else than varchar2 fields where you can configure Apps to
write your custom data (either one logical field by database column, or several
fields
Hi!
Just stop and disable the service Automatic Updates under Control Panel -
Adiministrative Tools - Services.
Also, a service called Background Intelligent Transfer Service appeared,
which is able to transfer files in *background* i.e. without you knowing
about it, for automatic update and some
Gee, that question sounded a whole lot better when I wrote it yesterday than it did
this morning when I saw it. :) Maybe I should be a little more vague.:)
The problem is there are a couple of things I am trying to accomplish. We have clients
that use our application that have specific
At 09:59 AM 8/7/2003 -0800, you wrote:
Hi!
The benefits of spreading the data over as many physical access paths ( ~
disks ) using multiple datafiles notwithstanding, there is always the case
of too much. Keep in mind that at checkpoint time the DBWR need to visit
the header of every ( non
Title: Message
Join
TAB$ and COL$ directly (on OBJ#) and your problem is gone. You'll get only
columns that
belong
to tables. You should also set _disable_suboptimal_app_design to
TRUE
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL
Over 600KBytes/s from:
http://oracle-updates-west.conxion.com:8000/ARUConnect/dGREMDJJdVRxZGtxQjdNT
Ud1UHFxUTo0MDE5OTI4OnAyNzYxMzMyXzkyMDNfSFA2NC56aXA6UVRJREJBOjE2MS40OS4yMS40M
joxMDYwMDk4OTczOk5PX1BBU1M@/p2761332_9203_HP64.zip
Get yerself a new pipe. :)
Rich
Rich Jesse
Interesting web site that bigip... Picture of Larry with the annotation --
Coming Soon. Does this mean that Larry truly does not exist yet???
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Title: RE: Record breaking query
Thanks Wolfgang,
our retention time is 21600 seconds ... and this one bailed out in half the time ...
Oh well ... we need to fix few more things ..
Raj
Rajendra dot
Thanks for all those who responded my mail.
When there was buffer parameter or record length parameter, It did not
work.
Instead of importing the full dmp file, If I try to import one table, it is
working okay.
I still have to try couple of alternatives and let the List Group know the
outcome.
Title: SharePlex
it is _supposed_ to work that way ... close to production. But last time
we looked at it, there were too many limitations relates to IOT, VARRAYS etc and
it wasn't ready for our platform and version .
but it is supposed to be good ... I have heard similar things about
Title: RE: Record breaking query
12GB only
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 !
after installing SP4,even MS-Office troubled me a lot.
.came back to SP3 again.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Title: Implementing different document types with different attributes
Hello
I've an installation/implementation question!
We've to analyse 50 document types, in total those 50 has 70 different attributes.
We don't want to put all those document types into one table, because more than
Yes, V$OPEN_CURSOR is instance-wide, but each row in the view sure looks
like it can be attributed to a specific session via SADDR/ID/USERNAME. And
the count of those rows for each session doesn't match the corresponding
row/attribute in V$SESSSTAT.
Erm, I'll leave off the product name here
Paula - How is your duplication going? Well I hope. Are you basically trying
to perform a disaster recovery? That was basically what I was requested to
do. The statement was imagine the computer room was taken out by
terrorists, and all you have are the tapes from the off-site storage. You
are
Members,
Production 8.1.6.3 database on Windows NT 4.0.
We noticed an entry in the alert log, citing that a log group could not be
archived since the 25th of July.. We have 3 log groups with 2 members each.
I notice that the 3rd redolog group has a status of Inactive with
Archived=No. This group
30 matches
Mail list logo