Updating table2 from table1

Thanks for all your advices to me. How can I write a procedure, that does a selection from table a and then puts that data into table nr 2. In the new fields in table2 I am supposed to put for instance sums from table1 of certain fields. Roland S -- Please see the official ORACLE-L FAQ:

Make a character format from number format

How can I make a character format from a number format in an insert statement? For instance insert into table_name values(10, 1960); where 1960 is supposed to be put in the column, which is in character datatype. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: Locking

Try with this query: select xidusn, object_id, session_id, locked_mode from v$locked_object; If developer created table with bitmap index it can be reason for locking (we had such problem). HTH, Sonja -Original Message- Sent: Tuesday, March 20, 2001 11:27 PM To:

RE: Updating table2 from table1

create table tab_2 AS select col1+col2 COL_ALIAS from tab_1; -- From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Subject: Updating table2 from

Shared pool 'perm' behaviour

Anyone observed this on their platform ? (Observations below are from Sun, v8.1.6 and 8.1.7) Based on various things I've seen on the web, immediately after startup I would expect about half the shared pool to "kept aside" by Oracle (in the 'perm' area) and only released as memory comes under

RE: OT -- A humorous reply to the Canada rulz

That was in fact the Mayan's. The game was a little different, as they played it on a court with two tall walls on either side. The "rings" were situated high up the MIDDLE of each wall, and they were placed vertically instead of horizontally. They would have to try and heave a heavy ball

EMC TimeFinder, and EMC TimeFinder vs Hot Standby

Hi All, Can anyone give me a quick (free!) lesson on the concepts behind timefinder? How does this differ from their standard SRDF which (to my understanding) is to split the mirror and back it up. Or is it that they add their BCV stuff to SRDF so you can access the data while the mirror is

X$BH TABLE

CAN ONYBODY EXPLAIN ME , when ý query x$bh table as a state field , I get 0,1, or 3. What do these values mean? And in the query select decode(state,0, 'FREE', 1, decode(lrba_seq,0,'AVAILABLE','BEING USED'), 3, 'BEING USED', state) "BLOCK STATUS", count(*) from x$bh group by

RE: OT -- A humorous reply to the Canada rulz

The propaganda says in this country that it's a Mr. Nesbitt (?) from New Brunswick, Canada... There rarely are original ideas in the world, maybe basketball is another case of plagiarism. : ) -Original Message- From: Steve Orr Sent: Tuesday, March 20, 2001 6:06 PM To: Multiple

Re: NLS_DATE_FORMAT not effective..help!

Hi, Thanks for the reply. But as far as i tried , it is not possible to set NLS_DATE_FORMAT at instance level (except the entry in init file.) I think by using LOGON we won't be able to achieve setting NLS_DATE_FORMAT for the entire instance (all the sessions) . I remember reading LOGON

RE: OT -- Canada Rules! / Chocolate ...

ummm Should we be afraid to ask, considering the Texas reputation? -Original Message- Sent: Tuesday, March 20, 2001 8:06 PM To: Multiple recipients of list ORACLE-L Yeah, but do you guys have Texas Weiners?? I think not!! Now those are g. - Original Message

RE: NLS_DATE_FORMAT not effective..help!

Try: Alter session set nls_date_format=date_mask; HTH Jorma Hi, Thanks for the reply. But as far as i tried , it is not possible to set NLS_DATE_FORMAT at instance level (except the entry in init file.) I think Martin Kendall wrote: Just create a Database on-logon trigger

Re: Anybody using Network Applicance Storage boxes with

Don't believe sales! They have one objective: to sell sell sell. Check it out http://www.eecostructure.com/ Its a good site on how to set up Oracle environments: network, servers, storage, etc. Gene [EMAIL PROTECTED] 03/20/01 11:30PM I have heard about this Storage box. It can be

RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby

Title: RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby Hi Yosi, how are you? I can't exactly clarify your fish vs. potatoes, er, timefinder vs. SRDF question but I can tell you that we have BCV's implemented here. We use them for backup and recovery (and it's extremely slick and fast,

Re: OT: Rachel in Vietnam

[EMAIL PROTECTED] wrote: Ross, Makes sense, Nam was BUG heaven, unless they got caught in the path of a BUFF bomb run. Nothing survived that. :-) or a visit from puff the magic dragon.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED]

Re: Free Oracle DBA tests on the web

Try http://cramsession.brainbuzz.com/cramsession/oracle/for helpful study guides http://skilldrill.brainbuzz.com/testlist.asp - for Oracle tests http://www.informit.com/for free online books (go to the Free Library) hth, Marin "When someone is seeking, it happens quite easily

Device busy - HELP

Title: Device busy - HELP Hello all, HP/UX 11.0 w/EMC hardware Well my trusty BCV's are BUSY. The script that runs every night executes fuser and kills any processes that may be attached to them. It failed last night due to something I did... well I cleaned it up this morning and I can't

Re: OT: Rachel in Vietnam

[EMAIL PROTECTED] wrote: Bill, That's true, except that Puff was a lot neater about the matter. Less BRUTE force, more like surgery. Heck at least he left the trees and/or stumps standing!! well, sometimes.;-) but it sure was a nice sight to see the jungle kind of "walk" back from

RE: OT -- A humorous reply to the Canada rulz

I'll pick USA vs. Russia, 1980 Olympics. But, of course, nationalistic pride may be biasing me a bit. :) --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Wednesday, March 21, 2001 6:42 AM To: Multiple recipients of list ORACLE-L Great answers, but the greatest hockey

RE: OT: Rachel in Vietnam

Or a visit from one of Puff's successors. As I recall, Arc Lights would be announced on guard frequency 15 minutes before the drop. The position would be announced as a bearing and distance from a classified point. We were flying our gunship one night in the Central Highlands, looking for bad

Re: NLS_DATE_FORMAT not effective..help!

You can set if for the instance or even for the session. RBG - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 6:35 AM Hi, Thanks for the reply. But as far as i tried , it is not possible to set NLS_DATE_FORMAT at

Re: OT: Rachel in Vietnam

They would probably implement a "classified reference point" for it which would still require an iTAR and 3 days of phone and e-mail tag to pinpoint. Now, if Oracle could figure out a way to announce in advance the time and location of an ORA-600 error, I'd be impressed. :) --Walt Weaver

Re: Rachel in Vietnam??

"Carle, William T (Bill), NLCIO" wrote: We all know by now that Rachel wasn't really in Vietnam (way, way too young). But I've seen this subject line so many times by now that it's starting to look like Rachel is hosting her own show on the Travel Channel or something. Maybe we could have a

RE: NLS_DATE_FORMAT not effective..help!

Oh yes you can. Here is the script I run as SYSTEM and it provides a common date format for all logins - UNLESS they override it with a SUBSEQUENT Alter Session or it is defined in their REGISTRY (Windows users). Instead of ON DATABASE, you can also limit it to a particular Schema. Otherwise,

RE: Anybody using Network Appliance Storage boxes with Oracle?

I'll try and share some of what I've been told by the NetApp reps. This info is a year old. The NetApp box itself is a very trimmed down version of BSD that handles only the networking and disk i/o stuff. Specifically compiled to work with their controllers. It talks to both NFS and NT

Re:Anybody using Network Applicance Storage boxes with Oracl

Helmut, We're scheduled to start spinning Net App disks for Oracle on Monday for the first time. Yeah, according to all of the research I've done it does not matter where you logically put datafiles on a Net App as the entire disk array appears as one HUGE drive to the OS. Now it's just

RE: NLS_DATE_FORMAT not effective..help!

The CREATE TRIGGER ... AFTER LOGON ON DATABASE will work on a session by session basis. As each session logs on to the database it will execute the trigger for that user. I currently use it in my database to do a "alter session set current_schema=?" to that I can point different users to

Oracle Version for New Database

All, I am trying to decide on a version of Oracle for a new database that will hold a number of small apps, mainly web apps using apache web server. Last time I set up a database I used 8.1.6.2.1 (this is Solaris 2.6 BTW) and I had no end of problems with incremental snapshots causing "waited

identifying shared memory segments

A while back someone posted a method for determining which shared memory segments belonged to an instance. Can someone repost that and CC me? Thanks.Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.

RE: RMAN Backup and Recovery

Don, You don't state whether or not you're getting the archived redo logs at each Level 0 and 1 backup as well as the 3 archive-logs-only backups. If not, you probably should. Also, if recovery speed will be important, those incremental backups should be cumulative, not differential. However,

Data into another table

How can I create a select statement from table1 including some division or multiplication , and then include the result into table2. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

Re: EMC TimeFinder, and EMC TimeFinder vs Hot Standby

Hi For each physical device a BCV is associated. This is at a physical level rather than at logical level. Timefinder is the product which synchronizes these devices and bcvs. Each of these devices and BCVs has a bit map track table to keep track of the disk tracks. This bit map indicates

RE: Anybody using Network Appliance Storage boxes with Oracle?

We use NetApp for our NFS file servers and they are very fast and reliable. The NetApp sales 'droid also tried to sell us their Oracle solution, as they are one of the few vendors that is certified by Oracle to run the RDBMS over NFS. EMC is also certified by Oracle to run on NFS (or so they

RE: Rachel in Vietnam??

There is a show on a cable TV channel here where the host's job is to go around the best spas in the world to tell us how good they are. Now there's a job! Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original

RE: OT -- Canada Rules! / Chocolate ...

Which (of the many) Texas reputation would that be? I'm not sure if I should be offended or if you have us confused with another state. :) Brian Norrell Manager, MPI Development QuadraMed 511 E John Carpenter Frwy, Su 500 Irving, TX 75062 (972) 831-6600 -Original Message- Sent:

Re: identifying shared memory segments

Me too! Thanks,Ruth B. Gramolini ORACLE DB2 DBA VT Dept. of Taxes ph# 802.828.5708 fax# 802.828..3754 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 10:00 AM A while back someone posted a method for

RE: OT -- A humorous reply to the Canada rulz

Oh everyone always says that game:) I am thinking a little later on, I am afraid I don't remember what year it was, but it was Canada vs Russia. Canada won, reason being, and the reason it was such an amazing game, Gretzky and Lemiux on the same line, GOOD LORD what a show!! -Original

RE: SUN vs. HP

Why should you use OPS if you are using ServiceGuard? We are not here and I have not come up with a single reason to. If you have some I should relook at it. -Original Message- Sent: Tuesday, March 20, 2001 8:17 PM To: Multiple recipients of list ORACLE-L I have been working with

Rachel in Vietnam??

We all know by now that Rachel wasn't really in Vietnam (way, way too young). But I've seen this subject line so many times by now that it's starting to look like Rachel is hosting her own show on the Travel Channel or something. Maybe we could have a thread like Rachel in Hawaii, Rachel in

[ANNOUNCE] Orac-1.2.3.tar.gz Perl/Tk Perl DBI Oracle DBA and Development Tool

Hi Everyone, Richard Sutherland and I are revamping the Orac Perl/Tk Perl DBI program. This now makes liberal use of Richard's DDL-Oracle Perl package (required for Oracle usage) and we're also beginning to make use of Dean Arnold's DBD-Chart Perl package (not required, but if available on your

RE: OT -- Canada Rules! / Chocolate ...

Hum, a few thoughts went though my head there. I hear a lot about Texans and size Forget it, its early. -Original Message- Sent: Tuesday, March 20, 2001 5:06 PM To: Multiple recipients of list ORACLE-L Yeah, but do you guys have Texas Weiners?? I think not!! Now those are

Re: EMC TimeFinder, and EMC TimeFinder vs Hot Standby

Yosi, Hot standby db protects you from the data corruption. Any kind of mirroring does not - it's just a copy. HTH, Michael Netrusov, www.atelo.com - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 06:10 Hi All,

RE: identifying shared memory segments

Okay, log into server manager and type: oradebug ipc Oracle 7.x, it will go to stdout. In 8.x it seems to prefer writing out to a trace file... --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Wednesday, March 21, 2001 9:02 AM To: Multiple recipients of list ORACLE-L Me

RE: LONG fields within triggers.

Morten, One solution to this classic "Mutating Table" problem is to capture the ID (better yet, RowID) of each inserted row in a public PL/SQL table in an After Row Trigger, then loop through the PL/SQL table in an After Statement Trigger and do your Selects and Inserts. Works great. Jack

RE: OT -- Canada Rules! / Chocolate ...

something like this: http://members.tripod.com/~pages369/texasbig.html (btw, it was hard to find a somewhat NON-offensive joke containing that tag line!) -Original Message- Sent: Wednesday, March 21, 2001 11:15 AM To: Multiple recipients of list ORACLE-L Which (of the many) Texas

Re: DBA Job at a Chocolate Factory

I had a short gig setting up a database in Tallahassee State prison. They had the prisoners entering data for underground utility lines. I had to train the DBA who was in for 10 years for 3 counts of assault and battery. That was like being on another, very bad, planet. If anyone has any intrest

RE: OT -- A humorous reply to the Canada rulz

Hey, at least I knew it wasn't Mr. Spock :P Dan -Original Message- Sent: Tuesday, March 20, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Dan, You've made one of the only mortal sins of the Internet, it's not dis'ing the Canadians. It's making an inaccurate Star Trek

RE: identifying shared memory segments

Under unix (Solaris at least): set your oracle environment and run $ORACLE_HOME/bin/sysresv. No idea about windoze. HTH David Lord -Original Message- Sent: 21 March 2001 16:02 To: Multiple recipients of list ORACLE-L Me too! Thanks,Ruth B. Gramolini ORACLE DB2 DBA VT Dept. of Taxes

Re: Device busy - HELP

Hi, as far as I remember fuser will not show you anything if a remote process is using the resource, so maybe some other mashine has this filesystem mounted. cheers alex Hello all, HP/UX 11.0 w/EMC hardware Well my trusty BCV's are BUSY. The script that runs every night executes fuser

RE: OT: Rachel in Vietnam

Title: RE: OT: Rachel in Vietnam Neat story! -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 9:36 AM To: Multiple recipients of list ORACLE-L Subject: RE: OT: Rachel in Vietnam Or a visit from one of Puff's successors. As I

Re: Rachel in Vietnam??

Do I get to choose where I go? From: "Carle, William T (Bill), NLCIO" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Rachel in Vietnam?? Date: Wed, 21 Mar 2001 07:10:51 -0800 We all know by now that Rachel wasn't really in

Easy Doubt in sql/plus

Hi Friends : How can I do for put each column in new line using sql/plus Example : Select * from tab; and the result sould be : 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' and not 'value of column1' 'value of column2' 'value of column3'

RE: identifying shared memory segments

sysresv is an utility that comes on 8i and works on each Unix env. However, you can issue oradebug ipc from svrmgrl or from sqlplus since 8i on every env.. Before 8 oradebug ipc shows you semaphores sets and shared memory segments on the screen. From 8 it writes the info in a trace. F.e.: On

RE: identifying shared memory segments

David, this is what i am getting. any ideas? $ sysresv ld.so.1: sysresv: fatal: libclntsh.so.8.0: open failed: No such file or directory Killed $ -Mandar -Original Message- From: Lord David [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 11:03 AM To: Multiple recipients

RE: Easy Doubt in sql/plus

With subqueries. Regards. -Mensaje original- De: Eriovaldo do Carmo Andrietta [SMTP:[EMAIL PROTECTED]] Enviado el: mircoles 21 de marzo de 2001 19:03 Para: Multiple recipients of list ORACLE-L Asunto: Easy Doubt in sql/plus Hi Friends : How can I do for put each

Re: Re: SUN vs. HP

HI.. can someone please tell me a 'bit more' about HP does it follow the 'basic tenets' of UNIX or is it a 'freak deviant' version of UNIX (like AIX!!!).. For starters what is service guard please? is it a cluster software? or RAID software to handle disk boxes? How 'different' is HP unix

RE: identifying shared memory segments

Here's a little something I wrote up on memory errors that relates: --- ORA-07306: sms1sg: shmget error, unable to get a shared memory segment. This indicates a problem with shared memory so you need to clean it up. Just killing off the

OFFTOPIC RE: Rachel and Willie Wonka go to the Chocolate Factory.

Title: OFFTOPIC RE: Rachel and Willie Wonka go to the Chocolate Factory.the travelogue continues ...question is: Is Rachel one of the good kids who doesn't swipe the yummies, or is she one of the out of control chocolateers who gets ejected from the facility?

RE: OT -- A humorous reply to the Canada rulz

the aztecs had what they call the ball game, it was played w/ a wood ball, but it was a combination of basket ball and soccer, I think you could only use the legs, and you had to kick the ball through a little ring to score

RE: Data into another table

Roland, Just like this... Insert Into Table2 ( Col_12 , Col_34 ) Select Col1 * Col2 , Col3 / Col4 From Table1 ; Of course Col_12 and Col_34 must be datatype Number. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc.

RE: Data into another table

insert into table2 (col1, col2) select col4*2, col7/8 from table1; -Original Message- Sent: Wednesday, March 21, 2001 10:51 AM To: Multiple recipients of list ORACLE-L How can I create a select statement from table1 including some division or multiplication , and then include the

Re: ITL and possible deadlocks

Ed, as I understand, this can only happen if a table was created with small maxtrans. If a transaction can't allocate an ITL in a block, it has to wait. When two of them are waiting for each other ITL slots, it is still a deadlock and should be handled internally. In practice, I've never seen

RE: OT -- Canada Rules! / Chocolate ...

sick sick sick. -Original Message- Smith Sent: Wednesday, March 21, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Hum, a few thoughts went though my head there. I hear a lot about Texans and size Forget it, its early. -Original Message- Sent: Tuesday, March

Re: FK Constraints

Hi All, Nobody has proposed this before so let me throw it out for discussion. Think about a compromise between having and not having referential integrity constraints. The approach is that during development and testing, all RIs are enabled. But when you push to production, disable or drop all

RE: Easy Doubt in sql/plus

Title: RE: Easy Doubt in sql/plus Probe this. SQL set pages 0 SQL set feed off SQL set head off SQL set linesize 1000 SQL set trims on SQL r 1 select cod_estado || chr(10) || 2 des_estado 3* from co_estados CO CORRECTO AV AVISADO SS SUSPENDIDO EJ EN PROCESO EXTRAJUDICIAL PJ EN PROCESO

Re: DBA Job at a Chocolate Factory

Well, I spent four days at Rudolph Foods in Lima, Ohio, where they make pork rinds. You could smell the stuff everywhere, and the floors were permanently slippery because of the grease buildup, even though they were mopped twice a day. Gross... [EMAIL PROTECTED] 03/21/01 11:06AM Seven

RE: Easy Doubt in sql/plus

or this messy way: select column1 || chr(10) || column2 || chr(10) || column3 || chr(10 . || column99 / chr(10) is a return command [EMAIL PROTECTED] 03/21/01 01:20PM With subqueries. Regards. -Mensaje original- De: Eriovaldo do Carmo Andrietta [SMTP:[EMAIL PROTECTED]]

Re: Data into another table

insert into table2 (col1, col2 ) select col1, col2 * col3 / col4 from table1 hth connor --- [EMAIL PROTECTED] wrote: How can I create a select statement from table1 including some division or multiplication , and then include the result into table2. Roland Skldblom -- Please see the

RE: identifying shared memory segments

Ruth, In the trace file. You run it on a 8.0.X. Regards. -Mensaje original- De: Ruth Gramolini [SMTP:[EMAIL PROTECTED]] Enviado el: mircoles 21 de marzo de 2001 18:46 Para: Multiple recipients of list ORACLE-L Asunto: Re: identifying shared memory segments Walt, This

RE: Easy Doubt in sql/plus

SELECT column1||chr(10)||column2||chr(10)||columnN from table; Rick -Original Message- From: Eriovaldo do Carmo Andrietta [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 1:03 PM To: Multiple recipients of list ORACLE-L Subject: Easy Doubt in sql/plus Hi Friends :

(Fwd) $1 Billion Savings Gets Even Less Likely For Oracle

--- Forwarded message follows --- Date sent: Mon, 19 Mar 2001 02:04:08 -0500 (EST) ... *** $1 Billion Savings Gets Even Less Likely For Oracle Oracle's goal to reach one billion dollars in savings by implementing its own

Re: Re:RE: 32bit vs 64bit (was: Just like Christmas)

HI... Last year around this time, we were working on Solaris 2.7 (64-bit) and Oracle 8.1.5 (64-bit) and were shocked to find that apart from Oracle executable very few executables (like exp/imp) were 64 bit! Because of this we abandoned the idea of 64-bit with digust!!! Can you please tell me

Re: identifying shared memory segments

In svrmgrl, executing oradebug ipc will generate a tracefile with the information required for mapping it with the output of ipcs. Regards, Denny Ruth Gramolini wrote: Me too! Thanks,Ruth B. Gramolini ORACLE DB2 DBA VT Dept. of Taxes ph# 802.828.5708 fax# 802.828..3754

multiple instance

hi folks how to create multiple oracle 8 instances on solaris. regards - NIHAR SANGHVI NetMagic Solutions Pvt. Ltd. 22,Nirlon Complex,Western Express Highway, Goregaon (E), Mumabai 400 063 Phone: 8723003 extn: 144 www.netmagicsolutions.com -- Please see the official ORACLE-L

RE: DBA Job at a Chocolate Factory

Ang man...ugh...ers. --- Steve Orr [EMAIL PROTECTED] wrote: DBA who was in for 10 years for 3 counts of assault and battery... He must have been working with a lot of duhvelopers. ;-) -Original Message- Sent: Wednesday, March 21, 2001 9:56 AM To: Multiple recipients of list

Re: import/export

You should be a user who has export_full_database and import_full_database to export and import. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 1:35 PM Should I be SYS or SYSTEM user when exporting the entire

RE: DBA Job at a Chocolate Factory

DBA who was in for 10 years for 3 counts of assault and battery... He must have been working with a lot of duhvelopers. ;-) -Original Message- Sent: Wednesday, March 21, 2001 9:56 AM To: Multiple recipients of list ORACLE-L I had a short gig setting up a database in Tallahassee State

Re: DBA Job at a Chocolate Factory

Steve, I don't about unique, but variety is what I enjoy. I've worked at a bank, mortgage bank, diesel engine sales and service, city government and am currently working for an insurance company. Stephen Andert [EMAIL PROTECTED] 03/21 9:06 AM Seven years ago I was offered an Oracle

RE: Data into another table

Title: RE: Data into another table In my last sentence, I meant SALES! I do not profit from any book SALES made by fatbrain(tm). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] How can I create a select statement from table1 including some division or

Re: import/export

System is fine. --- "Leyden, Joseph" [EMAIL PROTECTED] wrote: Should I be SYS or SYSTEM user when exporting the entire database? Help! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services--

Re: identifying shared memory segments

I get a 'not found' when I try to run it on AIX. RBG - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 12:02 PM Under unix (Solaris at least): set your oracle environment and run $ORACLE_HOME/bin/sysresv. No idea about

OT: Re: DBA Job at a Chocolate Factory

Yeah, scofflaw seems to be a common ailment among presidential types. Our current prez is no stranger to the handcuffs either and he and the veep total 5 arrests between them. Jim [EMAIL PROTECTED] 03/21/01 12:56PM I had a short gig setting up a database in Tallahassee State prison. They

RE: Easy Doubt in sql/plus

Eriovaldo, Try this... Select Col1 || Chr(10) || Col2 || Chr(10) || Col3 || Chr(10) || Col4 As TheList From Table; Results... THELIST --- Value of Col1 Value of Col2 Value of Col3 Value of Col4 Jack Jack C. Applewhite Database

import/export

Should I be SYS or SYSTEM user when exporting the entire database? Help! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--

RE: identifying shared memory segments

I think, your library path is not set correctly. (ksh) In sun export LD_LIBRARY_PATH=$ORACLE_HOME/lib In HP export SHLIB_PATH=$ORACLE_HOME/lib IN AIX export LIBPATH=$ORACLE_HOME/lib and then try again... Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA i2 technologies

OFF TOPIC: DBA Job at a Chocolate Factory

Title: OFF TOPIC: DBA Job at a Chocolate Factory -Original Message- From: Jack C. Applewhite [mailto:[EMAIL PROTECTED]] Now MY idea of a heavenly DBA gig would be at something like the Fred Astaire or Arthur Murray World Headquarters, where my wife and I would have access to a

Re: DBA Job at a Chocolate Factory

Steve, I don't think you're crazy.. I know you are :) Actually I would turn that job down, if only because it would make me crazy to be around the chocolate and know that eating it would make me unfit to work Rachel From: "Steve Orr" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To:

Re: OFFTOPIC RE: Rachel and Willie Wonka go to the Chocolate Factory.

I've always been a good little girl wouldn't have touched anything... and I am definitely NOT that spoiled little bratty girl! From: "Mohan, Ross" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OFFTOPIC RE: Rachel and

RE: OT -- A humorous reply to the Canada rulz

That's the story. They even have a lifesize model. -Original Message- Sent: Wednesday, March 21, 2001 1:52 PM To: Multiple recipients of list ORACLE-L WOW, in addition to protesting the sale of indulgences and trying to reform The Church, and printing a Bible, he had time to bowl too?

Re: SGA Parameters ...

This Metalink doc has what you're looking for http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=1008866.6 Harsh Agrawal wrote: Hi, Can u help me to knoe what are the initDB.ora parameters contributing these ? Pl. give one to one or one to

Re: Easy Doubt in sql/plus

No, using only one statment select like select * from tab, what can i set before ? Eriovaldo do Carmo Andrietta [EMAIL PROTECTED] ICQ #102604225 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 3:20 PM With

RE: Easy Doubt in sql/plus

isn't that a bit of overkill? select column1||chr(10), column2||chr(10),. from table; should do it From: "Trassens, Christian" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Easy Doubt in sql/plus Date: Wed, 21 Mar

oracle training

aren't there some people from north carolina here? know any local, in state, oracle training outfits? === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED] === -- Please see the official ORACLE-L FAQ:

RE: multiple instance

Title: RE: multiple instance -Original Message- From: Nihar [mailto:[EMAIL PROTECTED]] how to create multiple oracle 8 instances on solaris. Do you want to test Oracle Parallel Server by having two OPS instances accessing the same database on the same server? Or do you want to

RE: Re:RE: 32bit vs 64bit (was: Just like Christmas)

Well hell, the most important one was the 64-bit. Its the same on HP. Its to allow for extra. In other words things like a bigger SGA and what not. I really don't care what export runs at as long as it runs. That being said, with the exception of one database I am keeping them at 32-bit.

RE: LONG fields within triggers.

Morten, You're safe. Since each User Session runs its own instantiation of each trigger and gets its own instantiation of the PL/SQL table, they're totally isolated from one another and don't interfere with each other at all. That's why a PL/SQL table is better than a DB table for storing

Re:But all is not gloom and doom for Oracle...

It's all "accounting" and "Wall street analysts". Most accountants I know can't keep their own check books balanced and I've got an old class mate down in a wallstreet brokerage. He does petrochemical companies. What I don't understand is how he got the job as he flunked chemistry in HS, and I

RE: multiple instance

Nihar, 1. create new entries in the /etc/oratab and listener.ora files for your new instance, setup environment variables for the new instance : ORACLE_SID should be set to the new instance name, ORACLE_HOME to your existing Oracle home dir. 2. Then just create the new database with these new

Re: Find special characters in the database

On Wed, 21 Mar 2001, Shakeel Qureshi wrote: Hi Jared, Its Oracle 8i and just need to do this operation on a small table, using SQL and PL/SQL. I would appreciate if you could guide me a. As to how to find out the special characters b. Change values Looking forward to your help.

Calling a script/other program from a stored procedure

Hi all, I think this thread was talked about a few days ago, but I missed it. Can anyone show me how or where to look to call a unix script or other program from a stored procedure. Thanks David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David

  1   2   >