testing RMAN == 2 databases in 1 Machine

Dear Listers , I want to try using RMAN in just 1 machine with 2 databases ( client and target ) . I have followed every single step in manual , but there's always error ... Do we must run RMAN in 2 machines ? Thank a lot in advance : ) =bambang= Bambang Setiawan -- Please see the

EXP-00003: no storage definition found for segment

Hi there, I have some problems to export any table, so it seems, of my Oracle 7.3.4 database. I run into the following error: EXP-3: no storage definition found for segment (name, num) Cause: Export could not find the storage definitions for a cluster, index, or table.

Entity Relationship diagrams

Dear DBA Gurus, I have around 30 tables for which the columns, datatypes, size of each datatype, referential integrity constraints is decided. I need to draw E-R diagram linking each table with one or many tables. I am looking for a tool which will draw the diagram for me if I

Re: [EXP-00003: no storage definition found for segment]

hi Bachman, I wonder how you could have an index that is out of your schema,you mean you built it with another user? Anyway,the workaround you wrote would do it. did you try the command prompt for export instead of using the Gui at the server? I got used to command prompts than GUI tools on the

Re: Free Java dba monitoring tool and Java source code

Hi, in my opinion, Jared is only partly right. PL/SQL is a handy procedural language extension to plain SQL. Since SQL derives from the family of declarative languages (by the way, what happened to all the research in the late 80s/ early 90s about hooking up PROLOG engines to RDBMSs ? AFAIK, the

Re: Entity Relationship diagrams

Hi, You can try a software from embarcadero , perhaps www.embarcadero.com , ( if I'm not wrong spell it ) ... or go to www.platinum.com to download Erwin ... hth, bambang Bambang Setiawan "Ranganath K" [EMAIL PROTECTED] 04/17/01 03:50PM Dear DBA Gurus, I have around 30

AW: [EXP-00003: no storage definition found for segment]

Hi ... -Ursprngliche Nachricht- Von: MOHAMMAD AMER [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 17. April 2001 10:51 An: Multiple recipients of list ORACLE-L Betreff: Re: [EXP-3: no storage definition found for segment] hi Bachman, I wonder how you could have an index

Re: Entity Relationship diagrams

hi, ya there are tools which can do this work for you. one such tool i know is Platinum ERwin, but i don't know whether it's free or not. but what i feel is u can get some trial version of it. try getting some more info about how to get it. but one thing i tell u, it's really a good tool. i've

Re: Meeting at IOUG

Me too, Me too!!! ROR mm Ron Rogers DBA OCP Georgia Lottery Corp. -- 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-- Public Internet

Don't Let Microsoft's Claim of Superior Database Security Fool

Geez, enough of the political debates! Let's get back to the business at hand. Here's an announcement from our favorite vendor: Don't Let Microsoft's Claim of Superior Database Security Fool You In a clever attempt to turnaround its weak security image, Microsoft issued a press release

Re: How does dropping a partition affect the rest of the table?

If your indexes are local then no problem . If the indexes are global you 'll have to rebuild them . --- [EMAIL PROTECTED] a crit: I've looked through the on-line documentation on dropping partitions but I have not seen the following question specifically addressed: How does dropping

NYTimes.com Article: Myth-Matched Nations

This article from NYTimes.com has been sent to you by [EMAIL PROTECTED] a reasonable response to an unreasonable email / advertisement ---\ Let NYTimes.com Come to You Sign up for one of our weekly e-mails and the news will come directly to you.

OT Re: Do not belive MUSH and your POPCORN goverment so much

Eric - I couldn't agree with you more! Well said! [EMAIL PROTECTED] 04/16/01 10:10PM Celebrate the entreprenurial spirit: http://www.popcornfork.com/ excerpt: --- "CAUTION Ordering and using the POPCORN FORK will automatically cancel your membership in the FLAT WORLD SOCIETY!

RE: Meeting at IOUG

Title: RE: Meeting at IOUG I'm going to be there (I better, I'm supposed to be giving four presentations) Also, for anyone in the central Ohio area, on thursday the Ohio Oracle Users group will be meeting at which Gaja and I will both be presenting. See www.ooug.org for more details

Re: testing RMAN == 2 databases in 1 Machine

No, I backup databases on 3 machines using rman. Our recovery catalog database is on our production machine and I backup my production databases on that machine. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 3:20 AM

Re: Entity Relationship diagrams

I do not know of any good modeling tool for free, they all charge $$$. I found it a bit strange that you have all the physical layout done then want to do an entity- relationship diagram after... --- Ranganath K [EMAIL PROTECTED] a crit: Dear DBA Gurus, I have around 30 tables

RE: Temporarily Renaming the sgadefSID.dbf File

Good Morning! Just wanted to thank everybody for their responses and excellent feedback. Renaming the file worked like a charm. This allowed me to create the controlfile of the new database and bring it up w/o any problems. Now I know :-) Steve -Original Message- From:

weird bitmap error

Scenario: AIX, 8.1.6.3. Cognos cube building going on. select count(*) from ft_sales, shows up 0 rows, its using a bitmap index out of the explain plan. I force full table scan or force to use other bitmap index, or PK(normal index) and it comes back with correct count(20+ million). Anyone

RE: Do not belive BUSH and your army goverment so much

Maybe you should mention how much better China is than the US to all the Chinese people willing to risk their lives crossing the Pacific in cargo holds in search of a better life here. -Original Message- Sent: Monday, April 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L

Problem opening Oracle Forms

I have installed Oracle Developer/2000 on my machine. When I try and open up Forms I get an error message: Message file C:\ORACLE_HOME\DBS\FMCUS.MSB not found. I looked for the file in that directory and it is definitely not there. Any ideas? Thanks, Eric -- Please see the official

Re: index query

You could use the alter index rebuild option. This keeps the old index available for queries until the new index has been created. You just need to make sure you have double the space of the object you are rebuilding when using this technique. James --- Seema Singh [EMAIL PROTECTED] wrote: Hi

RE: Meeting at IOUG

I will be there also. Sandra Arnold DBA Strategic Staffing Solutions -Original Message- Sent: Tuesday, April 17, 2001 7:55 AM To: Multiple recipients of list ORACLE-L Me too, Me too!!! ROR mm Ron Rogers DBA OCP Georgia Lottery Corp. -- Please see the official ORACLE-L FAQ:

RE: Materialised view

Here is the MV log and the MV, it's generating an ORA-12032 when trying a refresh fast. create MATERIALIZED VIEW log on sp_ect_etat_contrat with primary key (ECt_ID_PRODUIT, ECt_CD_SERIE , ECt_CD_SOURCE , ECt_CD_AGENCE ,

Ability for non DBA user to kill session.

All, Is there a method forallowing a non DBA user to kill their own (and only their own) session. I have had a trawl through Metalink and have seen various methods (using procedures) of doing it but all of these appear to rely on granting the alter system role to the user. Oracle

Oracle Deployment Engineer (DBA) with Unix Sys Admin

Top-notch company in Denver, Colorado needs an Oracle Deployment Engineer (DBA) who has Unix Systems Administration experience. This organization is not particularily a "button-down" company. The selected candidate will plan and coordinate installations or upgrades of software, provide

Oracle's ftp site

Anybody know where oracle has moved (hidden) their ftp address now? What doesn't work: ftp://external-ftp.us.oracle.com ftp://209.246.5.40 ftp://205.227.44.220 ftp://oracle-ftp.oracle.com In case it helps, the error I get says "An error occurred reading the contents of the folder. Make sure

Re:Don't Let Microsoft's Claim of Superior Database Security

Tim, I'll agree, as I remember it the C2 security spec was a farse compared to todays reality. OH, BTW, the first NSA approved database for Confidential and higher data was "Trusted Oracle7". All of the others were only certified for "For Official Use" and lower data. And back in 92

Re: How does dropping a partition affect the rest of the table?

Stephane, Thanks for your reply. Cherie paquette stephane

RE: stupid DBA

Michael Sun wrote: Peace on earth and de-fragmented Oracle database everywhere. "Peace on earth" was the password from the movie called "Dr. Strangelove", in my opinion one of the best movies ever made. De-fragmented databases are not an issue any more now that we have locally mismanaged

Re: Urgent - Migration

Thanks for all!! I applied the patch 8.1.6.3.0 and everything was right! Again, thank you! --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- Gilberto Gampert Universidade de Passo Fundo Administrador de Banco de Dados Passo Fundo - RS - Brazil

current transaction in oracle

hi, i am looking for a sql statement which can tell me the current sql running in oracle. TIA Srinivas __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L

Re:32bit v. 64bit Oracle

Since we're talking 32 VS 64 bit, anybody know when Oracle 817 64 bits we'll be available on Solaris ? Oracle.store only shows Oracle 816 64 bit for Solaris. If you do not need to adress a huge SGA, what are the benefits are running Oracle 64bit instead of Oracle 32 bit ? --- [EMAIL

Re: Oracle's ftp site

ftp://oracle-ftp.oracle.com [EMAIL PROTECTED] 04/17/01 11:00AM Anybody know where oracle has moved (hidden) their ftp address now? What doesn't work: ftp://external-ftp.us.oracle.com ftp://209.246.5.40 ftp://205.227.44.220 ftp://oracle-ftp.oracle.com In case it helps, the error I get

URGENT: Hot Standby Graceful failover and failback

Good morning everyone, HELP! HELP!!! It's very early in the morning and I'm still struggling with the Oracle Hot Standby - 8.0.5 and 8I. ARGH! Ok, I got the failover going. I can activate the standby database and use it as a normal database. But when I try to turn it into a standby database

Re:NYTimes.com Article: Myth-Matched Nations

Regrettably I don't recognize the e-mail address, but then I don't recognize too many of them. At any rate, and I do want to keep this short, That's one very good article with words of wisdom for BOTH sides in this war of words. Am I upset with China, no not really. I think the leadership

RE: Ability for non DBA user to kill session.

Lee, In short, you can't achieve this within Oracle domain short of granting ALTER SYSTEM to user in question or going via PL/SQL procedure owned by other, more protectedschema. However, a tool like TOAD will provide similar capability for you - a user is capable to "cancel" long running

RE: Oracle's ftp site

ftp://external-ftp.us.oracle.com ftp://205.227.44.220 ftp://oracle-ftp.oracle.com These worked for me. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] -Original Message-

Re: Meeting at IOUG

I'll be there and would like to meet as many of you as possible. If anyone who knows the ropes can suggest a time/place, that would be great. As this is my first IOUG event, I don't have any ideas on where/when, so it's up to all you "veterans". Keep this thread going. Stephen Andert

Re: Meeting at IOUG

I'll be there too! It will be my first visit to IOUG and I'm looking forward to meeting the many folks who have contributed to my knowledge [and amusement] through this List. Even though I don't often post questions, your advise to others have been very useful. Keep up the good work. Bill

db and apps migration

I will be upgrading our database and application server from 8.0.5.2.1 and 11.0.2 to Oracle 8.1.6 and Applications 11.5.3. I understand from reading the upgrade manuals as well as confirming from Oracle support that the database must have a db_block_size of 8k or larger. We are currently

Re: stupid DBA

Michael, I disagree strongly w/ your comments about a peacefully defragemented Oracle database. See the article called "How to Stop Defragmenting and Start Living". Mike From: "Michael Sun" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL

OT - Performance impacts with column and table aliases in SQL Ser

Hello all, I know, I know - An Oracle list. However some of us work with many databases (our shop has Oracle, SQL Server, Adabas, and Sybase), so maybe someone on this list can help. The subject line should give enough info to delete the message if you hate the 'other' databases. I was

server sizing

in gaining knowledge about oracle I've been introduced to some concepts, components, and concerns and I'd like to get some general feedback. so, in general how big of a deal is server design? what would you use as criteria for decision making, like the need for multiple controllers and

Re: Ability for non DBA user to kill session.

Create a procedure as SYS (or someone else powerful) which does the 'alter system' and then grant just the proc to the user hth connor --- lerobe - Lee Robertson [EMAIL PROTECTED] wrote: All, Is there a method for allowing a non DBA user to kill their own (and only their own) session. I

Re: Ability for non DBA user to kill session.

I don't think you can kill yourself anymore, at least in 8.1.6. Even as a DBA, Oracle wouldn't let me off myself... Note to ALL: ENOUGH WITH THE POLITICAL CLAPTRAP ALREADY!!! [EMAIL PROTECTED] 04/17/01 11:26AM All, Is there a method for allowing a non DBA user to kill their own (and only

RE: Ability for non DBA user to kill session.

Hello, Li, I believe, stored procedure is the best and simplyest way for this purpose. There is nothing wrong giving ALTER SYSTEM to _procedure owner_. End user will be limited to execute this procedure only, and will not require ALTER SYSTEM for him/herself. Best regards, Vadim

rman change delete

how to automate CHANGE BACKUPSET key DELETE ? Any ideas? I'm trying to obtain the backupset key with LIST BACKUPSET, and then, i'll need to make some script to build a rman script with several CHANGE BACKUPSET DELETE statements. Am i wrong? Thank you -- Please see the official ORACLE-L FAQ:

Re: 9iAS -- Boxes on which to run

My experience is that 9iAS requires 1G RAM to run well. More if you want IFS... Given that the typical inexpensive Intel box is capped at 4GB and Microsoft won't let you use more than 3GB (2.5 realistically) on a 4GB machine, or half of your real RAM if you have less than 4GB, and that a

Further OT: Dr. Strangelove

Or was it "Purity of Essence" Protect your bodily fluids. If you don't get the President on the phone, you'll have to answer to the Coca-Cola Company. A GREAT MOVIE. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED]

Re: current transaction in oracle

COLUMN address NOPRINT COLUMN username FORMAT a12 BREAK ON address SKIP 1 SELECT a.address ,sql_text ,osuser ,username FROM v$sqltext a ,v$session s WHERE s.SQL_ADDRESS = a.ADDRESS AND s.status = 'ACTIVE' AND s.type

RE: current transaction in oracle

Try select * from sys.v_$sqlarea Anthony -Original Message- Sent: Tuesday, April 17, 2001 11:07 AM To: Multiple recipients of list ORACLE-L hi, i am looking for a sql statement which can tell me the current sql running in oracle. TIA Srinivas

Re: Free Java dba monitoring tool and Java source code

Hi Sam, As part of my masters dissertation I have developed an SQL monitoring tool using Java/JDBC/thin drivers that allows the DBA to see who is taking up the resources currently in a database. This is not at all a commercial venture, purely academic. Plus if you want to learn about

(Fwd) Tar # 1339336.996:run all on one win2000 box: OEM, DB, Forms Web server?

Larry folks, It's taking OWS a while to clarify/answer on the question of running db/oem/forms-server on one NT servre box (originally submitted friday 13th). regards, ep --- Forwarded message follows --- Date sent: 17 Apr 01 10:14:44 To: [EMAIL

RE: URGENT: Hot Standby Graceful failover and failback

I think you may be trying to do a little too much with the current standby architecture. Oracle now has product called Data Guard that will let you do what you want. I've only read the docs on Data Guard, but supposedly you can switch primary and standby database, and switch back without

RE: 32bit v. 64bit Oracle

Stephen, Last time I checked Metalink (couple of weeks ago), 8.1.7 64-bit status was "projected" with Sun Sparc Solaris. I filled out a TAR asking when it will be certified, and they told me to check Metalink (even offered me walk me though the web pages)! Mike The views expressed here are

Re: rman change delete

All of the items are in the tables which underlie the views. Just use sql to delete the items you want. Just be careful! Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 1:51 PM how to automate CHANGE BACKUPSET key

RE: current transaction in oracle

set pagesize 1000 spool actual SELECT SID, TYPE, STATUS, USERNAME, SQL_TEXT, EXECUTIONS, LOCKWAIT, SERVER, OSUSER, PROCESS, MACHINE, TERMINAL, PROGRAM FROM V$SQLAREA, V$SESSION

ADMIN: Off-Topic (was: RE: Do not belive BUSH and your army gov

*** ADMIN WARNING *** Please do not continue ANY discussions about China or the recent aircraft collision incident in this mailing list. There have been quite a few off-topic posts of late, but this is *FAR* off-topic, and is not appropriate for this list. If you want to continue this

Re: Meeting at IOUG

Glad to see so many people wanting to get together. I would like to propose a time and place... Tuesday night is the "big bash", and Wednesday night is a "Pleasure Island" event. There is a Monday night welcome reception in the exhibit hall until 7:45. So, I think the best time is Monday at

RE: Meeting at IOUG

Title: RE: Meeting at IOUG I should have know Rachel would get picky. Yes, I mean this Thursday, April 19th, 2001 R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From:

RE: server sizing

Lerone, My opinion is that your database on an NT platform will not scale as well as you may hope. You are talking about adding 100-150% more data and tripling your users to 300. I would strongly recommend going to a Unix platform for your database. Also, if the database is going to grow that

RE: Meeting at IOUG

HEY! :) Just don't want anyone to be disappointed is all From: "Adams, Matthew (GEA, 088130)" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Meeting at IOUG Date: Tue, 17 Apr 2001 10:45:37 -0800 I should have know

Re: Meeting at IOUG

I nominate Monday evening. That way those of us who don't know anyone will have more familiar faces the rest of the week (especially at the big bash on Tuesday). I don't have a clue where to meet. IOUG veterans any suggestions? Stephen Andert -- Please see the official ORACLE-L FAQ:

RE: Entity Relationship diagrams Qdesigner using same engine as P

its using the same engine as powerdesigner. whats the gimmick behind this. Story 1. Hack Bill Gates Larry Ellisons bank accounts. 2. Buy Oracle DB source licence from Oracle. 3. Write a Search and Replace globally (s/Oracle/FreeOracle/g) 4. Market FreeOracle Just Daydreaming... -Mandar

Re: Meeting at IOUG

Margaritas? I'm there :) Ari D Kaplan wrote: Glad to see so many people wanting to get together. I would like to propose a time and place... Tuesday night is the "big bash", and Wednesday night is a "Pleasure Island" event. There is a Monday night welcome reception in the exhibit hall

RE: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your army

Title: RE: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your army gov Wow, I guess Jared was fired, eh? ;- == -Original Message- == From: Bruce Bergman [mailto:[EMAIL PROTECTED]] == Sent: Tuesday, April 17, 2001 2:29 PM == To: Multiple recipients of list ORACLE-L == Subject:

Anyone out there using CA/Platinum's PR_OEE Tool?

Title: Anyone out there using CA/Platinum's PR_OEE Tool? I'd like to ask a question of you offline ( only b/c it is likely an extremely niche-y product. ) TIA, Ross

RE: OPS waits

O.P.S. Setup in Benchmark Runs :- -- 2 DB Servers - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1 1st APP Server - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1 2nd APP Server - SUNe420R - 4 CPUs , 4 GB RAM - Solaris 2.6 3rd APP Server -

RE: Meeting at IOUG

Anybody knows what is a Pleasure Island event? Alex Hillman -Original Message- Sent: Tuesday, April 17, 2001 2:54 PM To: Multiple recipients of list ORACLE-L Glad to see so many people wanting to get together. I would like to propose a time and place... Tuesday night is the "big

Re: Meeting at IOUG

sounds good to me any others? From: Ari D Kaplan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Meeting at IOUG Date: Tue, 17 Apr 2001 10:53:57 -0800 Glad to see so many people wanting to get together. I would like to

Oracle Service does not start

Hi! I'm having a problem with Oracle on Win2k here. I can't start Oracle by using the Management Console (i.e. start the windows Service). The Service remains in the status "starting" but never goes to "started". Then I can't even stop the service again. Not with the tool neither with the

RE: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your army

Bruce runs fatcity Jared monitors this particular list no one was fired From: "Mohan, Ross" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your "army" Date: Tue, 17 Apr

Re: Meeting at IOUG

I'm a first timer too. Monday night sounds good. Jim Howerton Senior Oracle DBA University of Alabama at Birmingham Health System Information Services e: [EMAIL PROTECTED] v: 205-934-9111 f: 205-934-0632 [EMAIL PROTECTED] 4/17/01 10:41:39 AM I'll be there too! It will be my first visit to

fwd: 20 Differences Between Oracle on NT and Oracle on Unix

Doc ID: Note:45967.1 Subject: 20 Differences Between Oracle on NT and Oracle on Unix Type: FAQ Status: PUBLISHED Content Type: TEXT/PLAIN Creation

Re: Meeting at IOUG

No offence to anyone but I enjoy being the designated driver. I have a good sense of humor and a great time at any get-together. Any location that the group can centrally find is ideal. ROR mm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET:

RE: server sizing

I'm envisioning various levels of raid just wanted to get something out quick for some feedback. for example, I'm thinking the data files, redo logs, arc log, and control files would be on differently combined disks. of course some file system recovery and redundancy is desired, but to what

RE: Meeting at IOUG

Pleasure Island is one of the Disney resorts From: "Hillman, Alex" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Meeting at IOUG Date: Tue, 17 Apr 2001 11:28:21 -0800 Anybody knows what is a Pleasure Island event? Alex

RE: Oracle Service does not start

See note 132086.1 on Metalink. -Original Message- Sent: Tuesday, April 17, 2001 3:02 PM To: Multiple recipients of list ORACLE-L Hi! I'm having a problem with Oracle on Win2k here. I can't start Oracle by using the Management Console (i.e. start the windows Service). The Service

Re: URGENT: Hot Standby Graceful failover and failback

Hello Leng, 1. create a hot standby from a primary database 2. activate the hot standby 3. shutdown the new primary and made a backup of the new primary database 4. restart the new primary, created a table and create a standby controlfile 5. shutdown the new primary 6. restore from

Re: Meeting at IOUG

I'm open at 8 monday evening. Sounds good to me. Terry Ari D Kaplan wrote: Glad to see so many people wanting to get together. I would like to propose a time and place... Tuesday night is the "big bash", and Wednesday night is a "Pleasure Island" event. There is a Monday night welcome

Re: Meeting at IOUG - LOCATION CONFIRMATION

Since I started this thread. Let me call for a closer. I think this suggestion is great. Let confirm this. Murali Vallath Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 17 Apr 2001 10:53:57 -0800 Glad to see so many people wanting to get

RE: Meeting at IOUG

What is a "... Island" event? Looks like my e-mail system does not like first word. Alex Hillman -Original Message- Sent: Tuesday, April 17, 2001 2:54 PM To: Multiple recipients of list ORACLE-L Glad to see so many people wanting to get together. I would like to propose a time and

RE: Meeting at IOUG

thanks, but what the activities will be? Alex Hillman -Original Message- Sent: Tuesday, April 17, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Pleasure Island is one of the Disney resorts From: "Hillman, Alex" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple

Re: Meeting at IOUG

I love a good margarita (or two). Sounds like a good idea. Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 1:53 PM Glad to see so

Metalink error

Please forward tuning suggestions for the following problem to Oracle Support. It looks like they may still need a little help with Metalink! Gary Tue, 17 Apr 2001 21:02:34 GMT ORA-04031: unable to allocate 2550012 bytes of shared memory ("large pool","unknown object","session heap","bind var

Strange Oracle8 varchar2 behaviour.

I am connected to an Oracle8 Database on Windows NT SP5, we have a table with a column of datatype varchar2(4), however its length is reported as 5. Any reason/s as to why this is happening? I have done a describe and a select of the table below. Any help would be appreciated. Thanks, Susan.

RE: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your army

Title: RE: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your army Yes, but who watches the watchdogs? G == -Original Message- == From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] == Sent: Tuesday, April 17, 2001 4:06 PM == To: Multiple recipients of list ORACLE-L == Subject:

move schema away from system table space

Hi All, I need to move a user/schema away from the system tablespace to a newly created user tablespace. Could somebody point me to the references on how to do the job? Since a production server is running off the schema, is it possible to do the move without having to shut down the server?

RE: Meeting at IOUG

On Tue, 17 Apr 2001,Hillman, Alex scribbled on the wall in glitter crayon: -Anybody knows if one need to rent a car there? - -Alex Hillman if you are staying at the host hotels, then no... you can get anywhere on the disney property via bus and fairly quickly. if, lik me, you are staying at a

RE: warning glitches netiquette/ RE: ADMIN: Off-Topic (was: R

Title: In retrospect, I should have made my wink alot larger.Maybe like: ;- well, that's about all for now. Those rotten Republican, F-8 flying, Chinese, Microsoft lovers can all go to heck in a handbasket! == -Original Message-== From: Eric D. Pierce [mailto:[EMAIL

RE: 32bit v. 64bit Oracle

Last I heard from Oracle was May 4th for release of 64-bit 817 for Solaris. HTH Gerardo -Original Message- Sent: Tuesday, April 17, 2001 8:15 AM To: Multiple recipients of list ORACLE-L Since we're talking 32 VS 64 bit, anybody know when Oracle 817 64 bits we'll be available on

RE: move schema away from system table space

1. Export the user's schema ( exp help=y ) 2. issue in sqlplus: drop user_name cascade; 3. then remake the user with the new table space as the default tablespace ( all permissions there - none elsewhere ). 4. imp the user from the export dump with ignore=y regards - john f. lewis

Re: server sizing

And I'm just in the mood for a ramble, too... We stayed with NT too, because we have the sysadmins and engineers already. I have a DB that sounds a lot like yours and it's running just fine on a dual p400 with a mirror for redo and archive log and a raid5 for the data files. The real problem

RE: Ability for non DBA user to kill session.

Hi All, Further to that, it is necessary to use DBMS_SQL or native dynamic SQL for this as PL/SQL does not support ALTER SYSTEM directly. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Wednesday, 18 April 2001

RE: move schema away from system table space

Best way is to use export/import utilities. This can be done with server on line and you will get all table data if done at quite time when table is not being updated. See Oracle Backup and Recovery Guide for info on exp/imp. PA -Original Message- Sent: Tuesday, April 17, 2001 3:50 PM

Java Programmer just getting started with Oracle......

Hello. I'm new to Oracle and am looking for some "guru" guidance on some resources to tap in order to get up to speed (preferrably quickly). I'm a Java programmer looking to start getting into building applications backended by Oracle. I am comfortable with Java (including JDBC) and SQL.

(Fwd) Tar # 1339336.996:run all on one win2000 box: OEM, DB, Forms web server

Larry folks, Still not sure what it all means! They don't seem to be able to answer specifically on Forms *Server* for some reason. I'll continue asking tomorrow. regards, ep --- Forwarded message follows --- 1339336.996 Open

Re: Locally Managed Tablespaces

Patricia, FWIW, We have been using them for several months now and have not seen anything negative as a result. We decided to start using them for all new tablespaces and we add a new set of tablespaces every month to accomodate our partitioning strategy. Our biggest databases that we are

Synonym on Standby Database

Has anyone tried to use their standby database as a read-only database through db links and mapped to synonyms? I'm having problems creating one (12145 e.g.) and am now wondering whether it is even possible. This is to alleviate the downtime in the event of single table failures in

Re: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your army

On Tuesday 17 April 2001 12:15, Mohan, Ross wrote: Wow, I guess Jared was fired, eh? ;- Hardly. Of course, I must consider the source of this comment. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network

  1   2   >