Re: Oracle 9i Real Application Cluster Concepts manual.

use this url, it contains all the manual of 9i http://download-eu.oracle.com/otndoc/oracle9i/901_doc/nav/docindex.htm HTH Venkat -- On Tue, 08 Jan 2002 22:25:19 Sathish Tatikonda wrote: hi all, if any of you has Oracle 9i Real Application Cluster Concepts manual softcopy could you please

Re: Unix - script

Use unix utility ftp to copy file between 2 mc's or use rcopy. For more details refer to man pages. -- On Tue, 08 Jan 2002 23:15:35 Roland.Skoldblom wrote: Hallo, I would like to have an example of a unix script, which does the following: copy some files from directory /prod/sas/data

Re: Kernel parameters (Sun Solaris)

Ref to installation guide supplied with Oracle software. All the required and necessary parameters are given with good explanations. HTH Venkat -- On Tue, 08 Jan 2002 22:35:21 ALEMU Abiy wrote: Hi guys, Is there any guide line or documentation which gives values of OS kernel parameters for

Re: A Simple Rollback Segment Question

Hi, Correct. It's just that I joined the Oracle Bandwagon when 7.3 was out already, so I never actually created an oracle pre 7.3 database. Jack [EMAIL PROTECTED]@fatcity.com on 09-01-2002 07:25:18 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple

RE: Unix - script

Roland, Try this by setting up environment variables at the top of your script: SERVER1= 10.10.10.10 USER1= 'xxx' PWD1= 'xxx' SERVER2= 10.10.10.20 USER1= 'yyy' PWD2= '' Then have this: ftp -i -n EOF open $SERVER1 user $USER1 $PWD1 cd scripts get file close EOF You can then have a

RE: Unix - script

Forgot to mention, the 'cd scripts' line in both examples is not required, it's just been left in from the script I copied. oops! K. -Original Message- Sent: 09 January 2002 08:20 To: Multiple recipients of list ORACLE-L Roland, Try this by setting up environment variables at the top

IMP/EXP b/w 8.1.7 and 8.1.6

Hi list, I have 2 db instances on two different boxes; one is 8.1.7.0.0 and the second one 8.1.6.0.0, if I want to import data from 8.1.7.0.0 into 8.1.6.0.0 database, what should I do, The first solution which comes into my mind is to use 8.1.6's "exp" command to export data from

XML implementation

Title: XML implementation Hello Gurus, Management has now picked up the catch word XML. I now have to present a implementations plan - thursday. I naturally have no knowledge of the subject, but have spent hours now studying the docs. However there are so many possible choices and

RE: Dig it - killer freeware editor

Hannibal, Thanks for the link! This product is SO COOL! I personally code in SQL, HTML, Javascript, PHP (sometimes) and am curently trying to get my head around perl - and this product rocks for all of them! Thanks.. Mark -Original Message- Sent: 08 January 2002 20:35 To: Multiple

Re: XML implementation

Title: XML implementation - Original Message - From: Denham Eva To: Multiple recipients of list ORACLE-L Sent: Wednesday, January 09, 2002 10:26 Subject: XML implementation What we intend to try is a B2B (business to business) implementation. Receive

RE: Oracle Future???

i have a 1TB Oracle DB running on Win2K. That customer previously used MS SQL server , until the DB grew up to some 350GB and then . the company i used to work for earned some good bucks on MS SQL server to Oracle conversion and i got some moderate MS SQL server knowledge. Nice toy.

RE: login/exit problems

Title: RE: login/exit problems There was a problem with Oracle Trace being set in some V7 instances. A couple of files grew quite large. STOP PRESS just checked on Metalink and found note 45482.1 This suggest checking the $ORACLE_HOME/otrace/admin directory for a file process.dat and see if

Clone a database

Hello list, I new to clone a database for changing between test to production. The new database is going to be in a different host. I have the copy obtained through the enterprise manager (I suppose it´s a cold backup). Which are the steps I should follow? A lot of thanks -- Please see the

RE: CHAINED ROWS

Title: RE: CHAINED ROWS Thanks Jacques...forgot about the Index-organized tables. 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 Ext. 76217 Fax : +44 (0) 115

RE: Clone a database

Hi, Just to be absolutely sure as to what you have got in terms of a backup, please explain how exactly you obtained your backup from Enterprize Mgr. Martin -Original Message- Martínez Jiménez Sent: 09 January 2002 09:50 To: Multiple recipients of list ORACLE-L Hello list, I new to

Re: URGENT : how to insert/retrieve Blob ??

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 09, 2002 07:40 hello everybody , would someone give me an example to insert/retrieve a bolb ? please refer to Oracle9i Application Developer's Guide - Large Objects (LOBs) at

RE: CHAINED ROWS

Just one thing to add to the instructions to rebuild migrated rows. It says don't forget to disable any foreign key constraints. Don't forget the on delete cascade constraints too. I made that mistake once. Mike From: SARKAR, Samir [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple

RE: Unix - script

It could be faster to remote copy: rcp -p /archive/orcl/arch_1_2290.arc oracle@server2:/archive/orcl/arch_1_2290.arc Mike From: Thomas, Kevin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Unix - script Date: Wed, 09 Jan

Re: login/exit problems

Thanks to all, It was indeed the process.dat file associated with oratrace growing larger than it should. Tony Hallas John wrote: There was a problem with Oracle Trace being set in some V7 instances. A couple of files grew quite large. STOP PRESS just checked on Metalink and found note

RE: Unix - script

Yip, never thought of that one ;o) -Original Message- Sent: 09 January 2002 10:55 To: Multiple recipients of list ORACLE-L It could be faster to remote copy: rcp -p /archive/orcl/arch_1_2290.arc oracle@server2:/archive/orcl/arch_1_2290.arc Mike From: Thomas, Kevin [EMAIL PROTECTED]

RE: Best practices for data warehousing in 9i

9i now has the following that may help a DW: -- Bitmap Join Indexes -- MERGE statement (its there, not well documented) -- List Partitioning -- External Tables -- Resumable Space Allocation I'm sure there's more, but that's what I've found so far. (I only have so much spare time!) Caver

Re: Kernel parameters (Sun Solaris)

don't know if the guidelines actually work to that level but the OS specific documentation should be in Metalink (and I think, if you search hard enough, it might be on technet as well, not sure about that though) --- ALEMU Abiy [EMAIL PROTECTED] wrote: Hi guys, Is there any guide line or

Problems in replication

Hi, We have a replication between production and reporting database. Prodn Server Reporting server HP-UX 10.2HP-UX 10.2 oracle 7.3.4.4.1 oracle 7.3.4.4.1 The os and oracle patches on the production server and reporting server are in sync.

Re: CHAINED ROWS

You also might need/want to disable triggers on the table. Mike Killough wrote: Just one thing to add to the instructions to rebuild migrated rows. It says don't forget to disable any foreign key constraints. Don't forget the on delete cascade constraints too. I made that mistake once.

Re: US7ASCII, UTF8, characters sets, conversions.....agghhhhHH!!!!!

When I connected I got: OWS-05101: Execution failed due to Oracle error -6550 Oops! Maybe they have the wrong character set. Grabowy,

Re: Clone a database

Have a look at None:73974.1 on Metalink. It give the step for cloning a database from backups. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 09, 2002 4:50 AM Hello list, I new to clone a database for changing

RE: Clone a database

Hi, Beatriz, If you want to create an identical copy of your production (that's my understanding), it is a lot easier to export it (FULL=Y) and then import the dump file into your new database. Let me know if you need more info. Regards, Sergey Babich, Oracle DBA -Original Message-

output a SQL in a stored procedure on to a screen

I want to output a SQL Statement inside of a Loop. If you look at the following statement you will see I am outputting the 'Solution' which it is doing but my SQL is failing. If I select the statement out and drop in the Solution into it is works. So I want to see what SQL is being passed: I

RE: Clone a database

Hello Beatriz Oracle 8i can export and import an entire tablespace and this is much faster then regular export/import. The procedure was published in XEPHON http://www.xephon.com. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED]

help with outputting data

I want to output a SQL Statement inside of a Loop. If you look at the following statement you will see I am outputting the 'Solution' which it is doing but my SQL is failing. If I select the statement out and drop in the Solution into it is works. So I want to see what SQL is being passed: I

SQL-02127 : Precompiler/SQLLIB version mismatch

Once compiled my application under the 8.1.7 Pro*C while connecting to the database, I've got SQL-02127 : Precompiler/SQLLIB version mismatch. Does someone has an idea ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City

RE: US7ASCII, UTF8, characters sets, conversions.....agghhhhHH!!!

Hello Chris We made a point to have all the components (servers and clients and db's) in the same character sets. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wed, January 09, 2002 3:35 PM To:

java stored procedures and running rsh command

I have been using the run_cmd code posted on the askTom site to run Unix commands from stored procedures. It works fine. However I am now trying to run a rsh command and always get 'permission denied' errors from the rsh commmand. The rsh command works fine when I run it from the command line(as

Re: EMC Not Releasing Space

In my opinion it is an Operating System issue. I have seen this under several different platforms. You just have to wait it out (or reboot). Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi, Just

RE: Oracle Future???

The DBA Enterprise team at my company actually did a review of DB2 and Oracle. This was back in the days of Oracle 8. Some of the features that Oracle came out behind in are now there in 8i but they got quite similar results in performance and all that fun stuff. But that was running some

RE: Dig it - killer freeware editor

OK, now I have to go look it up. I ignored it the first couple of posts. -Original Message- Sent: Wednesday, January 09, 2002 1:20 AM To: Multiple recipients of list ORACLE-L Hannibal, Thanks for the link! This product is SO COOL! I personally code in SQL, HTML, Javascript, PHP

RE: Clone a database

easier perhaps only if you have the exact same disk layouts and space available. and certainly MUCH more time to create -- an import takes anywhere from 2-4 times as long as the export did. --- Babich , Sergey [EMAIL PROTECTED] wrote: Hi, Beatriz, If you want to create an identical copy of

RE: ORA-600 Parser...

Yup ... for me most of the time it doesn't look-up anything Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD:

RE: java stored procedures and running rsh command

You know, rsh is actually considered bad practice for security reasons. Granted, the first thing I do is setup my .rhosts file so that I can use it;-) But I have been on sites that will not allow it. -Original Message- Sent: Wednesday, January 09, 2002 6:41 AM To: Multiple recipients

RE: US7ASCII, UTF8, characters sets, conversions.....agghhhhHH!!!

Hey Yechiel, Thanks. And which character set is that? Chris -Original Message- Sent: Wednesday, January 09, 2002 9:15 AM To: Multiple recipients of list ORACLE-L Hello Chris We made a point to have all the components (servers and clients and db's) in the same character sets.

Database Comparison

Hi: I need to compare my Production database with QA database. I would like to generate a report that shows differences in schemas across these two databases(tables, indexes, views, object definition, etc..). I would appreciate it if you could forward me a script that would accomplish this

RE: Unix - script

on hakon: scp user@hardy:/prod/sas/data/file /dir/on/hardy/ is one way if you have ssh/scp installed. Scott Shafer San Antonio, TX 210-581-6217 Common sense will not accomplish great things. Simply become insane and desperate. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL

Upgrade to 8.1.7

My boss wants to upgade from 8.1.6 to 8.1.7 on NT4.0. Are they any know issues that I would have to deal with? Thanks for your help! David Ehresmann Oracle DBA 8 8i OCP MCI Worldcom [EMAIL PROTECTED] 972.656.1015 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Oracle Reports upgrade query

I have Oracle 7.3.4 database running on HP-UX 10.20. We have reports v1.1 running against this (different ORACLE_HOME), on the same system. We are looking at replacing the system with another HP-UX 11.0 system, and therefore upgrade the database to 8.1.x. This is not a problem, but although I

ORA-600 Parser...

I ran across something that I have not seen before when logging a TAR via MetaLink. Oracle now has an ORA-600 parser and lookup. Thought you might all be interested if you have access to MetaLink: http://metalink.oracle.com/metalink/plsql/showdoc?db=NOTid=153788.1blackfr ame=0 Jim

Re: Problems in replication

Shreepad, You need to look in v$session_wait for the event the hanging session is waiting on. This will answer the question, What is it doing? Once you get that information, you will be able to stop guessing at causes (HP, EMC, corrupted file, LVM). Once you have the event for the hang, read

RE: EMC Not Releasing Space

Was the file part of temporary tablespace? -Original Message- Sent: Wednesday, January 09, 2002 10:06 AM To: Multiple recipients of list ORACLE-L In my opinion it is an Operating System issue. I have seen this under several different platforms. You just have to wait it out (or

RE: java stored procedures and running rsh command

Kimberly, What is the format for the .rhosts file? I'm actually trying to work on something right as we speak. If I remember correctly the file gets stored on the server that you want to connect to and the contents are just: ip username where username is the name that you are logged in as on

Re: Kernel parameters (Sun Solaris)

You might check in the 'Oracle on Solaris' installation guide. ALEMU Abiy

RE: Clone a database

With all my respect, this is not always the case Best regards, Serge -Original Message- Sent: Wednesday, January 09, 2002 10:15 AM To: Multiple recipients of list ORACLE-L Subject:RE: Clone a database easier perhaps only if you have the exact same disk layouts and space

Re: Dig it - killer freeware editor

www.vim.org On Tuesday 08 January 2002 10:40, Mohan, Ross wrote: http://www.fixedsys.com/context/ (yes, Virginia, it's oracle-relatedread the site...!) Apologies to the OFF TOPIC list for this ON topic crap! - Ross Data bin Loaden Mohan -- Please see the official ORACLE-L FAQ:

RE: Database Comparison

Srini, I would suggest going to http://www.toadsoft.com and downloading the freeware version in order to use the Schema Compare tool. All it would require would be a database link between your Production DB and your QA DB, or vice-versa. It will show you all object differences. Jim

RE: Dig it - killer freeware editor

I just downloaded it but kinda disappointed that it doesn't (yet ?) provide any JSP highlighting. Otherwise it looks cool as they say - even over here in the UK :-) Martin -Original Message- Smith Sent: 09 January 2002 15:06 To: Multiple recipients of list ORACLE-L OK, now I have to

Re: grant to public

Not necessarily the public at large. My cousin Gabrielle in Berlin might be considered part of the public in the broad sense of the word, but unless she has access to your database, she won't be able to select on the table. People that *do* have access to your database however *will* be able

RE: Dig it - killer freeware editor

http://www.nedit.org -Original Message- Sent: Wednesday, January 09, 2002 10:55 AM To: Multiple recipients of list ORACLE-L www.vim.org On Tuesday 08 January 2002 10:40, Mohan, Ross wrote: http://www.fixedsys.com/context/ (yes, Virginia, it's oracle-relatedread the site...!)

Re: Dig it - killer freeware editor

vim! Indeed my favorite editor - gvim if I feel a need for a GUI look and feel. If you are a Unix dba, know vi - it is almost guaranteed to be available on every system you touch. Or so a wise man once told me. And, then once it gets in your blood, you forget why you needed another

Re: Clone a database

I have test system (pandora) with the EXACT same disk layout as my production box. I run the SQL below which generates a shell script. While the DB is down for cold backups, I have the operator run clone-db.ksh; which takes less time to complete than the backups. Once it completes I just start

Re: Clone a database

Hi, If the backup was made using OEM, especially in later versions then the backup is a RMAN backup. Please look at your script contents to verify. The documentation discusses how to use rman backups to clone a database. John [EMAIL PROTECTED] wrote: easier perhaps only if you have the

RE: Clone a database

Yes, export may not take longer than file copy if you are cloning a tiny database less than 1 Gb. However, export will always be more complicated to use for cloning, and more error-prone. Some related supporting points can be found at:

Re: grant to public

Hi DBAS if grant select a table to a public, any user would have the select right to this table. am i right? what is real meaning for public? thanks advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City

Re: ORA-600 Parser...

Interesting, thanks for the link. Jared HAWKINS, JAMES W

OCP discount is avaialable still?

Hi List, I would like to know if anyone knows whether the OCP discount for otn memebers is still avaialable? Have been trying in technet.oracle.com without success. Thanks, Surendra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL

RE: Database Comparison

Srini I agree with James. Free tool does a pretty good job. I question it's report of db triggers and views, though. Doesn't seem to be right - it always reports them out of sync for me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 09,

RE: Upgrade to 8.1.7

Dave, make sure you go to 8.1.7.2. It's the last release for 817 on NT and the most bug-free. I'm running it and have no problems at all. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 09, 2002 11:20 AM To: Multiple recipients of list

Re: Dig it - killer freeware editor

other editor?! Glenn Stauffer stauffer@swart

RE: grant to public

Is talking about your cousin Gabby OT? And do you really call her Gabby to her face? -Original Message- Sent: Wednesday, January 09, 2002 12:50 PM To: Multiple recipients of list ORACLE-L Not necessarily the public at large. My cousin Gabrielle in Berlin might be considered part

RE: Clone a database

Thanks -Original Message- Sent: Wednesday, January 09, 2002 1:25 PM To: Multiple recipients of list ORACLE-L Subject:RE: Clone a database This message uses a character set that is not supported by the Internet Service. To view the original message content, open the

RE: Dig it - killer freeware editor

And I've got a .nedit resource file that will highlight all Oracle 8 init.ora parameters here: http://www.westbend.net/~legoman/.nedit At least it works for NEdit v5.1.1 on HP/UX 11.0. Easy to make, too! :) Rich Jesse System/Database Administrator [EMAIL

Re: Database Comparison

There's a very good script available at http://www.dbspecialists.com. --- [EMAIL PROTECTED] wrote: Hi: I need to compare my Production database with QA database. I would like to generate a report that shows differences in schemas across these two databases(tables, indexes, views, object

inconsistency between v$session_wait and v$session?

I must be interpreting something incorrectly here, but I can't figure out what. I was following a session which was waiting (as seen in v$session_wait) for 'SQL*Net message from dblink'. The sequence# wasn't incrementing so I assumed it was pulling back a bunch of data. So next I went to look at

Re: OCP discount is avaialable still?

In recent past it was available and code was 'S36' .PLease check Oracle education site/OCP section. No OTN membership required. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 09 Jan 2002 10:45:25 -0800 Hi List, I would like to

RE: Clone a database

export won't necessarily take longer, but import will almost always take longer than the export by a factor of anywhere from twice to four times. --- Jeremiah Wilton [EMAIL PROTECTED] wrote: Yes, export may not take longer than file copy if you are cloning a tiny database less than 1 Gb.

Re: OCP discount is avaialable still?

Try Discount code S36 when you sign up for an exam. I used it before and it worked for me I did all my exam scheduling at www.prometric.com. Regards, Viktor --- Tirumala, Surendra [EMAIL PROTECTED] wrote: Hi List, I would like to know if anyone knows whether the OCP discount for otn

RE: grant to public

Is talking about your cousin Gabby OT? Not in this context. And do you really call her Gabby to her face? That would be most foolish. Jared

OT - UNIX market

Just curious - anybody knows how is the UNIX market divided between various vendors (sun , HP , Compaq , IBM etc..) ? And how the DB market divided grouped by UNIX vendor ? I believe that DB2 is the leader on AIX , Ms SQL server - on NT , PostgresSQL or MySQL on linux , while Oracle has most

huh? / Re: ORACLE-L Digest -- Volume 2002, Number 009

ORACLE-L Digest -- Volume 2002, Number 009 -- From: Gogala, Mladen [EMAIL PROTECTED] Date: Tue, 8 Jan 2002 13:42:33 -0500 Subject: RE: Oracle Future??? ... win XP is allegedly the worst edition ever when it comes to stability and security. According to

1TB Oracle DB running on Win2K

Just out of curiosity, what is the Win2K configuration? ORACLE-L Digest -- Volume 2002, Number 009 -- From: Andrey Bronfin [EMAIL PROTECTED] Date: Tue, 8 Jan 2002 22:47:36 +0200 Subject: RE: Oracle Future??? ... i have a 1TB Oracle DB running on Win2K.

Database jobs still hot

To cheer up the listers that are searching for jobs, here is an article that says database skills are still in the most demand. And, of course, Oracle is specifically mentioned. http://www.cio.com/staffing/edit/010302_hot.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: OT - UNIX market

Andrey: Gartner and IDC publish several documents on the split of revenues, number of licenses, number of servers, etc. for the unix market. I believe the order is: 1. Sun 2. HP IBM 3. Compaq Tru64 4. Others like Fujitsu, Data General, etc. IBM has gained significant ground in the UNIX

(Fwd) [sacoug] Getting Oracle Experience

PLEASE REPLY DIRECTLY TO: [EMAIL PROTECTED] --- Forwarded message follows --- To: [EMAIL PROTECTED] Date sent: Wed, 09 Jan 2002 13:43:32 - I am interested in being a DBA, and was wondering what the best way to gain experience is. I have

RE: huh? / Re: ORACLE-L Digest -- Volume 2002, Number 009

Yes, how can anyone say that when there are all these great reviews for it out on the 'net, esp. PC World, Cnet. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, January 09, 2002 3:42 PM To: Multiple recipients of list

Re: grant to public

[EMAIL PROTECTED] wrote: Not necessarily the public at large. My cousin Gabrielle in Berlin might be considered part of the public in the broad sense of the word, but unless she has access to your database, she won't be able to select on the table. People that *do* have access to your

RE: huh? / Re: ORACLE-L Digest -- Volume 2002, Number 009

If you are interested in how the reviews and polls work ... check this ... http://news.zdnet.co.uk/story/0,,t269-s2102244,00.html Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed

RE: OT - UNIX market

And every survey I see says that on NT, Oracle and MS SQL are nearly neck-and-neck. I recall this past year MS SQL edged ahead by a tenth-of-a-point market share and Microsoft was really bragging about how they had trounced Oracle. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED]

Re: oemctrl won't start stop ping or check status on Linux

Thanks to all of you the problem was solved after I reboot my server, now everything is working. Thanks again. At 11:18 AM 1/9/02 +0200, you wrote: - Original Message - From: tomas [EMAIL PROTECTED] I am trying to make this thing to work, my original problem was that neither

Tools that Reside on the Server Side of Oracle

I would like to know what are the tools / utilities that reside on the Oracle server? Server Mgr is one. On the client side there is SQL Loader, SQL*Plus, Exp/Imp. etc. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official

RE: Clone a database

From my point of view, exp/imp time is linear with the size of the database and cloning is nearly linear except for the time to copy the files. For a small database, I could do exp/imp much faster. I gave up creating test databases using exp/imp on our largest production database when it grew

Re: OCP discount is avaialable still?

Awhile ago one of the Developers took a PL/SQL course at the Oracle trainig center. This fall we received a voucher redeemable for one OCP exam. Valid until 08/31/2002. It looks like Oracle has realized the cost of OCP hits the DBA's pocket and not the company's pocket and is offering

RE: _system_trig_enabled=false question

More details: I ran initjvm.sql, but none of the other initialization scripts. When applying the patch I ran all the patch scripts (including load_jis.sql, jisja.sql, initjsp.sql). Unfortunately the patch documention doesn't specify that some of them require the other init scripts to be run

Oracle and LDAP servers

Hi In reading MetaLink I have come up with the following list of LDAP servers that are certified for use with Oracle. in 8.1.7 - OID, NDS, Active Directories and iPlanet in 9i - OID, Active Directories Can anyone update this? When they say an LDAP is certified for use with Oracle does this

Re: Tools that Reside on the Server Side of Oracle

Take at look at the files in $ORACLE_HOME/bin on the server.much depends on what you have installed. Then look each of them up in the fine manual. Maybe try the excellent Oracle doc engine at tahiti.oracle.com? -Joe At 12:56 PM 1/9/02 -0800, you wrote: I would like to know what are the

SQL Loader Question

8.1.7 on W2000 I would like to know if there is a way to group more than one parfile into one file? I would like to run just one file verses a number of parfiles. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L

RE: Clone a database

Oops, my bad. I meant to say that exp/imp time is nearly linear and cloning is constant regardless of the database size. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 09, 2002 3:02 PM To: Multiple recipients of list ORACLE-L From my

RE: OCP discount is avaialable still?

"Continuing Education" if you want Cheers!, JoJo From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ron RogersSubject: Re: OCP discount is avaialable still? I wonder if I have to claim the cost on my taxes??? ROR mª¿ªm

Re: Tools that Reside on the Server Side of Oracle

Actually SQL*Plus, Exp/Imp, SQL*Loader also can and most times do reside on the server. You also have java tools dbca and netmgr with 9i. On Wed, 2002-01-09 at 14:56, Ken Janusz wrote: I would like to know what are the tools / utilities that reside on the Oracle server? Server Mgr is

Veritas Quick IO Oracle Performance

I was asked to evaluate the potential benefit of using Veritas Quick I/O for one of our databases. I put together some simple tests to gauge the expected impact of Veritas Quick I/O on Oracle performance. The tests were designed so that the only variable when running the test scripts was type of

RE: OT - UNIX market

Surveys paid for by who? See who's footing the Bill so to speak. Scott Shafer San Antonio, TX 210-581-6217 Common sense will not accomplish great things. Simply become insane and desperate. -Original Message- From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, January

reading variables

If I use the following for to reference a variable in my code: Update Primus_Temp_Dump set owner =(test) where secure_id = Secure; I get this compile error: PLS-00103: Encountered the symbol when expecting one of the following: This is how you are supposed to reference variables in a SQL

Re: reading variables

variables work fine in sqlplus but not anywhere else, In what tool are you programming? [EMAIL PROTECTED] wrote: If I use the following for to reference a variable in my code: Update Primus_Temp_Dump set owner =(test) where secure_id = Secure; I get this compile error: PLS-00103:

Re: reading variables

Do a SHOW DEF at the SQL prompt. What does it show? If anything other than , do a SQL Set def Raj Lance Prais [EMAIL PROTECTED]@fatcity.com on 01/09/2002 05:35:21 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL

  1   2   >