Can you tell us a bit more about this requirement?
Does this data need to be loaded into the database?
Or captured from (as in extracted) from the database?
- Kirti
-Original Message-
Sent: Wednesday, March 19, 2003 5:54 AM
To: Multiple recipients of list ORACLE-L
Hello list,
I
The 'create table foobar (foo number) tablespace special_tablespace;' syntax would do
it.
Check the SQL Reference Guide for more info.
- Kirti
-Original Message-
Sent: Wednesday, March 19, 2003 5:54 AM
To: Multiple recipients of list ORACLE-L
Hallo,
anyone who knows how to force a t
sqlldr username/[EMAIL PROTECTED] control=controlfilename
I do it all the time
sqlnet works for all Oracle utilities (sqlldr, exp, imp)
--- [EMAIL PROTECTED] wrote:
> Hi All,
>
>
>
Title: Gather_system_stats
Hi everyone
I was trying to migrate one of our applications to 9.2 and put in cost at the same time
I came across Gather_system_stats and was wondering if anyone had used it?
Did it improve the executions plan choice at all?
Thanks
David Hill
DBA
We have met just your requirement using Visio Professional. Easy, minimal
learning curve. But it is not a case tool. In passing, we also use the
Oracle tool for design work. And it is a significant learning curve.
peter
edinburgh
> -Original Message-
> From: IT - Database (Do Not Use)
>
create table ( ) tablespace ;
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003 6:54 AM
To: Multiple recipients of list ORACLE-L
Hallo,
anyone who knows how to force a table to use a special tablespace?
Thanks in advance.
Roland
--
Please see the official ORA
No. It is not similar to a rowid.
It is just a pseudo sequential number assigned to the rows in the result set (after
the result set is prepared) from the query.
- Kirti
-Original Message-
Sent: Wednesday, March 19, 2003 3:44 AM
To: Multiple recipients of list ORACLE-L
Hello list,
Santosh,
As one who has written a pile of these, you've left out a lot of details.
The first question I would have is where is the data coming from and how is it
being written. If the data is flat ASCII text, and is from a batch process
SQL*Loader or an external table (9i V2) would be approp
Menon
Do you mean tuning Unix itself or Oracle on Unix? Which Unix?
The only book for tuning Oracle on Unix that I am aware of is Oracle and
Unix Performance Tuning by Ahmed Alomari. I have difficulty reading it, but
others on the list whom I respect have recommended it highly.
Dennis Willia
You are trying to insert a row that contains values that already exist in
the table, and there is a constraint on the table that says the values for
the row(s) must be unique.
Now about that column BONGID ... What are you smoking?
> -Original Message-
>
> Hallo,
>
> I get this errorme
Should not be a problem:
sqlldr control= data=
userid=/@remote_machine
where "remote_machine" is an entry in your local/client tnsnames file.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, Ma
Jack
I did a quick search on Google and this seems to be related to using RAC.
Do you have that implemented?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, March 19, 2003 8:14 AM
To: Multiple recipients of list ORACLE-L
H
Roland,
Don't know if I understand you correctly, my english is not good, but
what if you specify the tbs to use at the moment of the creation of the
table
CREATE TABLE mitabla
( CODE NUMBER(4))
TABLESPACE mitbs
Suerte
Ramon
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesda
[/begin rant]
We ran into a bit of a puzzle here.
It started innocently enough, with someone asking whether Oracle tablespaces
that are largely empty are really being compressed before they are written
to tape.
We use Veritas Enterprise NetBackup with a StorageTek tape silo. Our
backups are done
Darrell Landrum,ÄúºÃ£¡
thanx for your explaination.
I wonder :whether i can judge the select return.
I find the rowNUM is not 0, is right?
=== 2003-03-19 05:03:00 ÄúÔÚÀ´ÐÅÖÐдµÀ£º===
>Santosh,
>
>Good question. Actually these 2 are not related.
>Rowid is an actual attribute
There was an issue in 9.0.1.0 with BLOB and ASSM feature. It was rectified in 9.0.1.2.
Are you sure the Oracle version is *exactly* the same? And that the machine B, is not
missing any Oracle patches applied to machine A?
- Kirti
-Original Message-
Sent: Wednesday, March 19, 2003 5:2
Hi All,
Anybody knows what this wait event is casued by??
TIA
Jacob A. van Zanen
Oracle DBA
Quant Systems Europe b.v.
Tel : +31 (0) 251 - 268 268
Mobile: +31 (0) 6 51308813
Fax: +31 (0) 251 - 268 269
E-mail: mailto:[EMAIL PROTECTED]
Visit our web site at http://www.quantsystems.nl/
--
P
Dice had a job somewhere in Ohio yesterday.
--- Kevin Lange <[EMAIL PROTECTED]> wrote:
> I hear the job of Prime Minister in England will
> probably be open soon. Any
> political ambitions ?
>
> -Original Message-
> Sent: Tuesday, March 18, 2003 12:09 PM
> To: Multiple recipients of lis
create table tablespace ;
babu
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, March 19, 2003 6:53 AM
> Hallo,
>
> anyone who knows how to force a table to use a special tablespace?
>
> Thanks in advance.
>
> Roland
>
>
> --
Prem
(B What do you mean by "fixing" the size? Is it broke? In your earlier
(Bmessage you mention the sizes that Oracle recommends for the extent sizes,
(Bso I assume that isn't what you mean.
(B
(BDennis Williams
(BDBA, 40%OCP, 100% DBA
(BLifetouch, Inc.
(B[EMAIL PROTECTED]
(B
(B
(B-
Any recommendations on a good UNIX o/s more specifically focusing on tuning scenarios and examples.
Thanks
Menon
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
no,
rownum is a sequential number whereas rowid
is a pointer to the row of the table within the database.
-Original
Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On
Behalf Of Santosh VarmaSent: Wednesday, March 19, 2003 4:44
AMTo: Multiple recipients of list
Title: RE: ERWIN vs Designer
Check out Total Access Analyzer at
http://www.fmsinc.com/Products/access.asp
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: IT - Database (Do Not Use) [SMTP:[EMAIL PROTECTED]
I h
Hi Roland,
What do you mean by special tablespace?
When a segment is created (table or partition) you can specify a particular tablespace.
Let us know if more information is needed,
Darrell
>>> [EMAIL PROTECTED] 03/19/03 05:53AM >>>
Hallo,
anyone who knows how to force a table to use a specia
do like this example:
CREATE TABLE TABLE_NAME
(COL1 TYPE1,
COL2 TYPE2,
...
)
PCTFREE 10 PCTUSED 40
INITRANS 1 MAXTRANS 255
TABLESPACE TABLE_SPACE_NAME
STORAGE (INITIAL 20K NEXT 372K PCTINCREASE 50
MINEXTENTS 1 MAXEXTENTS 249 );
-Message d'origine-
De : [EMA
Hi All,
Santosh,
Good question. Actually these 2 are not related.
Rowid is an actual attribute assigned to each row of a table and is unique.
Rownum is logically assigned to rows returned in a query (nothing to do with the
table). It is assigned sequentially as rows are returned (meaning if you can't h
Hallo,
anyone who knows how to force a table to use a special tablespace?
Thanks in advance.
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
just do
select rownum, col1,col2, from
table1
-Message d'origine-De : Santosh Varma
[mailto:[EMAIL PROTECTED]Envoyé : mercredi 19 mars 2003
09:44À : Multiple recipients of list
ORACLE-LObjet : Rownum
Hello list,
I wanted to know
the concept of Rownum..
Hello list,
I am in a project
where the client wants a data capture program without any validation in any
fields..
the back-end is Oracle 8.1.7. what is the
best way to give the user the data capture program ?
please provide me any solution as soon as
possible.
Thanks and
regards
Funny this came up. I had just finished doing research on this for a
potential 9iRAC implemenation.
What I came up with from reading the docs and from experimentation is to
keep the number of extents of each table and each indexes to less than 1024.
1024 seemed to be a majic number. Performance dr
Guys,
CREATE TABLE "NAO"."MSG" (
"MEMNO" NUMBER(10, 0),
"PROFNO" NUMBER(10, 0),
"NAME" VARCHAR2(20),
"AGE" VARCHAR2(10),
"SEX" NUMBER(1, 0),
"JANLNO" NUMBER(5, 0),
"SUBJECT" VARCHAR2(50),
"CONTENT" VARCHAR2(500),
"DELFLAG" NUMBER(1, 0) DEFAULT 0,
"POSTDATE" DATE DEFAULT SYSDATE,
"EXPDAT
Thanks Mogens.
but any "thumb of rule" to fix the UNIFORM SIZE in LMTs.
how do u go about fixing the size ?!
Regards,
Jp.
2003/03/19 18:15:52, Mogens N?rgaard <[EMAIL PROTECTED]> wrote:
>Go to LMT asap. Whether you want to use uniform sized extents in LMTs or
>system managed (or whatever it's ca
Commit;
Mogens Nørgaard wrote:
Money, sex and power. No exceptions to my knowledge (read: so far in
my life).
Connor McDonald wrote:
Stepping back into reality briefly:
With great power comes great licensing fees, great
amounts of advertising literature, great
Am Mit, 2003-03-19 um 09.23 schrieb Sinardy Xing:
> Hi Pomin,
>
> This is syntax error, why don't you check your create database syntax
> including init.ora file and system environment variable.
>
> Just my speculation.
>
> Sinardy
>
>
> -Original Message-
> From:
Hello list,
I wanted to know
the concept of Rownum.. Is it similar to Row Id ?
Thanks and Regards,
Santosh
Go to LMT asap. Whether you want to use uniform sized extents in LMTs or
system managed (or whatever it's called) is a matter of dispute. My
personal opinion is for uniformed sizing.
Mogens
Prem Khanna J wrote:
>Guys,
>
>The paper "How to stop defragmenting and start living" has
>some SAFE rule
Treat dictionary managed tablespaces as being
obsolete. Use LMT's for everything.
On an unrelated note, if you can, go for 9.2 not 9.0,
its streets ahead.
hth
connor
--- Prem Khanna J <[EMAIL PROTECTED]> wrote: > Guys,
>
> The paper "How to stop defragmenting and start
> living" has
> some S
Am Die, 2003-03-18 um 15.58 schrieb Schwerdtfeger, Christoph:
> Am Mon, 2003-03-17 um 18.32 schrieb Ray Stell:
> > On Mon, Mar 17, 2003 at 07:03:43AM -0800, Joe Johnson wrote:
> > > Hi,
> > >
> > > This site has a good description of how to use the ipcs and ipcrm commands to
> > > clean up these l
Hallo,
I get this errormessage while inserting to this table. How can I check this constraint
problem? Any wrong with the table definition
9.03.2003 09:46:38 Db_Transfil.AVSTEM -> ORA-2: db_filtype_ik.AVS
TEM: -> ORA-2: db_filtype_ik:OVERFOR_TIL_KUN:
Hi All,
Apologies if this question is naive.
How to restrict the size of a BLOB column? I mean the column is defined as
BLOB, and I want data not more than lets say 100KB to be in it, how to
achieve this?
Regards,
Naveen
DISCLAIMER:
This message (including attachment if any) is confidential a
Hi Pomin,
This is syntax error, why don't
you check your create database syntax including init.ora file and system
environment variable.
Just my
speculation.
Sinardy
-Original Message-From: pomin
[mailto:[EMAIL PROTECTED]Sent: 19 March 2003 09:49To:
Multiple recipie
Guys,
The paper "How to stop defragmenting and start living" has
some SAFE rules for extent management in dictionary
managed tablespaces (in oracle 8 and 8i) as below:
--
Segments smaller than 128M should be placed in 128K exte
101 - 143 of 143 matches
Mail list logo