Problems with SQL Server Link Server to ORACLE

Title: Problems with SQL Server Link Server to ORACLE Hi List, Problem receiving this error on a Link Server from SQL Server 7.0 and 2000 to Oracle 817 INSERTED INTO IR TABLE IR_MAXIMO_WORKORDER [SQLSTATE 01000] (Message 0) INSERTED INTO MAXIMO TABLE MAXTFMC..MAXIMO.IR_WO_IN [SQLSTATE

IOTs - based on primary keys vs based on universal rowids

Hi, The 817 SQL Reference guide under the analyze table section, states the following: Note: If you are analyzing index-organized tables based on primary keys (rather than universal rowids), you must create a separate chained-rows table for each index-organized table to accommodate its

characterset database

hi all we use 2 different character sets on our oracle servers one sap server uses US47ASCII and our delphi-oracle server uses WE8ISO8859P1. can anyone tell me what the difference is and which problems i can encounter. g.g. kor rdw ict groningen the netherlands -- Please see the official

Enterprisemanager?

Hallo, Does anyone know if there is a graphic interface in Oracle, which you can use to move data betwen tables and also to schedule tasks? Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network

RE: Duplicating a Database and Changig SID

Yes, please, I'm very interested. Sonja -Original Message-From: Ron Yount [mailto:[EMAIL PROTECTED]]Sent: Friday, November 30, 2001 12:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Duplicating a Database and Changig SID If you are using RMAN and would like

RE: characterset database

g.g, The fundamental difference is that US47ASCII is a 7 bit set and WE8ISO8859P1 is an 8 bit set. The main problems you can potentially encounter are the assumed 8th bit conversion when the database using the US47ASCII set stores a character like an accented 'e' in the French Alphabet. When

total tranx ran

Hi lists, Does anybody have a query to find , how many transactions ran since the instance started. v$transaction will have only the current trnx running. is there any other views that will show the total trnx since instance startup. Thnx and regards, Srinivas -- Please see the official

RE: total tranx ran

Is there any column related to this in v$resource_limt ? -Original Message- Sent: Friday, November 30, 2001 7:05 AM To: Multiple recipients of list ORACLE-L Hi lists, Does anybody have a query to find , how many transactions ran since the instance started. v$transaction will have

RE:

Hi Steve, We've had the same problem: a lot of DG machines, and we had to find a replacement. We also have Clarion disk cabinets, and that was one of the reasons we chose for SUN. Don't worry about the quality: SUN is at least as good as DG (in our experience). I don't know anything about the

Re: Crontabs and Oracle

On Thu, Nov 29, 2001 at 11:15:43AM -0800, [EMAIL PROTECTED] wrote: I've seen a number of suggestions for sourcing .profile in the cron jobs, but this is not always a good idea, as .profile often contains script that will not execute when not attached to a tty. I think sourcing .profile is

RE: Problems with SQL Server Link Server to ORACLE

Title: Problems with SQL Server Link Server to ORACLE See if your connection can perform some sort of select via the ODBC in SQL I have been playing around with moving data from Oracle to SQL via a DTS package And got some nasty error messages when the columns were mismatched(for

RE: Enterprisemanager?

Title: RE: Enterprisemanager? Yip, spot on here. You can do exports etc to move the data if you want via the gui. Clint -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 1:35 PM To: Multiple recipients of list ORACLE-L Subject: RE:

Forms debug mode and procedure-based technique

A developer is having problems with Forms 6i in debug mode. He can load a large form and run it, but when he tries to run it in debug mode the form hangs before he even sees the debug window. He is wondering if anyone has experienced problems with the Form Builder debug mode against what he

RE: Control files Redo Logs

Yea it is - if you have enough disks, and I take it you are going to mirror this as well, and not have *all* of your control files or on the *same* disk? -Original Message- Madan Sent: 30 November 2001 05:05 To: Multiple recipients of list ORACLE-L Hi!!! Is it a good idea to put redo

Connecting Sybase from Oracle

Hi All, Does anyone know if there is a way to link Sybase (11.9.2.9) database with oracle database (8.1.6) . What I need is pass some data from Sybase DB to Oracle DB on daily basics . Thanks , Vijayakumar K -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: Not able to view table

Jyoti, Did you create the tables as SYSTEM? One thing I will say is that *YOU SHOULD NOT DO THIS*. When creating objects as SYSTEM, these objects will be stored in the SYSTEM tablespace - which is not a good idea. As system, create another tablespace (if one does not already exist), create a new

stripes, partitions, and spindles

Good morning all, We have purchased new IBM AIX boxes and the guy whole sold them to us is here puting them together. ( He used to work for IBM.) The question rises again, do I put my tablespaces on separate spindles, e.g. Data on one, Data2 (big extents) on 2, Index1, Index2 all on separate

RE: Connecting Sybase from Oracle

Take a look at the Transparent Gateway products available from Oracle: http://otn.oracle.com/products/gateways/pdf/sybase816.pdf HTH Mark -Original Message- Vijayakumardk Sent: 30 November 2001 12:30 To: Multiple recipients of list ORACLE-L Hi All, Does anyone know if there is a

RE: RE: RE: Siebel.

You'd almost have to be God to fix it.it consists of 1000s of tables. It took me 2 weeks to reverse into Designer. My customer is not welling to pay for the time to fix the design. Mohan, Ross [EMAIL PROTECTED]@fatcity.com on 11/29/2001 04:17:58 PM Please respond to [EMAIL PROTECTED]

Export Problem - Urgent

Hi, I am trying to export a data from server and getting following error message: EXP-00041: Export done in server's WE8ISO8859P1, different from user's character set US7ASCII EXP-0: Export terminated unsuccessfully How do I fix a problem. My environment is SUN OS

RE: stripes, partitions, and spindles

Ruth: Get a copy of the Oracle8i DBA Handbook by Loney Theriault. Chapter 4's topic is Physical Database Layouts. It goes from 22 disks down to 7. Hope this helps, Ken -Original Message- Sent: Friday, November 30, 2001 6:55 AM To: Multiple recipients of list ORACLE-L

RE: Export Problem - Urgent

You should try changing the nls_lang value on the client to match the server. Rick -Original Message- Sent: Friday, November 30, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Hi, I am trying to export a data from server and getting following error message: EXP-00041:

Re: Control files Redo Logs

There's no point in mirroring control files on the same disk. Control files should be mirrored across disks. That way, if one disk crashes you can get a copy of the current control file from another disk (or just drop that control file from your init.ora file). Control files are small and have

Re: Control files Redo Logs

Thanks! That is what I thought but you know the system folks think they know more that us DBA's. And my boss thinks she know everything... Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 30, 2001 7:25 AM Yea it is - if you

Re: stripes, partitions, and spindles

Let's see if I can remember a summary of our last discussion on this. RAID 10 (mirror then stripe) is the way to go unless it's a decision support database (mostly read only) in which case RAID 5 takes fewer platters. If you have enough spindles, I personally would treat them as disks and go

RE: rman disk channel destination

Title: RE: rman disk channel destination Thanks Deepak, Steve, Dennis, Jack... I was hoping I could set a default destination for the target database I guess. Looks like that's not the case. I can live with this, though. Gracias Lisa -Original Message- From: Deepak Thapliyal

RMAN disaster recovery

I am wondering how RMAN would work for disaster recovery. Our manager's statement is assume your server is reduced to a pile of ash. Now take your backup tape and build me a new system on a loaner from the vendor. I am trying to figure how that would work with RMAN. We are still at the stage of

RE: Standby Database

Kay, thanks for the explanation. Sorry for being a pain in butt. But I see that the C program will write IMMEDIATELY AS SOON AS the log is written. But this is not the same as doing it simultaneously. So there is a chance (very very small of course) that after LGWR writes the committed

Re: Control files Redo Logs

There are advantages to oracle mirroring the redo logs. In the case of corruption, hardware or os level mirroring will duplicate the corruption accross the mirror. In the case of Oracle mirroring, Oracle should detect the corruption and write to the valid redo members. From: [EMAIL

RE: Crontabs and Oracle

Tim, Sourcing a .profile within cron jobs is not a good way doing a shell scripting. One big reason --- A .profile might contain a lot of functions which are OK if you are loggin in with that specific user id. And those functions might be doing some job that might affect the cron job. In my

RE: PATCH confirmation

From your patch number, I assume you're Sun/Solaris. On a 3500 with 4 cpu's, patch took nearly 30 minutes. On a 4500 with 8 cpu's, patch took about 20 minutes YMMV Barb -- From: Nikunj Gupta[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday,

portable statistics

Good morning again, I know that in 8i you can move statistics where you clone a database. Is it possible in 8.0.6.3? Thanks! Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

RE: PATCH confirmation

btw... When you apply this patch, the installer will likely tell you that the patch needs an addtional 500 megs on your /oracle partition (on top of the space already consumed by 8.1.7.0). This is an Oracle faux pas. 8.1.7.2 takes about 20 megs more than 8.1.7.0 already consumed. --

Re: RMAN disaster recovery

I have never tried to burn my servers to ash, but I usually try to put the rman catalog on a different server than the ones that it is backing up. You also need to backup the catalog, which I do w/ a nightly export. From: DENNIS WILLIAMS [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To:

Re: stripes, partitions, and spindles

Thanks all, I am going to give the IBM guy the book after I read it. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 30, 2001 8:30 AM Ruth: Get a copy of the Oracle8i DBA Handbook by Loney Theriault. Chapter 4's topic is

Re: rman disk channel destination

Lisa, I don't think that the channel has a location. It is like a pipe to take data from the db to the backup destination or put it back. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 4:30 PM This info isn't

RE: Duplicating a Database and Changig SID

Sonja, Here are my rough instructions for how to duplicate a database (by copying files) and then how to alter the database name (typically referred to as "cloning" a database). At the end, you will find how to alter the dbid so that RMAN will see it as a new database. Be sure to

DISK LAYOUT RAID LEVEL

Hi, We have to do benchmarks tests(scalability,performance) for our product and have machine with following configuration..We dont have experience for large size databases layout. It will be greatly appreciated if someone points out from his experience: 1) Which raid level to use for which

RE: PATCH confirmation

So, patch installation is not scalable? -Original Message- Sent: Friday, November 30, 2001 10:07 AM To: Multiple recipients of list ORACLE-L From your patch number, I assume you're Sun/Solaris. On a 3500 with 4 cpu's, patch took nearly 30 minutes. On a 4500 with 8 cpu's, patch took

RE: PATCH confirmation

This also happens in patch 8.1.6.1.0 for Solaris 7 64-bit. Really annoyed me last night when Oracle said I needed 412M of space to apply the patch and then didn't use it. Julie Fisher Sandia National Laboratories Oracle 8i DBA - OCP8i Solaris 2.6,7/HP-UX 11.0 System Administrator Web Server

* Oracle 8i DBA Needed in New York City..

*Description: International news and media organization in New York City, New York has an immediate need for a senior level ORACLE 8i DBA to join their team of DBAs. There are many exciting projects on which you would participate including an SAP implementation, CRM applications implementations,

RE: RMAN disaster recovery

Dennis, RMan is able to restore files to different locations with the following command: run { sql 'ALTER TABLESPACE tbs_3 OFFLINE IMMEDIATE'; allocate channel ch1 type disk; set newname for datafile '/oracle/dbs/tbs_33.f' to '/oracle/temp/tbs_33.f'; restore tablespace

RE: SqlSever 2000 question

Title: RE: SqlSever 2000 question But, that's not normal :) I can't think of a way to do that with standard SQL, however in transact sql (which is SQL on SqlServer) you do have flow control and cursors and string functions. However, cursors with SqlServer are really slow. Only use them

Oracle client compatibility with Windows XP

Hi According to Metalink note 161546.1 you need at least the 9.0.1 Oracle client for Windows XP. We are currently using the 8.1.7 client to go against 8.1.7 databases and 7.3.4 databases. Does anyone know of any issues when you use the 9 client against 7.3.4 databases? Thanks, Ben -- Please

RE: Duplicating a Database and Changig SID

Ron, I was trying to open your attached document. I get this error: encoded content removed -- binaries not allowed by ListGuru Could you pl. send this doc as .txt file to me ? I would really appreciate that. thanks Santi -Original Message-From: Ron Yount [mailto:[EMAIL

Re: stripes, partitions, and spindles

Oracle's thoughts on the matter can be found at: http://technet.oracle.com/deploy/performance/pdf/opt_storage_conf.pdf Ruth

RE: Duplicating a Database and Changig SID

Same here Ron.will really appreciate it if u could send me the file at my email id as an attachment..I think the LIST doesnt support attachments..else, a text file will also help. Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL

Re: RMAN disaster recovery

Dennis, We have all of our RMAN catalogs on a small unix server that is fairly isolated and doesn't have much else on it. We also backup up the databases that contain those catalogs to other catalogs using RMAN to a second small, isolated UNIX server. In addition, we also take logical backups

RE: total tranx ran

if you're using Oracle 8 check v$resource_limit.transactions view HTH Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 30, 2001 7:05 AM Hi lists, Does anybody have a query to find , how many transactions ran

Oracle and UDB

Hi Does anyone know if there is a comparison about Oracle and UDB anywhere? I need some ammo for a discussion going on here. Also does anyone have experience running Oracle Forms against UDB? Thanks in advance Raj __ Rajendra Jamadagni

Re: DISK LAYOUT RAID LEVEL

http://technet.oracle.com/deploy/performance/pdf/opt_storage_conf.pdf Harvinder Singh

RE: Duplicating a Database and Changig SID

This is not real pretty as text, if you want a MS Word copy, send me your e-mail. [EMAIL PROTECTED] The purpose of this document is to define the process and commands necessary to duplicate (clone) an existing database and alter its Database Identifier (DBID). There are two separate

Re: * Oracle 8i DBA Needed in New York City..

There are many exciting projects on which you would participate including an SAP implementation, CRM applications implementations, and data migrations from other databases to ORACLE.=20 We musn't have the same definition of 'exciting'. -- Diese E-Mail wurde mit http://www.mail-inspector.de

Re: portable statistics

If you genuinely clone a database ie copy the datafiles, then the stats will also be transferred. Other than that, you would need dbms_stats which comes only at 8.1+. You could always hack the internal sys tables - probably not the wisest option to persue :-) Cheers Connor --- Ruth Gramolini

oracle hangs, but why?

Hi. I'm running oracle 8172 on AIX SP 4.3.3 in ops mode on 4 nodes. I have noticed that the queries that are trying to read the GV$ tables are hanging, while those using the V$ tables don't. I have looked at the locks/waits on each node, but didn't see anything unusual (or may be I missed).

32-bit Oracle on 64-bit Unix

Hi - We are about to upgrade a Unix box (Sun Solaris) to version 8 (2.8). Someone mentioned that we can't run the 64-bit version because that would require the 64-bit version of Oracle. I thought that you could run the 32-bit version of Oracle on a 64-bit operating system. Am I wrong?

RE: Duplicating a Database and Changig SID

thanks Ron. this will work. -Original Message-From: Ron Yount [mailto:[EMAIL PROTECTED]]Sent: Friday, November 30, 2001 9:06 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Duplicating a Database and Changig SID This is not real pretty as text, if you want a MS

Re: Crontabs and Oracle

Tim, Sourcing .profile may be the 'right' thing to do technically, but I suppose it really hinges on the environment. If it works as is, then fine. If not, changing .profile and/or .kshrc may not be an option. In a medium to large shop, changing the .profile or .kshrc can be rather

oracle hangs, but why?

look at dlm configuration at the os level...pings? up/down converts normal? apply all patches. also look at UDP buffer size settings in the kernel. Oracle DLM use udp vice tcp and bad buffer sizes cause hangs. hth Ross Mohan -Original Message- Sent: Friday, November 30, 2001 12:12

Has anyone heard of Mirror Accessible?

My CIO woes continue. My manager has been told by the CIO that Oracle has a product called mirror accessible which allows the database to be mirrored for reporting purposes. He wants us to use this product. Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle Standby and Oracle

Re: stripes, partitions, and spindles

Thanks! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 30, 2001 11:25 AM Oracle's thoughts on the matter can be found at: http://technet.oracle.com/deploy/performance/pdf/opt_storage_conf.pdf Ruth

RE: Not able to view table

Hum, must disagree (sort of). Although I don't recommend creating objects as system normally the first thing I do when I create a database is change the default tablespace of all users except sys. OK, it might not be the first thing I do, but its up there in the beginning somewhere. You could

RE: Crontabs and Oracle

What I did is create a file that sets the environment for each database. This file is sourced in my profile as well as any script I create. Therefore, when it comes time to put a script in cron I do nothing but place it in there. Plus, that gives me one spot I ever have to change when I upgrade.

Some 9i Questions - Help!

An edict just came down from our CIO that we should upgrade all our databases to 9i by the end of the year (he's decided it's important that we always be on the latest release of all software). Aside from the fact that other than a small play database we haven't done any testing yet, aside from

RE: Duplicating a Database and Changig SID

Looks ok to me. If its useful people will read it in any format:-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ron YountSent: Friday, November 30, 2001 9:06 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Duplicating a Database

RE: 32-bit Oracle on 64-bit Unix

You can. I had it running on many boxes at Fujitsu (before they shut their doors that is). Only thing to keep in mind is memory utilization. Oracle 32 bit will only allow you to utilize 1.75G total (all instances). There is a thing called memory windows on HP that removes that but puts a

RE: RMAN disaster recovery

Also, if that is the type of recovery he wants then sell him on a standby database. If you lose your server that severely you will only be able to get back to the last backup regardless of where your recovery catalog is (hopefully on another server or at least backed up). -Original

RE: 32-bit Oracle on 64-bit Unix

You should have no problem running 32-bit Oracle in a 64-bit OS environment. Gerardo -Original Message- Sent: Friday, November 30, 2001 9:33 AM To: Multiple recipients of list ORACLE-L Hi - We are about to upgrade a Unix box (Sun Solaris) to version 8 (2.8). Someone mentioned that

RE: Has anyone heard of Mirror Accessible?

Only thing I can think of off the top of my head is a standby database opened in read only mode. Its one of the purposes totted for that -Original Message- Sent: Friday, November 30, 2001 9:47 AM To: Multiple recipients of list ORACLE-L My CIO woes continue. My manager has been

Re: Some 9i Questions - Help!

HI Jay, Oracle9i on Solaris has been around since April ofr May of 2001. Good Luck JH [EMAIL PROTECTED] wrote: An edict just came down from our CIO that we should upgrade all our databases to 9i by the end of the year (he's decided it's important that we always be on the latest release of all

RE: Some 9i Questions - Help!

Try and get him to delay for the new 9i release 2 that is coming soon. New features and all that. I do not believe its coming out this year so if you sell it good enough you get Christmas back. -Original Message- Sent: Friday, November 30, 2001 9:52 AM To: Multiple recipients of list

RE: Not able to view table

Mark, I am a really confused with your last statement. Have you tried either of the following: select * from tblBundleCon; select * from 'tblBundleCon'; If you really did create them in lower and upper case, this could be your problem. Enclosing the table names in double quotes usually solves

Freelist question.

I have some stats tables to collect statistics. So I have to insert about 500K records into each table per day. It seems like it has some contention CLASS COUNT data block 1298 free list 0 How do I determine how

Testing

Testing to see if the server is working properly. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: Has anyone heard of Mirror Accessible?

9i has a new feature on standby databases that let's you run reports in read only while continuing the managed recovery. I think they call it a logical standby database. See the 9i DataGuard manual for more information. (I just happened to be looking into this lately). This might be what they

Ang: Testing

It is [EMAIL PROTECTED]@fatcity.com den 2001-11-30 10:40 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Testing to see if the server is working properly. Jared -- Please see the official ORACLE-L

RE: Has anyone heard of Mirror Accessible?

Jay - I did a search on Google and that returned nada, so I don't believe that mirror accessible is a bona fide term. However, looking at your words Oracle has a product . . . database to be mirrored for reporting purposes, he might be referring to Oracle9i's Real Application Clusters.

Oracle Apps Hints and Techniques

This paper by Craig Ward is a pretty good guide for those dba's new to Oracle Apps. It has pretty good coverage on applying patches among other goodies. http://www.adm.uwaterloo.ca/infofsp/fspupg/techdocs/AppDBAHints.pdf Gerardo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Resume issues - (Not posting my resume)

My resume that gets passed around EDS accounts is 5 pages. That is a little long for applying for jobs outside of EDS. I was wondering how other folks who work for the same type of companies shorting this (companies like CGI, XWave, etc) where you get billed out to various contracts. If my

RE: Has anyone heard of Mirror Accessible?

Ah, this sounds likely. And it might explain why they were keen on having us upgrade to 9i. That's the problem with receiving the request filtered through two additional levels of people. Jay Miller -Original Message- Sent: Friday, November 30, 2001 1:56 PM To: Multiple recipients of

RE: Resume issues - (Not posting my resume)

Kimberly - From my admittedly meager experience of job-hunting for both permanent and contract work, here is my impression: 1. If the resume is for permanent work, keep the resume brief and to the point. The objective is to keep HR from tossing your resume. Keep it to a single page and hit the

RE: Has anyone heard of Mirror Accessible?

Isn't that just in release 2 though? My understanding is that its not out yet. -Original Message- Sent: Friday, November 30, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Ah, this sounds likely. And it might explain why they were keen on having us upgrade to 9i. That's the

RE: Crontabs and Oracle

Good idea. Rao -Original Message- Sent: Friday, November 30, 2001 12:52 PM To: Multiple recipients of list ORACLE-L What I did is create a file that sets the environment for each database. This file is sourced in my profile as well as any script I create. Therefore, when it comes time

Re: Has anyone heard of Mirror Accessible?

There seems to be a bit of confusion here. RAC is not related to standby database. DataGuard is the big enhancement for standby databases in 9i. RAC is the name for the 9i incarnation of OPS (Oracle Parallel Server.). If the database to be mirrored, then it is completely independent of

RE: Some 9i Questions - Help!

How the CIO Stole Christmas ... The Grinch would be jealous! We upgraded a small-ish production database to 9i in August 2001 on Solaris 2.8. Took no more than 1.5 - 2 days as I recall. Much more time to read the manuals though. Look at this list's archive and MetaLink for bugs and gotchas.

RE: RMAN disaster recovery

Thanks for the input, Cherie, Kimberly, Tom The part I'm still uncertain is as follows - see the sentence in caps below: On my current system let's say I have RMAN write its backup file to a disk location /ora01. I also have my RMAN catalog on a separate server, and have written an

RE: Deleting files on w2k

Title: Deleting files on w2k Lisa, you can take it offline, and it may release it. on NT, it does not release the file unless it is not in use. W2k might be different. Tom Mercadante Oracle Certified Professional -Original Message-From: Koivu, Lisa [mailto:[EMAIL

Re: Deleting files on w2k

Title: Deleting files on w2k This has always been a "testing issue" with winnt or win2k. Files being read are "locked" by the OS. I know of no way to override this behaviour. JH [EMAIL PROTECTED] wrote: I'm trying to test out backup and recovery on w2k. However, I can't remove or

RE: Resume issues - (Not posting my resume)

Dennis -- I sent Kimberly my tips offline (and my resume) but thought I would forward my tips based on nearly 24 years of experience to you folks in case you find it of value. If so, great, if not, oh well, but they were lessons learned over the years and apply to all jobs, contract and perm.

RE: Deleting files on w2k

Title: Deleting files on w2k Um, port it to Unix -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: Friday, November 30, 2001 12:40 PMTo: Multiple recipients of list ORACLE-LSubject: Deleting files on w2k I'm trying to

UTF8 or AL16UTF16

Title: Deleting files on w2k Hi, We need to store the unicode data in column defined as varchar2 datatype so we have to use unicode data set. In 9i which is the preferred value for (NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET) UTF8 or AL16UTF16 and why? Thanks -Harvinder

RE: Has anyone heard of Mirror Accessible?

Can anyone confirm this? I've been searching technet and metalink and can't turn up any details. -Original Message- Sent: Friday, November 30, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Isn't that just in release 2 though? My understanding is that its not out yet.

RE: Has anyone heard of Mirror Accessible?

Dataguard is available in 901 ... of course we don't use it. oraclei@angel-TICK2 dgmgrl DGMGRL for IBM/AIX RISC System/6000: Version 9.0.1.0.0 - Production. (c) Copyright 2001 Oracle Corporation. All rights reserved. Welcome to DGMGRL, type help for information. DGMGRL help The following

RE: Resume issues - (Not posting my resume)

Bambi - Excellent. I printed it and it is going into my off-site repository. I especially like your point to Make Your Resume Friendly to The People Making Small Piles of Big Piles. If you've gotten to meet the people that could hire you, then the resume is just a nice addition to your stunning

RE: Some 9i Questions - Help!

Jay, Apart from our outstanding RAC problem, I don't have any complaints *right now* about our instance. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and

RE: Has anyone heard of Mirror Accessible?

I'm sure it has a few bugs in Metalink against it so a responsible site wouldn't implement it until after Jan. 1. ;-) -Original Message- Sent: Friday, November 30, 2001 4:00 PM To: Multiple recipients of list ORACLE-L Dataguard is available in 901 ... of course we don't use it.

RE: Some 9i Questions - Help!

I was just wondering... does he have pointy hair? ; ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Miller, Jay [SMTP:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 1:52 PM To: Multiple recipients of

RE: GRANT REFERENCES

What SQL or PL/SQL are you trying to run? -Original Message- Sent: Thursday, November 29, 2001 12:53 PM To: Multiple recipients of list ORACLE-L Thanks for your reply Paul. Would you be kind enough to elaborate on the 3rd point. I thought I followed but what I implemented gave me

RE: RMAN disaster recovery

I START TO LOAD THE RMAN BACKUP FILE TO /ora01 AND DISCOVER THE NEW SYSTEM DOESN'T HAVE THAT DEVICE. Do I simply create a link and RMAN will be fine with that? I vaguely recall that prior versions of the docs did not support this but now I see no such non-support warning from Oracle (in the

RE: Resume issues - (Not posting my resume)

I have to agree. In the end I did shorten it but its three pages now. Not quite as experienced;-) I did move a few things around so that my technical stuff is the first thing they see. Hopefully I won't have to use it and I get another contract within the organization but better safe then

  1   2   >