RE: How to select data from a LONG datatype

I hope the question is pertaining to using long column in where clause. Try this - declare cursor c0 is select view_name,text from user_views; Cview_name varchar2(30); Ltextlong; begin open c0; loop fetch c0

RE: Backup script giving error when run by cron

Manivannan, I would still put into your script (shutdown.sh) alongwith your ORACLE_SID variable etc. the following lines. ORACLE_HOME=/absolute_path_name_of Oracle_home export ORACLE_HOME PATH=$PATH:$ORACLE_HOME/bin export PATH Give it a try !! Lee -Original Message- Sent: 20 July

Re: procedure error

You need in the stored procedure this stmt: pragma restrict_references (name of function, WNDS [, WNPS] [, RNDS] [, RNPS]); where: WNDS means writes no database state (does not modify database tables) WNPS means writes no package state (does not change the values of packaged variables) RNDS

Upgrading from 10.7 to 11.x

Hi All, What are the pre-requisites to be taken , when upgrading from Oracle applications 10.7sc to 11.x. suggest some points or links (url's) pl. Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City

Re: RE: Backup script giving error when run by cron - Solved

Hi list, Lee's suggestion worked... Thanks to all the guys who gave suggestions. regards, Manivannan Muthukrishnan. Enjoy being an Indyan at http://www.indya.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services

Fw: Upgrading from 10.7 to 11.x

Hi All, What are the pre-requisites to be taken , when upgrading from Oracle applications 10.7sc to 11.x. suggest some points or links (url's) pl. Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED]

Re: Error conecting by svrmgrl

For deleting a services: first, just in case, you should export the registry, then erase the entry related with the name of the service from HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/ About your problem, why don't you set the ORACLE_SID on the HOME of the version you are using and

RE: Solaris 8 Question

If it's / or /tmp, then yes, your machine could well become unusable until it gets some free space. If your archive log disk fills, Oracle will refuse transactions until there is free space. Read the man page for 'quota' to help you limit the possibility of this. And think about switching

RE: Another programming standard falls

See, I don't get it. Microsoft bundle a bunch of stuff with their OS, and the anti-MS camp complain about Microsoft's so-called monopoly (or monopolistic practices, which aren't the same thing). And then Microsoft don't bundle some stuff with their OS, and the exact same people start complaining

Re: [Q] does Personal ORACLE 8.1.7 support Win98?

the problem are: 1. it did not create DB. 2. no "lsnrctl.exe" Thanks. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: [Q] does Personal ORACLE 8.1.7 support Win98? Date: Thu, 19 Jul 2001 05:40:43 -0800 Yes it is.

how to make PL/SQL wait for 60 seconds

I want to put a sleep or wait in my PL/SQL function Is there an easy way to do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Quest s/w

Well, we use Toad - great - and SQLab Vision - not so great - the version we got on CD didn't cover 8.1.7 so we had to download the latest version; it still doesn't really understand 'new' features like function-based indexes; it has a tendency to fall over on really serious SQL; and the 'advice'

pls help..

hi list, can anyone pls explain it. i've found a datafile related to a new tablespace TABSPACE_2 ( not created by me) in v$datafile view. the path of datafile is also ambiguous.. i.e. something like.. DISKA:TABSPACE_FILE2.DAT no full path is shown.. and also i could'nt find the file on

Re: Locally managed tablespaces

consider this also.. if u make a tablespace as LMT, the SMON process is not going to coalesce it automatically.. as it in the case of dictionary managed TS. if i'm wrong.. pls correct. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message

RE: some thing strange with user_tables vs real table

or even on 7.X or 8.X if you are logged as the owner: rename old table to new table --- Mark Leith [EMAIL PROTECTED] wrote: Just a note - SQLServer 7 also uses this extremley poor feature! The easiest way to get around it - if you are on 8i - is just to: alter table table_name

Re: Locally managed tablespaces

That's kind of the point -- in an LMT the free space is managed by bitmap. If it's contiguous in the bitmap it's contiguous, so if you free two adjacent blocks then they're already coalesced, nothing for SMON to do. That's their advantage -- no overhead for coalesce and no overhead for creating

Re: pls help..

It sounds like someone made a datafile on a raw disk. [EMAIL PROTECTED] 07/20/01 08:46AM hi list, can anyone pls explain it. i've found a datafile related to a new tablespace TABSPACE_2 ( not created by me) in v$datafile view. the path of datafile is also ambiguous.. i.e. something like..

Re: how to make PL/SQL wait for 60 seconds

The following code would sleep for 60 seconds. declare val number; begin val := 60; DBMS_LOCK.sleep(t); end; [EMAIL PROTECTED] 07/20/01 08:46AM I want to put a sleep or wait in my PL/SQL function Is there an easy way to do this? John -- Please see the official ORACLE-L FAQ:

Re[2]:re: [Questions about Oracle World Wide Support] / Re:

Rachel, Wasn't talking about you. Let's just say it's a Financial firm with offices in Merrimack NH. Almost went to work for them, glad I did not!! Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 7/19/2001 1:55

urgent pls...PL/SQL problem..

hi list, i'm conerting my old db structure into a new one with entirely different constraints, references, etc.. the new structure holds many new tables some splitted from old ones with few new columns. and like. now i want to move my old data into this new one. i 'm doing it through

RE: Exp/Imp - suppress screen output?

run the script in background export.sh import.sh -Original Message- Sent: 20 July 2001 14:15 To: Multiple recipients of list ORACLE-L Does anyone know of a way, within Unix, to suppress the screen output from the Export and Import utilities? Thanks! -w

RE: Locally managed tablespaces

It does not need to do it. Also SMON will coalesce only if pctincrease0 and this is not a good idea. Alex Hillman -Original Message- Sent: Friday, July 20, 2001 8:41 AM To: Multiple recipients of list ORACLE-L consider this also.. if u make a tablespace as LMT, the SMON process is not

Re: how to make PL/SQL wait for 60 seconds

use procedure dbms_lock.sleep Gints Plivna John Dunn

Re: how to make PL/SQL wait for 60 seconds

Hi John, SQL desc dbms_lock [snip] PROCEDURE SLEEP Argument Name TypeIn/Out Default? -- --- -- SECONDSNUMBER IN Hope this helps, Paul - Original

RE: Exp/Imp - suppress screen output?

Why 1 /dev/null 2dev/null and not just /dev/null -Original Message- Surendra Sent: Friday, July 20, 2001 10:15 AM To: Multiple recipients of list ORACLE-L use this.. exp usn/pwd all your other parameters 1/dev/null 2dev/null Suren -Original Message- Sent: Friday, July 20,

RE: [Q] does Personal ORACLE 8.1.7 support Win98?

I had the same problem- my Personal Oracle 8.1.7 installation hung up during creation of the test database on Win98. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919)

RE: How to select data from a LONG datatype

Title: RE: How to select data from a LONG datatype Ketan, CONTAINS() is an Intermedia operator and will blow an error if no Intermedia index exists on the column that is indexed. Rodd, unfortunately I think you'll have to resort to PL/SQL. You'd have to split the LONG field into the 32K

RE: Connectivity problems through IIS server.

hi while connecting to oracle thro' ASP, u need to specify the TNSname. as far as i know the tnsname is case sensative(when using with ASP) so plz check the tnsname entry. also check the same with dsn entries.. hope this helps .. thanks and regards ! Shirish Khapre, SE Rolta India Ltd. Off Ph

Long running Analyze

I still don't have a good idea how long an Analyze compute should take on a 35gig database. This is a 7.3.4 database with no activity other than the Analyze. The full Analyze is taking about 9 hours to complete. If I use estimate at 25% on the data and compute on the indexes it takes about 6

Re:RE: Another programming standard falls

Guy, Must be because your in the UK where it has not been front page news like here. The problem with Jave and Sun revolves around MicroSoft creating language extensions for their Visual J++ that would only work on Windows and Internet Explorer. That was why Sun went after MicroSoft since

Re: ora-1031 when connect internal or / as sysdba locally

Check your $ORACLE_HOME/rdbms/audit directory. If it is full, you will get this error, as every time you try to login to svrmgrl connect connect internal, a .aud file is created here. Terry Chuan Zhang wrote: Dear all,I have this problem. When connect internal or connect /as sysdba in

RE: Exp/Imp - suppress screen output?

W, Run the export with 'nohup' and optionally redirecting the 'standard error' and 'standard out' to another file. nohup exp ... or nohup exp ... 21 junk.log In the first case screen output will be redirected (default) to 'nohup.out' file. In the second case it is

Re: [Q] does Personal ORACLE 8.1.7 support Win98?

Search your Personal Oracle CD and look for the readme file. Follow the instructions and it should work fine. The reason I say look at the readme is, I had problems initially and I was able to resolve them through the readme. Hope this helps. Rick -- Please see the official ORACLE-L FAQ:

RE: Quest s/w

and I've worked with StorageXpert and it's great... easy to use, understand and install. And damagement really likes the equalizers -- immediately visual image of what is happening From: Lord, David - CS [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L

RE: how to make PL/SQL wait for 60 seconds

Sounds like you need to be using MS SQL Server, it has plenty of wait functions. Especially random waits. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 20,

RE: Quest s/w

I am not a big fan of Toad, it is expensive and has a bunch of pretty things, but not much pratical. PL/SQL Developer is a great product, much more pratical and a lot cheaper. As low as $50/user compared to $750. The company is great, I have dealt with their support very closely over the last

RE: Exp/Imp - suppress screen output?

1 is standard output 2 is standard error -Original Message- From: Michael E. Cupp, Jr. [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 10:41 AM To: Multiple recipients of list ORACLE-L Subject: RE: Exp/Imp - suppress screen output? Why 1 /dev/null 2dev/null and not just

Re: Locally managed tablespaces

SMON only coalesces tablespaces with a non-zero percent increase. And current philosophy is to make all extents in a tablespace the same size anyway, so coalescing becomes a non-issue. From: Saurabh Sharma [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L

Re: how to make PL/SQL wait for 60 seconds

On Jul 20, 2001 at 04:46:13AM, John Dunn wrote: I want to put a sleep or wait in my PL/SQL function Is there an easy way to do this? dbms_lock procedure sleep(seconds in number); -- Suspend the session for the specified period of time. -- Input parameters: --seconds --

Re: Exp/Imp - suppress screen output?

You can code it like this: exp / tables=mike mike.log 21 output is in mike.log -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Scripts for tuning in 8.1.6

si, todo listo Ramón Estévez *809-565-3121 x 225 * [EMAIL PROTECTED] -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Christopher Spence Enviado el: Thursday, 19 July, 2001 9:22 AM Para: Multiple recipients of list ORACLE-L Asunto: RE: Scripts

RE: Exp/Imp - suppress screen output?

Why 1 /dev/null 2dev/null and not just /dev/null -Original Message- Surendra Sent: Friday, July 20, 2001 10:15 AM To: Multiple recipients of list ORACLE-L use this.. exp usn/pwd all your other parameters 1/dev/null 2dev/null Suren -Original Message- Sent: Friday, July 20,

RE: BaanIVc with Oracle

Raghu, We're on 8.0.6. with BaanIVc4. Baan does support 8i (They don't seem to care much about release numbers. If 8.1 is supported, then 8.1.5, 8.1.6 and 8.1.7 are supported). I haven't heard anything on 9.* yet. But IIRC they were rather late with 8i, so don't expect anything soon.

Extent allocation

Hi All, Is there any way to get Oracle (816) to do round robin extent allocation eg. if a tablespace has 4 data files and each file is on a different disk, can extents be allocated from each file in sequence ? As I understand, Oracle will fill one file and then go onto the next file. Cheers,

RE: Long running Analyze

Title: RE: Long running Analyze Ron, I don't know what your goal is here so my suggestions may be incorrect. Why are you analyzing the entire db? Aren't there any static tables (and associated indexes) that you can omit from the analyze? It will be more analyze statements instead of just

RE: Instance down

Seema, A casual search on Metalink for the quoted error text found an answer as below: Subject: Re : Database crashed with message :CKPT: terminating instance due to error 1110 Can you determine what operation(s) where ongoing at the time of the error? Perhaps changing a tablespace to

lsnrctl options

Where can I find out what syntax options there are for lsnrctl? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: Exp/Imp - suppress screen output?

Michael E. Cupp, Jr. wrote: Why 1 /dev/null 2dev/null and not just /dev/null 1 is stdout and 2 is stderr. you need to redirect both to clear it off the screen. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc[EMAIL PROTECTED]

Re: AutoExtend

One of the alternatives: sys.filext$. You could find the others in sys.dba_data_files, with increment_by, etc... Regards. --- Michael E. Cupp, Jr. [EMAIL PROTECTED] wrote: How can I determine if tablespaces are set up in autoextend? -- Please see the official ORACLE-L FAQ:

RE: Instance down

It could be a hardware (disk) error. Check with the sys admin to see if all your filesystems are ok. -Original Message- Sent: Friday, July 20, 2001 9:01 AM To: Multiple recipients of list ORACLE-L Hi My instance is down and I found the following error message in alert log file

RE: AutoExtend

You mean the datafiles within the tablespaces are set up with autoextend. In version 8, there will be a view sys.filext$ created to show what files are set up with autoextend. View will not exist (or return 0 rows) if none set with autoextend. In version = 8 check column 'autoextensible' in

Update question - a little newbie

Hi, I have several tables in a tablespace. Every real (used) table has a clone table in another tablespace with the same field structure. What I have to do periodically, with example: Real Table: cNumcName -- 1 First 2 Second 3 Third 4

Re: I still can't install Oracle on Linux - help

Hi, Thank you for your help. The problem is I can't download the 1.1.8 Java from www.blackdown.org because every link responds with 'Server not available' or something like this. Can you send it to my e-mail address? ( [EMAIL PROTECTED]) Thank you very much Zsolt Csillag, Hungary At 09:56

Re: lsnrctl options

John Dunn wrote: Where can I find out what syntax options there are for lsnrctl? John lsnrctl help or am i missing something obvious here?;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc[EMAIL PROTECTED]

RE: Instance down due to error 1242

Ora-1242 is a media error, I would check the checkpoint process trace file for other symptons. Also look for other process id's in the trace file. Can you restart the database? I suspect you are going to have to do a restore. I am going to guess you are not in archive log mode due to the error

RE: Exp/Imp - suppress screen output?

Or also 1/dev/null 21 That says direct stdout to /dev/null and make stderr the same as stdout. That's Bourne/Korn shell syntax. csh is different. -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 12:31 PM To: Multiple recipients of

Re: lsnrctl options

Start lsnrctl and then type help that will show you the command that are available. Also from the lsnrctl prompt type the command you have in question and type help. ROR mª¿ªm [EMAIL PROTECTED] 07/20/01 01:07PM Where can I find out what syntax options there are for lsnrctl? John -- Please

RE: Long running Analyze

Lisa, Your 'BECAUSE' is really a practical issue. I was also thinking same way since this issue is being discussed for a week now. In practice, we must know what tables are being changed or having activities like inserts/deletes and make a script(s) for such tables to analyze in parallel from

RE: AutoExtend

Michael, Login as a dba user and execute the following query. select tablespace_name, file_name, autoextensible from dba_data_files order by tablespace_name; You will see either - YES or NO under autoextensible column. Rao [EMAIL PROTECTED] -Original Message- Sent: Friday, July

RE: Instance down

Check bug note: bug 1486630 and Note 1063607.6 for possible causes. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 20, 2001 12:01 PM To: Multiple recipients of

Re: lsnrctl options

type 'lsnrctl' on prompt and then type help and you will see all available option of your version of listener... MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 20 Jul 2001 09:07:50 -0800 Where can I find out what syntax

RE: OT Long running Analyze

Lisa, I'm glad to see that you have traded the lawn mower for the spiced rum... ROR m-¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Instance down

The other error you got, 1110, is also media related. It should be point to the bad file in question. $ oerr ora 1110 01110, 0, data file %s: '%s' // *Cause: Reporting file name for details of another error // *Action: See associated error message $ -Original Message- Sent:

setting DbName in SQL*PLUS

Has anyone ever worked on setting the DbName as the sqlprompt in SQL*PLUS thru glogin.sql? Shailesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yadav, Shailesh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: lsnrctl options

The Net8 Administrators Guide may help some too... From: Mohammad Rafiq [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: lsnrctl options Date: Fri, 20 Jul 2001 09:26:22 -0800 type 'lsnrctl' on prompt and then type help and

WinNT / 8.0.5 / Import anomaly, or is it?

From out of nowhere, I started getting the 'ORA-01658: unable to create INITIAL extent for segment ...' error for only SOME indexes on my index tablespace when doing a simple import. Export was done without compression. I rechecked INITIAL extent sizes and true to my expectations they were small

Re: Extent allocation

On Jul 20, 2001 at 07:50:44AM, Adrian Roe wrote: Hi All, Is there any way to get Oracle (816) to do round robin extent allocation eg. if a tablespace has 4 data files and each file is on a different disk, can extents be allocated from each file in sequence ? As I understand, Oracle will

Re: Long running Analyze

It takes me 1hr for a 10gb data index schema using analyze compute. It takes 3mins for a 270gb blob schema using anayze compute. OS AIX 4.3.3 Oracle 8.1.7 EE. [EMAIL PROTECTED] 07/20/01 10:21AM I still don't have a good idea how long an Analyze compute should take on a 35gig database. This

Moving table with interMedia datatype

Title: Moving table with interMedia datatype Hi - I have a table that contains 1 column with an interMedia datatype (ordsys.ordimage) and a blob column. I want to move the data from the table in our test server to our production server. I don't think an exp and imp will work on these

OT - toxic carpet glue fun, etc / (Fwd) RE: [Questions ...-- Volume 2001, Number 200-- Welcome b

Rachel folks, fyi: --- Forwarded message follows --- ... This is the summer of Win2000 and Developer6i/Oracle8i training I went nomail for vacation a while ago (and then family sick leave when my kids, 3 years and 7 years old, got summer colds/asthma), and didn't go back on the

RE: AutoExtend

You look in the table sys.file$. -Original Message- From: Michael E. Cupp, Jr. [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 11:51 AM To: Multiple recipients of list ORACLE-L Subject: AutoExtend How can I determine if tablespaces are set up in autoextend? -- Please

Re: WinNT / 8.0.5 / Import anomaly, or is it?

The tablespace was fragmented. Restarting the database caused it to coalesce your tablespaces. You could have issued 'alter tablespace mytbs coalesce;' for each tablespace before running the import. Jay [EMAIL PROTECTED] 07/20/01 02:55PM From out of nowhere, I started getting the

RE: Exp/Imp - suppress screen output?

Or 21 /dev/null (One less character to type) -Original Message- Sent: July 20, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Or also 1/dev/null 21 That says direct stdout to /dev/null and make stderr the same as stdout. That's Bourne/Korn shell syntax. csh is

Vulnerability Discovered in OID

Dam the buffers, another overflow! http://otn.oracle.com/deploy/security/pdf/oid_cert_bof.pdf === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

How do I control NEXT parameter in the table....

Hi All, My database report says that for couple of tables (in the same tablespace) The NEXT (storage parameter) is greater than the available space in the tablespace. Actually I have more free space in the tablespace (may be they are not continues). I don't want to add another datafile to the

RE: OT Long running Analyze

Title: RE: OT Long running Analyze Ron, I do those together :) -Original Message- From: Ron Rogers [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT Long running Analyze Lisa, I'm glad to see that you have

sql help --urgent

I have a table with a number column(Col A).I want to display A-1.There could be some negative values in this A-1 column.But I want to display 0 whereever negative value appears.I can use the ROUND(A-1) but this will round the other positive value to the next positve integer which I don't want to

RE: AutoExtend

Select distinct tablespace_name from dba_data_files where autoextensible = 'YES'; Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 20, 2001 11:51 AM To: Multiple

RE: private/public rollbacks

They are the same without using Parallel server. But public ones will auto matically be brought online without specifying in the INIT.ORA Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original

Re: Extent allocation

Adrian, As Vladimir showed in the sql script using the ALTER TABLE ... ALLOCATE EXTENT... works great. I have tablespaces across multiple datafiles and of course they are not used up completely before a table's next will not fit in the free space of the datafile. You have to change the next

RE: Extent allocation

Manual allocation of extents, it is called Oracle Striping. It is generally rarely used and most people tend to use raid to handle it. But is a very plausable techinique, as long as you can keep up with the extent allocation. I don't know of any way that automates this process. Walking on

RE: Extent allocation

Manual allocation of extents, it is called Oracle Striping. It is generally rarely used and most people tend to use raid to handle it. But is a very plausable techinique, as long as you can keep up with the extent allocation. I don't know of any way that automates this process. Walking on

Re: How do I control NEXT parameter in the table....

number 1, make pctincrease 0 number 2. alter table tablename storage(next some other number); joe Uday C Basavaraj wrote: Hi All, My database report says that for couple of tables (in the same tablespace) The NEXT (storage parameter) is greater than the available space in the tablespace.

RE: AutoExtend

Here is a very good script to show you alot about your datafiles. If Max Auto Extend is 0, then autoextend is on. (All due credit to the author of the script, as it is unknown to me). -start script set linesize 132 set pagesize 59 column filename for a55 column tablespace for a15 column cur

Re: sql help --urgent

decode(sign(a), -1, 0, a) Ron Thomas Hypercom, Inc [EMAIL PROTECTED] I'm too sexy for my code. - Awk Sed Fred ravindra@sent

RE: sql help --urgent

select sum(column) where column 0 or try a decode -Original Message- Basavaraja Sent: Friday, July 20, 2001 3:41 PM To: Multiple recipients of list ORACLE-L I have a table with a number column(Col A).I want to display A-1.There could be some negative values in this A-1 column.But I

SDU and TDU in SQL*NET

I have recently run various statspack reports and ult report against my 8.1.6 database. It suggests that I am sending more data on the client side than will fit into one SQL*NET package. I have been looking for documentation and/or samples and have only found:

RE: WinNT / 8.0.5 / Import anomaly, or is it?

I actually did. That didn't help. George -Original Message- Sent: Friday, July 20, 2001 11:34 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] The tablespace was fragmented. Restarting the database caused it to coalesce your tablespaces. You could have issued 'alter tablespace mytbs

Re: How do I control NEXT parameter in the table....

try 'alter tablespace tablespace_name coalesce;'. On Fri, 20 Jul 2001, Uday C Basavaraj wrote: Hi All, My database report says that for couple of tables (in the same tablespace) The NEXT (storage parameter) is greater than the available space in the tablespace. Actually I have more free

SMS and Net8 Client Deployment

Title: SMS and Net8 Client Deployment Any shops out there using SMS to deploy Net8 clients? If so, could you give me the gist of the mechanics? Thanks, Jeff T [EMAIL PROTECTED]

OEM: init, Tuning Pack question ???

Hi all, Me again :-( :-). Thank you all those anwering my previous questions, I made lots of progress! Here are some question/problem I still have :-(: OEM 2.0.4 on NT 4.0, Oracle 815 on Sun 5.6 Tuning Pack Connection Question: I can login to any tool under DBA Managment Pack with no

RE: SDU and TDU in SQL*NET

Here's a sample from tnsnames.ora: . . . yourlabel = (DESCRIPTION = (SDU=1500) (TDU=1500) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = yourhost.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = your_service) (SID = your_ORACLE_SID) ) )

RE: Extent allocation

Jeremiah is right. Depending on the version of the database this is an imaginary problem. I have been using this 'auto round robin' feature since 8.0.6 (HP-UX 32-bit). Just did quite a bit of re-organization involving partitioning a large table and used this auto round robin extent allocation

RE: SDU and TDU in SQL*NET

Title: RE: SDU and TDU in SQL*NET I believe the TDU parameter is now ignored in Net8. Our tests seems to indicate that it's fixed at 32K. Jeff T. [EMAIL PROTECTED] -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 5:23 PM To: Multiple

RE: SDU and TDU in SQL*NET

Kathy, Check out a paper titled SQL*Net PERFORMANCE TUNING UTILIZING UNDERLYING NETWORK PROTOCOL at http://www.fors.com/eoug97/papers/0285.htm It might be of help to you. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From:

RE: SDU and TDU in SQL*NET

Title: RE: SDU and TDU in SQL*NET As I understand, you have to run with SQL*NET of version 2.3 and above. I will let you know what I find out when I get into testing and down the road. Kathy -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED]]Sent: Friday, July 20,

RE: Another programming standard falls

See, I don't get it. Microsoft bundle a bunch of stuff with their OS, and the anti-MS camp complain about Microsoft's so-called monopoly (or monopolistic practices, which aren't the same thing). And then Microsoft don't bundle some stuff with their OS, and the exact same people start

Unix problem HELP me please....!

Hi all, In my Solaris 7 I have . In server site todaydate=`date '. /data/$todaydate/myfile1.tar /data/$todaydate/myfile2.tar Because this file is created daily so I create a softlink to this file (to make the ftp user essayer) $ ln -s /data/$todaydate

RE: AutoExtend

You can use following query to see your tablespace has autoextend on or off. select TABLESPACE_NAME,AUTOEXTENSIBLE from dba_data_files; Regards, Anand. -Original Message- Mladen Sent: Saturday, July 21, 2001 12:41 AM To: Multiple recipients of list ORACLE-L You look in the table

Re: Unix problem HELP me please....!

Sinardy wrote: Hi all, In my Solaris 7 I have . In server site todaydate=`date '. /data/$todaydate/myfile1.tar /data/$todaydate/myfile2.tar Because this file is created daily so I create a softlink to this file (to make the ftp user

  1   2   >