Import/Export table

Hi list. I have 3 tables in a schema and I want to export them to another schema in another database. Any ideeas? Thanks! Iulian ** The information contained in this communication is confidential and may be legally

RE: Datawarehouse Sizes.....informal poll.

I've been bodging my way though setting up a database to hold summary info for 11 million assets with various look-up tables around it, the whole to be refreshed weekly. Its not that big - around 15Gb, it doesn't have a timestamp as the partition key and it does not contain transaction info, but

Upgrade OS from Unix 2.6 to Unix 2.8 for Oracle HRMS Applications

Hi Gurus, I need to update the OS from Unix 2.6 to 2.8 on my database and form servers. We are running Oracle HRMS Applications 11I Version 11.5.1. Has anyone done it before ? Any advice ? Please help. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: Import/Export table

Hi, You can do a USER Level export and import them to another schema. If the names are different you may have to use FROMUSER TOUSER during the import. Oracle Utilities Manual will have more information. Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL

Re: Unix account from PL/SQL ??

Hi Sunny, Thanks for your help. It seems to be the answered for me ;) But I still hit one problem here, I tried to invoke the SQL statement from my package. and when I compile the package, It keeps giving me the error message : PLS-00201: identifier 'SYS.V_$SESSION' must be declared any idea

RE: Import/Export table

Use this. exp scott/tiger tables=(t1,t2,t3) Owner=scott Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -Original Message- Sent: Monday, December 10, 2001 12:35 PM To: Multiple recipients of list ORACLE-L Hi list. I

Re: Unix account from PL/SQL ??

Hi jesse, For no 1, Thanks a million, it works fine For no 2, yes, I saw the sticky bit in the oracle file. is it advisable for us to change the oracle file permission / to turn off the sticky bit ? Would it affect oracle internally ? Thanks for Sunny too, I'm

RE: Import/Export table

You can export the tables in Table level export and then import it to the target database. As suggested by GopalKrishnan, if the names are different you may have to use FROMUSER TOUSER during the import. -Original Message- Gopalakrishnan Sent: Monday, December 10, 2001 2:45 PM To:

RE: Unix account from PL/SQL ??

You can use remote login rlogin and run the shell script which you need to run on the remote Unix machine. You dont have to pass any password while using rlogin command. See the help for rlogin for how to set it up.. -Original Message- Susantio Sent: Monday, December 10, 2001 2:45 PM

RE: Unix account from PL/SQL ??

You can use remote login rlogin and run the shell script which you need to run on the remote Unix machine. You dont have to pass any password while using rlogin command. See the help for rlogin for how to set it up.. -Original Message- Susantio Sent: Monday, December 10, 2001 2:45 PM

RE: Import/Export table

Thanks. Still have another questions. - When importing can I change the original tables name? - I try exp80imp80 and besides the tables I saw that the import tool get the constraints related to those tables. Can I import only the structeuredata of the table without indexes and any other objects

FW: DANP

All, Oracle 8.0.5.0.0 on Tru64 Unix v4.0f Anyone seen anything like this before ?? I've never seen a negative number before. I'm assuming its a bug/feature Regards Lee TSPACE RBS STATUSINITK NEXTK SIZEK OPTK HWMK MINX NUMXMAXX SHRINAVACTK --

Re: Import/Export table

Yes, you can import without constraints / indexes. exp80 help=y, imp80 help=y will give you a list of the valid command-line options for export and import. [EMAIL PROTECTED] wrote: Thanks. Still have another questions. - When importing can I change the original tables name? - I try

Oracle Designer Connection with server

Hi List, I am in a problem, not being able to connect from designer/developer to the oracle db. Environment PlatformWindows NT 4.0 Service Pack 6a - standalone server DBOracle 8.1.6 EE Designer6i Developer 6i As suggested in the release notes of Designer, I have first installed the Designer in

Re: DANP

Hi Lee, if my memory serves me right it's somehow connected with db_block_size (a bug I suppose). Your db_block_size is less than 8K isn't it? Regards, Ed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 10, 2001 2:55 PM All,

RE: DANP

Thanks for the reply Ed, but my db_block_size is 8k. Regards Lee -Original Message- Sent: 10 December 2001 12:40 To: Multiple recipients of list ORACLE-L Hi Lee, if my memory serves me right it's somehow connected with db_block_size (a bug I suppose). Your db_block_size is less than

Installing dual versions of Oracle on Win2K

I'm going to be installing Oracle 7.3.4 and 8.1.6 on the same Win2K server shortly. The 7.3.4 is so that we have an accurate version of the old database which is being migrated to 8.1.6 (which explains the 8.1.6). I'll be putting them in different ORACLE_HOMEs and installing 7.3.4 before 8.1.6.

RE: Cannot Drop Column

Is this in a DBA table? If so, which one? Thanks, Ken -Original Message- Sent: Sunday, December 09, 2001 11:40 PM To: Multiple recipients of list ORACLE-L Subject:Re: Cannot Drop Column Did you check COMPATIBLE ? What is it set to ?

tablespace in backup mode

Which table/view do I query to determine if any tablespace has been left in hot backup mode? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 6041 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Rose are

Init.ora Compabible Setting

My init.ora compatible is set to 8.1.0. Is this correct for 8.1.7? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network

RE: Cannot Drop Column

I checked compatible in init.ora and it is set to 8.1.0. Ken -Original Message- Sent: Sunday, December 09, 2001 11:40 PM To: Multiple recipients of list ORACLE-L Subject:Re: Cannot Drop Column Did you check COMPATIBLE ? What is it set to ?

RE: Datawarehouse Sizes.....informal poll.

Dennis, Thanks for the thoughts, the historical snapshot, and for paying attention to the question. I am on the DW list now, and will newby-ize them straight away. - Ross -Original Message- Sent: Friday, December 07, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Ross -

RE: RE: Where is the memory gone?

Only thing I have to add here is that I was not using MTS so which ever bug I was hitting (doco is at the office) it was not related to that. -Original Message- Sent: Sunday, December 09, 2001 9:50 PM To: Multiple recipients of list ORACLE-L WinterSun, Hmm, this doesn't sound like

RE: Init.ora Compabible Setting

Ken, If you set the compatible to 817, then, you would be able to take advantage of 817 version. Or, if you have some software which is compatible with 8.1.0, then, it is better to leave like that. I personally prefer setting it to 817. Rao -Original Message- Sent: Monday, December

RE: Import/Export table

Use the fromuser touser parameters. Better yet, read a manual. -Original Message- [EMAIL PROTECTED] Sent: Monday, December 10, 2001 12:35 AM To: Multiple recipients of list ORACLE-L Hi list. I have 3 tables in a schema and I want to export them to another schema in another database.

Re: Installing dual versions of Oracle on Win2K

I'm sure someone has done this, BUT, 7.3.4 is NOT supported on Win2k. John [EMAIL PROTECTED] wrote: I'm going to be installing Oracle 7.3.4 and 8.1.6 on the same Win2K server shortly. The 7.3.4 is so that we have an accurate version of the old database which is being migrated to 8.1.6

RE: tablespace in backup mode

Title: RE: tablespace in backup mode Charlie Select status from V$backup. If status = 'ACTIVE' then tablespace in hot backup mode HTH John -Original Message- From: Charlie Mengler [mailto:[EMAIL PROTECTED]] Sent: 10 December 2001 14:26 To: Multiple recipients of list ORACLE-L

Re: tablespace in backup mode

Check V$BACKUP view, and look at the status column. This tells if the files of the tbs were left in hot backup mode. Susan - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 10, 2001 10:25 AM Which table/view do I query to determine

RE: DANP

Thanks Ed, I just got this from MetaLink, looks like you were spot on. A quick check showed me that the offending RBS was more than 2Gb. Cheers Lee Doc ID: Note:100292.1 Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 28-FEB-2000 Last Revision Date:

RE: tablespace in backup mode

This should do the trick select d.file#, t.name,b.status from v$datafile d,v$tablespace t, v$backup b where d.ts# = t.ts# and d.file# = b.file# and b.status = 'ACTIVE' Regards Lee -Original Message- Sent: 10 December 2001 14:26 To: Multiple recipients of list ORACLE-L Which

RE: tablespace in backup mode

Title: RE: tablespace in backup mode check the STATUS column in v$backup Matt Adams - GE Appliances - [EMAIL PROTECTED] If C gives you engouth rope to hang yourself, then C++ gives you enough rope to hang yourself, your dog, your co-workers, and everyone in your neighborhood.

Re: DANP

Sorry Lee, I made a mistake. I was looking through russian confs. It seems it appears when size of your rollback segment is more than 2Gb. Regards, Ed Thanks for the reply Ed, but my db_block_size is 8k. Regards Lee Hi Lee, if my memory serves me right it's somehow connected with

Parallel export by datafile/extent

Hello all, I'm trying to generate a script that generates many export parameter files, each one of which would export a subsection of a table based on it's datafile. I think this is possible using sql-extended query export and rowid ranges. The idea of course is to then kick off each of

RE: Installing dual versions of Oracle on Win2K

Other than 7.3.4 isn't supported for Windows 2000. I have ran into issues where imports and exports take FOREVER...and when I say forever, I do mean it. I had one export that was approx 350meg, take about 13 hours. I have also ran into DLL issues with C++ programs as well. thanks, C-

RE: tablespace in backup mode

Charlie, Select * from v$backup; If any tablespace is left in backup mode, then, you would see --- ACTIVE --- under the column status. Rao -Original Message- Sent: Monday, December 10, 2001 9:26 AM To: Multiple recipients of list ORACLE-L Which table/view do I query to determine if

RE: RE: Where is the memory gone?

Answering your first message about the shrink of free space in shared pool. Check the parsing ratio: The hard parse with something like this SELECT substr(sql_text,1,40) SQL, count(*) , sum(executions) TotExecs FROM v$sqlarea WHERE

truncate or drop

Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED]

KSH Scripting Questions

I have a kshell script that I am trying to perform an oracle operation. Everything works fine in the script excpet cleanup. One section of the script spools off a monitor job that watches the script for any failures by use of flag files and file checking. This all works well UNTIL the main

RE: truncate or drop

do you like the existing placement and storage clauses of the tables? -Original Message- Sent: Monday, December 10, 2001 11:40 AM To: Multiple recipients of list ORACLE-L Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is

RE: truncate or drop

Ruth: I would think you would want to truncate which deletes all the data and resets the high water mark. Dropping the tables? I think this destroys the table? Then you have to recreate all the tables from a DDL SQL script. Ken -Original Message- Sent: Monday, December 10, 2001

RE: KSH Scripting Questions

wait ? -Original Message- Sent: Monday, December 10, 2001 11:55 AM To: Multiple recipients of list ORACLE-L I have a kshell script that I am trying to perform an oracle operation. Everything works fine in the script excpet cleanup. One section of the script spools off a monitor job

Re: truncate or drop

Both could be slowly if tables have many extents and you use extent management dictionary. However I think drop would be a little more expensive considering that not only it has to erase info from uet$ and fet$, also from basically c_obj# and others clusters. Regards. --- Ruth Gramolini

RE: truncate or drop

Title: RE: truncate or drop Truncate and then drop empty tables. -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 10:40 AM To: Multiple recipients of list ORACLE-L Subject: truncate or drop Hi Everyone! I am trying to empty a

Re: ugly sql contest entry / Re: ORACLE-L Digest -- Volume 2001, Number 333

Heh! :( just trying to get the ball rolling! regards, ep On 7 Dec 2001, at 17:18, [EMAIL PROTECTED] wrote: Is that the best you can do? ;) I recall something from the list many years ago where a poster was asking for help with a SQL statement that was unbelievably long. If I

exp/imp unable to create unix index

Hi gurus I had oracle1452 when imp/exp database from test to prod databases. I have no idea why but found out from both imp and exp log that record exp/imp is the same while unique index still exist in test database exporting tablePA_PROJECTS_ALL 3160 rows exported

RE: truncate or drop

Title: RE: truncate or drop If they have thousands of extents... it might be better to truncate first, then drop. I've seen it take up to 4-5 hours to drop a table with thousands of extents (not my database... but a clients.) :) If you are going to rebuild entire datafiles/tablespaces... it

RE: KSH Scripting Questions

Kevin -- Is your program supposed to find all the monitors it starts and kill them cleanly, or are the monitors supposed to run independently once kicked off? IF YOU WANT TO KILL THE PROCESSES CLEANLY, your process when you are running the job is $$. You can grep the processes for any

Re: Unix account from PL/SQL ??

You must login as sys and grant select on v_$session to PACKAGE_OWNER; Please take a look at www.orafaq.com as it will answer all of the questions you've asked. Jared

RE: truncate or drop

In my view a Truncate is always faster than a Drop. Also, the original table structures of the table r preserved. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418

AW: ORA-12545 WHEN CREATING A NEW DATABASE

Title: Nachricht Hi Bunyamin, let dbassistant create scripts for your database. Then edit your listener.ora and tnsnames.ora and add entries for your new instance. After this edit db create scripts and instead of "connect internal" write "connect

RE: KSH Scripting Questions

put wait in main. then cleanup. sorry for the wordy reply. ;-) -Original Message- Sent: Monday, December 10, 2001 12:35 PM To: Multiple recipients of list ORACLE-L Kevin -- Is your program supposed to find all the monitors it starts and kill them cleanly, or are the monitors

1 1 ??? Strange problem

Hi, I have noticed this strange error with two different database: 8i and 9i. We have a cgi that worked well under 8i but not under 9i. The problem was here : If MyString = '' Then Return xxx End If ; It never went in. I tried the following : If 'string' = 'string' Then -- never

Re: KSH Scripting Questions

I use this in one of my scripts. Is this what you are looking for? # Make sure temp file get removed. trap rm -f $file; exit 0 1 2 3 4 5 6 7 8 10 11 12 13 15 16 17 HTH, John [EMAIL PROTECTED] 12/10/01 08:55AM I have a kshell script that I am trying to perform an oracle operation.

AW: exp/imp unable to create unix index

Maybe the tables still exist in Prod and have some data inside. Try to drop tables in prod before importing. HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: mitchell [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 10. Dezember 2001

RE: truncate or drop

everybody is focussing on how quick to destroy without considering what follow on work RBG has to do after the bomb drops. It could be like taking over Kandahar, and leaving warring tribes in control. You'd just be asking for trouble down the road. -Original Message- Sent: Monday,

Re: truncate or drop

Yes, I am doing a truncate...reuse storage and that works very well. Thanks to all! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 10, 2001 12:15 PM do you like the existing placement and storage clauses of the tables?

Re: truncate or drop

Hi, there's an option REUSE STORAGE for TRUNCATE command Regards, Ed Both could be slowly if tables have many extents and you use extent management dictionary. However I think drop would be a little more expensive considering that not only it has to erase info from uet$ and fet$, also

ORA-600

Following 4 documents found for ORA-600 errors on Metalink. Hope this might help someone. Entries found: 4 Showing: 4 Ordered by : Score Direction: Descending 1. ORA-600 Lookup Type: Note Doc ID: 153788.1

Re: 1 1 ??? Strange problem

Perhaps you could post some actual test cases that others could run? Jared Csillag Zsolt

Database link

Hi DBAs I have a problem with database links in one of the databases - the name of the link gets us.oracle.com appended to it. create database link test connect to test_user identified by test_pwd using 'test_db' When I execute: select * from my_table@test I get the ORA-02085 error

RE: truncate or drop

Ruth If you drop the table you would have to create it again and would have to deal with security. If you truncate it, the security applied to the table will remain. Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED]

Re: truncate or drop

Yes, but then remember that it will be necessary a alter table deallocate. Regards. --- Edward Shevtsov [EMAIL PROTECTED] wrote: Hi, there's an option REUSE STORAGE for TRUNCATE command Regards, Ed Both could be slowly if tables have many extents and you use extent management

RE: KSH Scripting Questions

Yes. This should remove the files if any problems occure. Can you call a subprogram in the trap line or does all the code need to be in-line ?? It would be great if I can just call 1 cleanup routine. -Original Message- Sent: Monday, December 10, 2001 12:30 PM To: Multiple recipients

Database down

ORA-27123: unable to attach to shared memory segment SVR4 Error: 12: Not enough space Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Wiegard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: KSH Scripting Questions

The monitors are independent. They are used to verify that rcp/rsh programs work correctly. We have been having troubles where rcp and rsh programs fail on one end and never return with a good or bad return code. We wanted the monitor to tell us if the program did not come back in a

Re: truncate or drop

Hmmm, And I thought they were answering the question :-). I would actually do neither unless for some reason I HAD too. In all of the current versions of oracle I would rebuild rebuild this segment. Best regards, John [EMAIL PROTECTED] wrote: everybody is focussing on how quick to destroy

RE: Database down

I ran into this problem before. oracle had crashed and we could not restart. So , If oracle is truely shut down on that box do an ipcs -m to show all active memory segments. Find the ones owned by oracle and do an ipcrm -M key and remove the shared memory . I did then , then the

Re: truncate or drop

I have a script to recreate the tables, however I have used the truncate, reuse storage command with success. We are moving all of our databases onto new servers. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 10, 2001 2:05 PM

SRTIPE SIZE

Hi, We r planning to use RAID 0 What should be stripe size? . I read a document from oracle site mentioning 1M as optimal stripe size. but our SA expert is saying 128k IS ENOUGH. Our hardware support stripe size from 64k to 1M. Sun I/O size is 64K. Thanks --Harvinder -- Please see the

RE: Retek ERP ORacle

Title: RE: Retek ERP ORacle Yes. Still on 7.3.4. -Original Message- From: MRaval [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 12:10 PM To: Multiple recipients of list ORACLE-L Subject: Retek ERP ORacle Anyone in this forum working with Retek ERP. Thanks. --

Preventing ORA-1403 in triggers

Hi, So a developer asks me How do I prevent ORA-1403 in my SELECT statement in my trigger? I thought this would be simple, but my brain's just not all here. The statement is simple: SELECT description INTO v_desc FROMmytable WHERE indexcol1 = :v_col1

Re: Database down

There is not enough memory on the server to allocate the shared memory that the init.ora requires. Make you shared_pool smaller and try again. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 10, 2001 2:25 PM ORA-27123: unable

RE: KSH Scripting Questions

Yeah, I did that a fair amount, too. It depends on whether you're going to do all your monitoring from your script, or whether you're going to go and fire off a zillion monitors and let them fly on their own. If you're doing it all in the same script, then it becomes easy... for machine in `x y

RE: KSH Scripting Questions

Yes, you can create a function in your program and call it or call another program. my_function () { clean this clean that } trap my_function 0 1 2 ... You can have different cleanup routines for different events or one cleanup routine and pass it the event type as: trap my_function 1 1

RE: Preventing ORA-1403 in triggers

Rich, Well, just what would you like to do if the record does not exist? You could easily trap the error and move on: begin begin notfound := 'N'; SELECT description INTO v_desc FROMmytable WHERE indexcol1 = :v_col1 AND indexcol2 = :v_col2

RE: Preventing ORA-1403 in triggers

IMHO, It is just a matter of catching exceptions in an inner block. This whole lot easier than doing count(*) ... -- initial code -- begin -- inner block begin SELECT description INTO v_desc FROM mytable WHERE indexcol1 = :v_col1 AND indexcol2 =

Re: Database down

Hi Jeff, 1. the previous killed instance that still holds a shared memory segment ? 2. unappropriatedly large parameters of shared_pool and/or db_block_buffers ? Regards, Ed ORA-27123: unable to attach to shared memory segment SVR4 Error: 12: Not enough space Any ideas? -- Please see

Re: Preventing ORA-1403 in triggers

OK, send your developer back to F(ine) M. There are 2 ways: Trap it begin select description into v_desc from my_table where column=this don't exist ; exception when no_data_found then do some thing else end Or use a cursor cursor csr is select description into

RE: KSH Scripting Questions

That is prety much phase 2.Phase 1 is the simplistic view. The archive process program starts , creates a file, starts the monitor ... does the rsh deletes the file. When the monitor starts ... it sleeps a proscribed time ... then checks the file existance. If its there, it sleeps

Re: Database link

Witold, Please check sqlnet.ora, try to comment out NAMES.DEFAULT_DOMAIN entry. Also, you can comment out glocal_dbname= in listener.ora file to see what happens. for example; SID_LIST_LISTENER = (SID_LIST = (SID_DESC = # (GLOBAL_DBNAME= x.world) (ORACLE_HOME=

RE: KSH Scripting Questions

Thanks John. -Original Message- Sent: Monday, December 10, 2001 2:16 PM To: Multiple recipients of list ORACLE-L Yes, you can create a function in your program and call it or call another program. my_function () { clean this clean that } trap my_function 0 1 2 ... You can have

Adding intermedia Text to 8.1.6 database

Hello Can someone point me to documentation how to add intermedia text to a database in Oracle 8.1.6 (on NT)? I installed interMedia and can use in the database created by the setup but would like to add it to another database on the same server. The documentation that I have found at OTN

RE: Database down

ipcs -a ipcrm - etc -Original Message- Sent: Monday, December 10, 2001 3:27 PM To: Multiple recipients of list ORACLE-L Hi Jeff, 1. the previous killed instance that still holds a shared memory segment ? 2. unappropriatedly large parameters of shared_pool and/or db_block_buffers ?

Re: Adding intermedia Text to 8.1.6 database

Hi all I have found my answer... I have seen other people asking on other forums so the answer may help someone some day... On NT the library is: %ORACLE_HOME%\bin\oractxx8.dll Witold Hello Can someone point me to documentation how to add intermedia text to a database in Oracle

Re: Database down

Just to follow up. I have the database backup. I am afraid however, that the problem is still floating around. Briefly, here is what occured: I restarted Oracle because our application was unable to connect. I could connect through svrmgrl, but a 'select sysdate from dual' just hung. So I

RE: KSH Scripting Questions

Topic done. Error found. Some idiot . who will remain nameless if he wants to continue typing this message echo'ed a space to the file after he tested to see if it had been deleted in the monitor program. SO, the main program was deleting the file ... and the montor was recreating it

RE: Database down

I don't suppose you've run ps -ef | grep 29937 yet, just out of curiousity, have you? -Original Message- Just to follow up. I have the database backup. I am afraid however, that the problem is still floating around. Briefly, here is what occured: I restarted Oracle because our

RE: Preventing ORA-1403 in triggers

Thanks guys! I'm thinking that we're going to use the anonymous block local exception idea. Now if they would let me turn this mess into a materialized view, my question would be moot! Thanks again! Rich Jesse System/Database Administrator [EMAIL PROTECTED]

RE: Database down

I discovered the trace file after restarting Oracle - so that process ID is no longer out there. I've also discovered that there is a specific patch for this problem, which appears not to have been applied. I will move forward with this, but would like to provide management with an explanation as

deleting large volumes of data

Dear listers! what would you suggest as the best method for delete from a large table where some rows have to disappear e.g. delete from a partitioned data warehouse table, where the delete transaction would not fit into a rollback segment ? method 1 What do you think of

RE: KSH Scripting Questions

Which one? I want to make sure I'm not living near it ;) Now, where did my doughnut go... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] [EMAIL PROTECTED]

RE: Database down

maybe a mild uptick in resource contention after adding a third app server passed over some internal threshold? shrug -Original Message- Sent: Monday, December 10, 2001 4:50 PM To: Multiple recipients of list ORACLE-L I discovered the trace file after restarting Oracle - so that

shared memory error

Paula: This is pretty ugly. Let's at least see if we can get rid of the cartesian. Barb -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=293 Card=2587 Bytes= 724360) 10 SORT (UNIQUE) (Cost=293 Card=2587 Bytes=724360) 2

IGNORE: shared memory error

Oops! Pasted to the wrong window. So sorry. Barb -- From: Baker, Barbara Sent: Monday, December 10, 2001 3:12 PM To: '[EMAIL PROTECTED]' Subject: shared memory error Paula: This is pretty ugly. Let's at least see if we can get rid of the cartesian. Barb

Help in deciphering the values for flag in systemstate dump

Title: Help in deciphering the values for flag in systemstate dump I'm troubleshooting a discrepancy between v$session_wait and Precise/SQL 3.1. Oracle reports that sessions waiting on SQL*Net message from client but the tool shows some of them in MTS wait. Since Precise/SQL parses the SGA

RE: KSH Scripting Questions

It was down at Comanche Peak Nuclear Station just south of Ft. Worth Texas. -Original Message- Sent: Monday, December 10, 2001 3:58 PM To: Multiple recipients of list ORACLE-L Which one? I want to make sure I'm not living near it ;) Now, where did my doughnut go... Ron Thomas

RE: IGNORE: shared memory error

don't let it happen again, BB, or it's the Caves for you. -Original Message- Oops! Pasted to the wrong window. So sorry. Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

RE: KSH Scripting Questions

Hey Homer, Was that you hawking the Uranium 235 on ebay? Jared Kevin Lange

Re: shared memory error

Maybe you should enter it in Eric P.'s ugly SQL contest? Jared Baker, Barbara

RE: Cannot Drop Column

Apologies if this has already been mentioned. You will need a (free) technet account to access these links. Hope these links didn't wrap. HTH Oracle8i Administrator's Guide Release 2 (8.1.6) Part Number A76956-01 You cannot drop all columns from a table, nor can you drop columns from a

  1   2   >