Title: ORA-01406
Hi List,
Please can anyone give me some pointers on this issue.
We have third party app called Maximo with reports that run from within it.
We are receiving an error on one of these reports.
The Oracle error that comes out of it is
ORA-01406 fetched column value was trunca
Hi List !
i got ur replies then i came to
realise that i did not explain my problem in clearer way . Now i am
posting the code of my procedure and i hope u people make me understand whether
my approach is right ot wrong . There is a table INV ( for invoice ) and from
GUI is using differ
not once we get through with them (Kirti, you distract them, I'll take
the batteries)
--- Joseph S Testa <[EMAIL PROTECTED]> wrote:
> But they're laptops with working batteries :)
>
> joe
>
>
> Deshpande, Kirti wrote:
>
> >How about a seat near the power outlets ?? Then, it will be a fun
> e
and yet another one on my list of things to see. of course, like most I
want to see, it conflicts with something else!
I like the power outlet idea :)
--- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote:
> How about a seat near the power outlets ?? Then, it will be a fun
> experiment
> for Joe & S
Hi Robert
she'll be at this one but it's her "swan song". She's earned the right
to retire. And besides, she REALLY wants a puppy and can't have one if
she keeps traveling.
See you there.
Rachel
--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> Hello Rachel,
>
> I can't imagine IOUG-A w
Query V$SESSION. This will give the number of connections to the database.
OR look for V$sysstat ' logons current'
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Thursday, March 07, 2002 5:43 PM
To: Multiple recipients of list ORACLE-L
Hello List,
Just a s
Hello All,
Do we get FREE posters of Oracle Database System Tables for 9i. I know I did for
Oracle 8i. Any info???
Rgds,
raj
2,000,000,000 Web Pages--you only need 1. Save time with My Lycos.
http://my.lycos.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vir
Hello List,
Just a stupid Question.
I would like to know the Number of Active Users from a
Query inside the Database. Plus is it possible to know
the number of allowed licence for the Oracle
Thanks for U'r Time & Interest.
Fazal
=
Abul Fazal
Production Support Services - Quantum Leap
S
> To give credit where credit is due, this came from my friend
> K Gopalakrishnan...
You mean K 'X$' Gopalakrishnan, don't you ;-)
John Kanagaraj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Kanagaraj
INET: [EMAIL PROTECTED]
Fat City Network Services--
Change the application ! Your application seems a bit inefficient.
Anjo.
Seema Singh wrote:
> Hi
> I checked stattistics form v$sysstat view
> parse and user
>
> NAMEVALUE
> -- --
> user
Hello all,
Does anybody know what parameters I should be
tuning/change to try & reduce the number of busy buffer waits. I have
a system which at times has over 15+session waiting on "free buffer
waits".
The explanation that I have been able to find so
far is that session are waiting on
Hello all,
Does anybody know what parameters I should be
tuning/change to try & reduce the number of busy buffer waits. I have
a system which at times has over 15+session waiting on "free buffer
waits".
The explanation that I have been able to find so
far is that session are waiting on
Title: Message
A
quick google search for "IBM DB2 Documentation" turns up
http://www-3.ibm.com/software/data/db2/library/
Why
doesn't everbody Google?
-Original Message-From: Jon Baker
[mailto:[EMAIL PROTECTED]]Sent: Thursday, March 07, 2002 3:44
PMTo: Multiple recipients
"Orr, Steve" wrote:
>
> I like inline views but figured it wasn't necessary or wouldn't perform any
> better since we're really only dealing with one row despite the data
> mangling with a group function on a decoded result.
>
You are right, the inline view is not necessary. It has been a long
Title: Message
http://www14.software.ibm.com/webapp/download/category.jsp?s=c&cat=data
Contains a free Personal DB2 download and a trial of
UDB
-Original Message-From: Jon Baker
[mailto:[EMAIL PROTECTED]]Sent: Thursday, March 07, 2002 3:44
PMTo: Multiple recipients of list
Harvinder,
IMHO, you are using the wrong approach. FGAC is meant for row-level
security. In fact, DBMS_RLS (RLS = Row-Level Security) is the package that
supports FGAC.
It's a lot easier to use the TABLES parameter in your export and import
parameter files to control which tables are exported/
But they're laptops with working batteries :)
joe
Deshpande, Kirti wrote:
>How about a seat near the power outlets ?? Then, it will be a fun experiment
>for Joe & Susan ;)
>
>I will be doing my first ever presentation at IOUG-A.. Just a Quick Tips
>(Q31) - Wait Events in a Nutshell.. (bring y
Bill ;
I am just in the process of implementing RMAN at our shop.
We decided to go with RMAN for the following reasons :
* Reason1
RMAN manages what backups are required to perform the restore and where the
backup are located (will get the files off tape).
* Reason 2
The ability to perform HOT
Title: Message
DB2
Manuals at : http://www-3.ibm.com/software/data/db2/library/
-Original Message-From: Cunningham, Gerald
[mailto:[EMAIL PROTECTED]]Sent: Thursday, March 07, 2002
3:14 PMTo: Multiple recipients of list ORACLE-LSubject:
DB2
Hi
there,
Does anyb
Harvinder,
Every table needs a PK. Otherwise, you have no way of identifying a row
uniquely.
You also need an index on each FK, to prevent locking problems when
updating/deleting the parent table. You can kill two birds with one stone
by making your history tables' PKs (enforced by unique inde
I think he is looking for number of KTUXEs per block
not KTBIT (ITLs).
Does this ITL algorithm same for undo blocks also?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Thursday, March 07, 2002 12:41 PM
To: Multiple recipients of list ORACLE-L
Basically
Hi
I checked stattistics form v$sysstat view
parse and user
NAMEVALUE
-- --
user commits 903857
user rollbacks
It has a service name. Therein lies the mystery. In
theory this should work.
--- Suzy Vordos <[EMAIL PROTECTED]> wrote:
>
> Does your tnsnames.ora have SID or SERVICE_NAME for
> CONNECT_DATA? It
> should be SERVICE_NAME.
>
> Peter Barnett wrote:
> >
> > We are attempting to install SQLNet
Thanks Stephane,
> why the Unix format?
Actually it's to load data into RRD or ORCA.
I like inline views but figured it wasn't necessary or wouldn't perform any
better since we're really only dealing with one row despite the data
mangling with a group function on a decoded result.
Steve
Here's what I just got from OWS:
"After further research, this is a known issue that has development feed
back as follows:
BUG:1348362 'SQL EXECUTION' INFORMATION IN V$SESSION_LONGOPS IS INACCURATE
WHEN SORTING
Status: 92,Closed, Not a Bug
This is not a b
No version numbers, and no O/S details.
Cary Millsap mentioned to me a little while
ago that on one of his linux platforms the
values you got from timed_statistics seemed
to be a very good random number generator ;)
Possibly this is just a 32-bit/64-bit misalignment
in code - I've seem similar s
Title: Message
http://nscpcw.physics.upenn.edu/db2_docs/
could
be useful. i'm still trying to get a free trial copy of
db2...
-Original Message-From: Cunningham, Gerald
[mailto:[EMAIL PROTECTED]]Sent: Thursday, March 07, 2002
4:14 PMTo: Multiple recipients of list
The following is from the Tim Gorman paper
· OPTIMIZER_INDEX_CACHING
This initialization parameter represents a percentage value, ranging between
the values of 0 and 99. The default value of 0 indicates to the CBO that 0%
of database blocks accessed using indexed access can be expected to
Steve,
Hmmm doesn't look right as KG pointed out, might be a bug ...
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 Inc.
Taking a different tack - it doesn't really matter
very much what the maximum is, as you don't
want to have more than 5 concurrent transactions
per rollback segment or you start losing space
in rollback blocks in a big way. (There is a
block reuse pool limited to 5 blocks). And
you start gettin
awesome article - tanks
-Original Message-
Sent: Thu, March 07, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L
Tim Gorman wrote a good paper about using these parameters:
http://www.evdbt.com/SearchIntelligenceCBO.doc
Shaw John-P55297 wrote:
>
> have you tried adjusting opti
Thanks Robert, and thanks once again, Gopal.
Now, metalink also has a formula for finding the number of transaction
slots (DOC ID: 177926.999), and Steve Adams too explains precisely how he
arrived at that number of 21 slots for a 2K block size at
http://www.ixora.com.au/q+a/0008/29204045.htm wi
The problem is not with using blobs, the problem is with creating them.
They have a configuration
file that is stored within the database, when you are loading your images,
you can specify
the configuration you want, they have an option on the storage type, long
raw or lob, if you specify
lob you
I see what you're concerned about. The recent sessions' operations
are getting aged out of v$session_longops almost as soon as they are
done, and there are a bunch of old sessions' operations sitting around
in there from last November.
Looking at some of my systems, I see a couple stragglers fro
Well here's what's curious...
Notice the changing SID-serial# with the same sql address and hash.
Notice how elapsed seconds gyrates. Elapsed seconds goes from zero to
447,507,719 yet there were only a few seconds between the queries. How can a
session with 447,507,719 seconds of elapsed time
Anjo,
Quick, correct you answer before anyone else
gets in there. The guy is asking about the
transaction table in the rollback segment header,
not about the ITL.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host to
Title: Message
Hi
there,
Does anybody know if
there's a list such as this one for DB2? Or, a link to DB2 documentation (maybe
something like the Oracle Concepts Guide)?
Thanks!
-
Jerry
[EMAIL PROTECTED] wrote:
>
> Hi,
>
> I was wondering why Oracle force minextents for rollback
> segments to be two. Why can't we have minextents zero or
> no minextents clause at all.
>
> We can surely set initial extent to be large enough ourselves
> and next extent sized accordingly.
>
> Can
You've already got the main answer from KG and RF.
The figures on Metalink look much too high - but they
might be from an earlier version of Oracle. The size
is strongly version dependent.
In Oracle 9 (automatic UNDO only) the figures are
closer to:
4K=> 22
8K=> 48
In m
Steve,
I suspect this could be another BUG like your old V$sysstat.
By any chance you have set the _sql_exec_progression_cost to
lowest values?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Thursday, March 07, 2002 12:19 PM
To: Multiple recipients of lis
[EMAIL PROTECTED] wrote:
>Well, since hints are implemented within comments, I would assume that other
>databases would simply ignore them. If anyone has direct experience, that
>would be interesting. Being completely database-agnostic may play against
>tuning.
>
it has been my experience that th
just changed index_cost_adj from 100 to 1
what is index_caching?
-Original Message-
Sent: Thu, March 07, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L
have you tried adjusting optimzer_index_caching and
optimizer_index_cost_adj?
-Original Message-
Sent: Thursday, March
"Orr, Steve" wrote:
>
> I want to display V$SYSSTAT row values in columns. The current query:
> -
> select to_char(trunc(86400*(sysdate-to_date(
> '01/01/70','mm/dd/rr hh24:mi:ss',
> 'stat38:stat39:st
always analyze - it's step 1 in any tuning I attempt
usually use compute, but if estimate it's at least 15 or 20%
-Original Message-
Sent: Thu, March 07, 2002 3:19 PM
To: Multiple recipients of list ORACLE-L
Well, since hints are implemented within comments, I would assume that other
da
Hi all,
has anyone written a clean script to perform compiles in the order of
dependency in 9i db? Due to java objects if I join public_dependency and
dba_objects, it fails with ORA-01436: CONNECT BY loop in user data error.
When I write following script, it takes ages how do I tune this
esp
No it is not broken, unless someone explicitly updates underlying
information it is not visible I monitor this when I am creating or
rebuilding indexes to importing ... at that time Oracle will populate
relevant fields, and that is really useful.
Raj
_
Tim Gorman wrote a good paper about using these parameters:
http://www.evdbt.com/SearchIntelligenceCBO.doc
Shaw John-P55297 wrote:
>
> have you tried adjusting optimzer_index_caching and
> optimizer_index_cost_adj?
>
> -Original Message-
> Sent: Thursday, March 07, 2002 1:23 PM
> To:
Basically the total ITL size can't be bigger than 50 percent of the
available space for data for the block size. ((db_block_size - ovh) /2) /
itl size
Anjo.
[EMAIL PROTECTED] wrote:
> I believe someone else had asked this question before, but I did not see a
> reply. Does anyone know the nu
Rajesh,
The transaction slots are clearly visible in the Undo Header dumps. I
think this takes some 40 bytes space in the undo header block and this
limits the number of ***concurrent** transactions for that undo segment.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Messag
Is my V$SESSION_LONGOPS view broken?
Check out the curious results below. Notice the changing SID-serial# and how
elapsed seconds gyrates. None of the below sessions are in V$SESSION. The
sql address and hash is not extant in V$SQL, V$SQLAREA, etc. (Note, we are
using PQO with timed statistics.)
It depends ... to quote my SA, 'You can never be paranoid enough about
security ... but you need to know when to stop and have a life."
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expr
Well, since hints are implemented within comments, I would assume that other
databases would simply ignore them. If anyone has direct experience, that
would be interesting. Being completely database-agnostic may play against
tuning.
Just a thought. I suppose you analyzed all tables when yo
To give credit where credit is due, this came from my friend
K Gopalakrishnan...
The transaction slots are visible as KTUXESLT in X$KTUXE. We can get the
number of transaction slots in the rollback segments by
select count(*) ktuxeslt from X$ktuxe group by ktuxeusn;
The # of transaction slots
The transaction slots are visible as KTUXESLT in X$KTUXE.
You can get them using this SQL..
select count(*) ktuxeslt from X$ktuxe group by ktuxeusn;
For a complete value you can get the slot size form V$TYPE_SZIE
and do a simple math.. Let me know if you can't. I will do that
for you
Best Re
So, do you think I'm making a mountain out of a molehill over the
PL/SQL %type stuff...?
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-
have you tried adjusting optimzer_index_caching and
optimizer_index_cost_adj?
-Original Message-
Sent: Thursday, March 07, 2002 1:23 PM
To: Multiple recipients of list ORACLE-L
I work in a dev shop - most of the sql is canned and pretty basic. We've
been running CBO in all of our dev e
Interesting point . . . but the flip side of your argument is that by
putting hints in we, as the vendor, while not "requiring" you to use CBO
(since RBO will just ignore the hints) are saying, 'Hey, you had BETTER use
CBO if you want this thing to work the way we've designed it'
interesting to c
Is your setting for db_file_multiblock_count too high? What's the optimizer
mode? Have you set any of the optimizer_index_ parameters in the
initialization file? These parameters might be driving Oracle to prefer a
full table scan over a index scan.
My 1.2 cents (after NY Taxes).
Raj
I believe someone else had asked this question before, but I did not see a
reply. Does anyone know the number of transaction slots in the rollback
segment header for block sizes of 4k, 8k, et all?
>From what I have read, for a block size of 2K, its 21 transaction slots.
(Steve Adams at www.ixora.
not much - desire is to keep sql ANSI compliant due to cross-platform issues
(want to be able to run the app on multiple db's)
-Original Message-
Sent: Thu, March 07, 2002 2:44 PM
To: Multiple recipients of list ORACLE-L
How much have you played with Oracle Hints???
-Joe
--- "Magaliff
Bill - Are you saying that you switched to RBO for everything? I thought the
better procedure would be to remain CBO and put hints into individual SQL
queries. Is this a possibility in your environment? You mention that you are
a development shop. Does this mean that you create software and sell i
It's the way of the future -
>From 8.1.7.2 (or maybe 3) PL/SQL at the
server no longer does
select sysdate from dual;
when your code reads:
m_date_var := sysdate;
One down, six to go.
Anyway, why do we need DUAL when we have X$DUAL
which does take up any space or latching ?
Jonathan Le
I should have noticed you were using long raws. I would definitely move to BLOBS if
your system supports it. The lob segment should be in a different tablespace than the
data segment. This also allows you to name the lob segment which is quite useful.
I would suggest a 4MB uniform extent
How much have you played with Oracle Hints???
-Joe
--- "Magaliff, Bill" <[EMAIL PROTECTED]> wrote:
> I work in a dev shop - most of the sql is canned and pretty basic.
> We've
> been running CBO in all of our dev environments, but we have a few
> long txns
> that just take forever. At the requ
Everyone:
The address for the IOUG web site is www.ioug.org. The Conference site is
www.ioug.org/live2002.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-
Here is what worked for me this morning.
+ sqlplus -s
+ 0<<
sys/syss
set pause off feedback off pages 0 echo off
spool CCC_begin_hot_backups.sql
SELECT 'ALTER TABLESPACE ' || TABLESPACE_NAME || ' BEGIN BACKUP;'
FROM DBA_TABLESPACES;
SPOOL OFF
@CCC_begin_hot_backups.sql
EXIT
ALTER TABLESPACE SYST
What is the discount? I saw only $85 discount for IOUG membership.
Alex Hillman
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Karniotis,
> Stephen
> Sent: Thursday, March 07, 2002 9:18 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: No
I work in a dev shop - most of the sql is canned and pretty basic. We've
been running CBO in all of our dev environments, but we have a few long txns
that just take forever. At the request of some savvy developers, I turned
on RBO, and it brought down execution times dramatically.
I've been ana
Get rid of select from dual! Hah, the next thing you will suggest is that we
convert to the metric system!
Marge: Now, I know you haven't liked some of my past suggestions, like
switching to the metric system --
Abe: The metric system is the tool of the devil! My car gets forty rods to
the hogshe
Kirti,
what's the IOUG web address ?
thanks
Santi
-Original Message-
Sent: Thursday, March 07, 2002 10:35 AM
To: Multiple recipients of list ORACLE-L
It will be at the IOUG web site...
If not already there yet, just like all other presentations.
- Kirti
-Original Message-
One other thought is that RMAN doesn't back up oracle passwd files, init.ora file,
oracle home files, etc. Also, RMAN does not back up redo logs.
>>> [EMAIL PROTECTED] 03/07/02 01:03PM >>>
I will put some comments inline:
HTH,
Ruth
- Original Message -
To: "Multiple recipients of list
Thanks for the summary. I prefer option 3. One advantage I see is upgrade migrations
of databases. For example:
1) You have many 8.1.7 databases that need to be upgraded.
2) You have 1 rman db for 8.1.7 and a sep. schema for each db.
3) You create a new rman db for 9.0.1.
4) As you upgrade e
> I understand the need for isolation.
Sounds like a problem with social skills. :-)
This could be symptomatic of TOO much contact with duhvelopers and
damagement. ;-)
-Original Message-
Sent: Thursday, March 07, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L
Importance: High
Step 7 & 8 has always generated difference of opinions :-). And you are right, I
forgot to mention step 9. Archives are backed up to tape 4x day (10gb/day). Thanks!
Gene
>>> [EMAIL PROTECTED] 03/07/02 01:21PM >>>
I would swap 7) and 8): "backup control file" then "alter system archive log
cu
Sorry about being vague about what I am trying to do, I will try to explain
it better.
We are implementing a GIS system called Arc/Info, thats allows us to
store,manipulate spatially
referenced data, one of the "layers" of information is orthophoto's, these
are rectified aerial
photographs that a
It will be at the IOUG web site...
If not already there yet, just like all other presentations.
- Kirti
-Original Message-
Sent: Thursday, March 07, 2002 11:19 AM
To: Multiple recipients of list ORACLE-L
will that presentation and indeed other "Quick Tips" be out on the net at
some p
> Jared: The benefit is isolation. As much as possible keep the users from
> affecting each other. Performance effects are unavoidable but separate
> tablespaces would keep one user from gobbling up all the available
> disk space. Will definitely have to watch out for the data dictionary
> filling
I will put some comments inline:
HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 07, 2002 11:03 AM
> I asked the LIST to respond to the PROs and CONs of different RMAN catalog
> configuration options - Below is the summ
I would swap 7) and 8): "backup control file" then "alter system archive log
current".
You also didn't mention step 9: copy archived logs onto backup destination
media.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECT
Tracy,
For most applications I see no reason to use MTS, BUT there are a couple of
locations where I do use MTS on 8.1.7 and have had few if any problems. It is
actually a fair performer provided that you set the max_servers parameter rather
generously. In total I find that MTS has one majo
The "the()" operator, which changed to the "table()"
operator in 8.1 takes a single value that has to be
a nested table or varray as its operand.
What you are casting is the single row and single
column that you select from dual, but that single
item is the result of casting a result set into
a
I know this has been mentioned on the list before, but for my sanity check, will this
Hot Backup Method work?
1) Alter system archive log current ; not really needed but can't hurt.
2) Check backup status.
3) Generate datafile listing to be used by step 5.
4) Alter tablespace begin backup ;
5)
It is
my understanding that Shishir is SELECTing a record, viewing it, making a change
to the data and then updating it. Normally, another user can
slip in and update the row, so he wants to make sure that no one else
does.
For
example, in a hotel room reservation system, you would promp
Jack:
It appears that the names server is up and running. Try this:
1. Invoke the namesctl utility from a dos prompt.
2. Type "services" (I think) to see what service names are processed.
3. Type "status" to see the status of the names server.
Thank You
Stephen P. Karniotis
Technical Allian
You can have a PK for your history table(like a sequence number) and add the
PK from another table as normal column for this history table.
There is no need for and Relationship to the history table.
-Original Message-
Sent: Thursday, March 07, 2002 9:13 AM
To: Multiple recipients of list
will that presentation and indeed other "Quick Tips" be out on the net at
some point in the future.
Regards
Lee
-Original Message-
Sent: 07 March 2002 14:13
To: Multiple recipients of list ORACLE-L
How about a seat near the power outlets ?? Then, it will be a fun experiment
for Joe &
Please
correct me if I am wrong, but wouldn't you want
to use the following...
FOR
UPDATE NOWAIT
if the
row is being updated/locked, you can report that to the user, and re-query
the data to ensure they still want to update it. Otherwise, with just FOR
UPDATE, the first update gets ov
Since
there are so many options of Oracle that can be loaded when installing, maybe
there was nothing in the patch for the options that you loaded.
It
could be just what it is saying ... that nothing that you have loaded
has had a fix with this patch.
-Original Message-
The software inventory and the software itself do not
match up - if the software was copied from another
machine or subsequently moved, then this may happen.
hth
connor
--- Harvinder Singh <[EMAIL PROTECTED]>
wrote: > HI,
>
> When we try to apply patch 9.0.1.2.0 on 9.0.1.1.1
> oracle we got er
[EMAIL PROTECTED] wrote:
>Gotta go see that!!
>
>Live demo's. always fun!
>
copies, i need copies. how the heck can i learn if i work for a
bankrupt company that can't afford to either send me, or let me go to it
because for how few people are left.;-)
--
--
Bill "Shrek" Thater
HI,
We have some history tables that are pointing to parent tables.
Parent tables has primary key.
Our developers are saying that we have foreign key from history table to
parent table and we don't need primary key on history table.
Does there are any benefits if we have primary key(concatenated)
I will share one example of where a lot of small datafiles come in handy. I
have a script that clones a database. Basically you supply a list of
volumes on the target server that are available for datafiles and it will
cycle through and decide where there is enough room for the file. If you
hav
Hi Shishir,
This is oracle's default behaviour. As you update , insert or delete a row
oracle places a lock at the row level.
John HOugh
[EMAIL PROTECTED] wrote:
HI list!
I want to lock a table on row level
( not table level) . how do we pass the pass that value in syntax whic
Hi,
I was wondering why Oracle force minextents for rollback
segments to be two. Why can't we have minextents zero or
no minextents clause at all.
We can surely set initial extent to be large enough ourselves
and next extent sized accordingly.
Can someone enlighten me on the reason/thought b
Title: Message
Sent 2 hrs ago
- didn't get it yet, resending.
I'm looking for a solution to attach to a
database and create a visual representation of the tables, columns and foreign
keys. I'd prefer something that's free or try to buy - anyone have any
suggestions? (I tried something f
I'm using CASEstudio.
http://www.casestudio.com/rksoft/download/rkscase2.zip
Cool soft, but it runs only on windows :-(
JP
On Thu 7. March 2002 16:03, you wrote:
> I'm looking for a solution to attach to a database and create a visual
> representation of the tables, columns and foreign keys. I
We are testing Fine-Grained Access Control to export the complete schema
excluding some tables.
This works well for export but during import it try to import all tables.
Is there any way we can restrict import of some tables using Fine-Grained
Access Control
.We are using function as specified in
It works great unless client connections use JDBC thin. There is a bug
that causes them to appear hung due to unacceptable SLOOO response.
Supposedly the bug was fixed in 8.1.5.2 & 8.1.6.3, but we still
experienced problems as of 8.1.7.0. Haven't tested this under 8.1.7.2
or 8.1.7.3.
Tra
Does your tnsnames.ora have SID or SERVICE_NAME for CONNECT_DATA? It
should be SERVICE_NAME.
Peter Barnett wrote:
>
> We are attempting to install SQLNet in a failover
> configuration. The environment consists of two AIX
> servers with version 4.3.3 OS, Oracle 8.1.7.2 on both
> servers. Thes
I asked the LIST to respond to the PROs and CONs of different RMAN catalog
configuration options - Below is the summary of the discussion.
By getting a good picture of the different configuration options and what
their PRO's and CON's are - I will be able to choose the best setup for my
situation.
1 - 100 of 135 matches
Mail list logo
