Re: Partitions of table read only

I think Daniel covered this when he mentioned that a transaction can consist of many statements - some of which Oracle may not yet be aware of. Until a user decides to commit or rollback then there is a possibility that a transaction may head into that tablespace. Of course it would be nice to

Re: MySQL in the future?

On Wed, Jun 18, 2003 at 09:10:39AM -0800, M Rafiq wrote: Tim, May be a an off-topic question to you or anybody who can answer. What is the best source / books to learn mysql quickest possible without too much cost to an individual? The online docs are good:

PLS-00907: cannot load library unit

RDBMS 8.1.7.4 on Sun Sparc Solaris 5.8 Package USR1.PACKAGE1 on DB1 references USR2.PACKAGE2 on DB2, which in turn references USR2.PACKAGE3 on DB2. Sometimes the package body of PACKAGE1 refuses to compile, giving the error PLS-00907: cannot load library unit [EMAIL PROTECTED]

RE: Oracle Financials 10SC on HP-UX rev 11

As HPUX 10.2 and 11 are not object-file compatible, you must obtain all the software that you are using [ie Oracle 7.3.4, Developer 1.3.2 or 1.3.3, Apps 10.7 and *every* applications patch {or the highest patchset for each module plus any further standalone patches that you may have applied}

Re: ORA-01555 with Automatic Undo Management mode

Are you certain that the 1555 was caused by extent stealing? Nope, not certain at all. [EMAIL PROTECTED] 06/18/03 09:54PM Darrell, The space management algorithm is such that free extent acquisition is the second method for undo allocation. The first is claiming expired extents from the

RE: Oracle releases by the different platforms...

Title: IOUG Live 2003 NO PLEASE don't tell me that we have been coupled with Windows Say it aint so!!! I'm thinking we really need to migrate from AIX to Linux! April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own

Re: AQ, RAC and delay

Although MCPD may default to 700centiseconds [although I have seen a much lower value on 9.2 on Tru64], in most cases, delays of 7seconds don't occur [and shouldn't be acceptable ?!]. I do have a 9iRAC environment but am comfortably using mcpd=0. And I have AQ in an 8.1.7 single-instance

Passwords and authentication

Title: Passwords and authentication Is it possible to connect to database using encrypted passwords? Using sqlplus? Thanks Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are

APPS 11i (Linux) question

Hi Group, I'm installing apps 11.5.8 on Linux 8. Rapidwiz, first unzipping some 55 components. After 54th component is hanging and the unzip process is getting "defunct". Anybody faced the same issue during the installation. Any help on this Reg. Thanks, Senthil.

Re: Partitions of table read only

Mark, You are understanding the terminology and concepts correctly. Until the transaction completes, there is no way for the system to know which objects the transaction will access. More food for thought...I am updating tableA in the non-RO tablespace. However, there is an

Re: Upgrade gotchas - 8.1.7.4-9.2.0.3 on Windows

Title: Upgrade gotchas - 8.1.7.4->9.2.0.3 on Windows Lisa, Just a follow-up question. I've set the ORA_SID_PFILE parameter in the registry, but do not use a password file. When I start up the database it looks for the PFILE in the default directory instead of the path specified in the

RE: Oracle releases by the different platforms...

Change to Tru64. It isn't on the list (a harbinger of things to come?), so you don't have to worry about being coupled to anybody; you can enjoy your status as a black sheep orphan then. -Original Message- NO PLEASE don't tell me that we have been coupled with

RE: Oracle releases by the different platforms...

This may not be a bad idea in the not too distant future April! : http://theregister.com/content/53/31234.html SCO pulls AIX licence, calls for permanent ban By Ashlee Vance in San Francisco Posted: 16/06/2003 at 22:54 GMT Terminating IBM's AIX licence

RE: MySQL in the future?

I think we've all seen and are once again seeing a similar maneuver. Can you get MySql from mysql.org, sure but it's going to be left way in the dirt by MySql AB until their version is the only acceptable one out there. Course by then it probably will acquire a different name. and of course a

INDEX REBUILD

Hi, Is any view available which can tell us indexe rebuild status in 8i? Means how can we know these are indexes rebuilded recently? thx -Seema _ The new MSN 8: smart spam protection and 2 months FREE*

RE: Partitions of table read only

Maybe because drop table is actually a modification of the data dictionary. I recall that Oracle training thing where they have you start a long-running select on a table in one session, then drop the table in another session, and the select on the dropped table keeps on running OK. It does seem

RE: AQ, RAC and delay

Hemant: You are right. 7 seconds is the MAX difference, but the control files are synced every 3 seconds during the 'split brain' check. So most of the cases, it is 3 seconds with the maximum of 7 seconds subject to the MCPD settings. KG Best Regards,K Gopalakrishnan -Original

RE: Oracle releases by the different platforms...

Title: RE: Oracle releases by the different platforms... I think everyone should read http://www.forbes.com/2003/06/18/cz_dl_0618linux.html Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed

Re: ORA-01555 with Automatic Undo Management mode

I looked through metalink (doc 40689.1) and I don't see how the delayed block cleanout scenario could happen (in my case) given that there was only one transaction running. I'm still stuck with that last 4g block that was allocated with only 3G of free space remaining. Also, that filespace was

RE: MySQL in the future?

Richard, Now this is interesting. When you enter www.mysql.org into your browser you get forwarded onto www.mysql.com. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, June 18, 2003 5:15 PM To: Multiple recipients of list ORACLE-L

RE: MySQL in the future?

I say it's time to resurrect ndbm! We KNOW that one is free ... and it's already there in your OS utilities (if you are using the right OS). -Original Message- I think we've all seen and are once again seeing a similar maneuver. Can you get MySql from mysql.org, sure but it's

Re: Partitions of table read only

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 5:59 AM Jack, maybe this has been covered. I seem to recall from the BR module (knew it would prove useful sometime) that after you make a tablespace read-only that you should

RE: AQ, RAC and delay

With MPCD=0, Is your primary wait event shown as on-going reading of SCN to complete in the statspack reports? Oracle Support insisted we set it to 7 coz of this. Raj

RE: MySQL in the future?

We've been using MySQL extensively for three years now and haven't seen any of this kind of behavior. In fact, MySQL AB has been very enjoyable to work with and we've been able to bend their ear to put features into MySQL that we'd like to have. And, as Tim Bunce says, we've found their support to

RE: INDEX REBUILD

encoded content removed -- binaries not allowed by ListGuru The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender

Re: APPS 11i (Linux) question

Senthil Kumar D wrote: Hi Group, I'm installing apps 11.5.8 on Linux 8. Rapidwiz , first unzipping some 55 components. After 54th component is hanging and the unzip process is getting defunct. Anybody faced the same issue during the installation. Any help on this Reg. Thanks, Senthil.

Re: Oracle releases by the different platforms...

April Wells wrote: NO PLEASE don't tell me that we have been coupled with Windows Say it aint so!!! I'm thinking we really need to migrate from AIX to Linux! You have until midnight Friday... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

9i Ques

Hi Group, What is the default value of Undo_retention? a. 900 b. 0 c. 10800 d. None of the above I have selected option a. The answer given by the system is c. Which one is right. I have checked out with oracle doc's. It says 900. But db (which has default parameters) says 10800.! Any

RE: Oracle releases by the different platforms...

Mark - Good article. What I've seen in the press on the story behind the headlines is that the lawsuit is all SCO has left. Hicks has hinted that a buyout from IBM would be an okay thing. Sounds like he wants to ratchet up the noise until IBM feels it is cheaper to buy SCO and bury the issue. I'm

RE: MySQL in the future?

How can a honest DBA become a lawyer? It seems to me that technology has become dependent on lawyers. If AIX is stopped, it will be a disaster of biblical proportions which will seriously disrupt business. I believe that the future lies in litigation, not technology. As for MySQL, it has never

RE: INDEX REBUILD

Seema - If you analyze in conjunction with rebuilds, you could track with the LAST_ANALYZED column in USER_INDEXES table. That is all I can think of. Why do you ask? Jared has spoken eloquently about how frequent index rebuilds can reduce your performance. Dennis Williams DBA, 80%OCP, 100% DBA

Re: MySQL in the future?

Tim, Thanks Regards Rafiq Date: Thu, 19 Jun 2003 02:24:39 -0800 On Wed, Jun 18, 2003 at 09:10:39AM -0800, M Rafiq wrote: Tim, May be a an off-topic question to you or anybody who can answer. What is the best source / books to learn mysql quickest possible without too much cost to an

RE: MySQL in the future?

There's a specific reason for that - mysql.org was run by NuSphere, a company that released an extended version of MySQL with a custom database engine. Mysql the corporation sued for trademark infringement on the name mysql, claiming that customers would be confused that the mysql.org listed

RE: Bewildered by RMAN

Another poster had suggested CHANGE archivelog all VALIDATE; This fixed the problem. Oh, and I do have your book. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 18, 2003 3:04 PM To: Multiple recipients of list ORACLE-L

RE: MySQL in the future?

I'll second Tim's choices. Got both books and they're excellent. BTW, I got the MySQL Cookbook at the Rocky Mountain Oracle Users Group Conference. :) --Walt Weaver Bozeman, Montana -Original Message- From: M Rafiq [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 10:10 AM

Oracle 9i and streaming technology

Have a client that is using Linux and Oracle 9i. They are attempting to do live inventory on 5 branches using streaming technology, but when it kicks it, it literally shuts the network down... If you are not in before it starts you can't get on. It appears to do this to all 5 branches.

Re: memory swapping and rollback

David, Commit frequency can help or hurt performance. The more often you commit, the more often undo blocks will be reused. This will also cause the log buffer and committed blocks in the buffer cache to be flushed. If you commit less often, these actions happen less often, but undo

Re: MySQL in the future?

Goulet, Dick wrote: I think we've all seen and are once again seeing a similar maneuver. Can you get MySql from mysql.org, sure but it's going to be left way in the dirt by MySql AB until their version is the only acceptable one out there. Course by then it probably will acquire a different

Re: Passwords and authentication

Title: Passwords and authentication Raj, My first question will be howyou wouldwant to pass the encrypted password. sqlplus username/encyptedpass? But won't the encrypted password be known before making the connection? If so, then the user who will encrypt the password will also know how

Inserting blanks from a PROCOBOL program

I have a programmer who wants to insert blanks from a PIC X host variable into a not null CHAR column from a COBOL program. The generated code insists on converting his blanks to a null which is, of course, rejected since the column is defined as not null. Is there a way of forcing the blanks to

RE: Passwords and authentication

Title: Passwords and authentication There is also label security option which is present on Enterprise Edition CD. That would alleviate the need for manual encryption because the table cannot be seen unless there is sufficient security clearance. Also, logging in from SQL*Plus can be

Re: INDEX REBUILD

hi, From user_objects.last_ddl_time. Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 20, 2003 12:00 AM Seema - If you analyze in conjunction with rebuilds, you could track with

RE: INDEX REBUILD

Where can I find more detail info about frequent index rebuilds can reduce your performance ? Thanks. Guang -Original Message- Sent: Thursday, June 19, 2003 12:00 PM To: Multiple recipients of list ORACLE-L Seema - If you analyze in conjunction with rebuilds, you could track with the

RE: AQ, RAC and delay

Title: RE: AQ, RAC and delay I haven't tried with mcpd=0 yet ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having

oracle authentication from windows

We want our client users ( forms user ) to just enter windows password and then automatically able to get in to oracle .Is there a way oracle can authenticate from windows ( or active directory ) . enbadding password in runform.exe not an option . thanks, -ak

IO Topology Anyone???

Anyone use the IO Topology features with Oracle9iR2 and Veritas? Does Veritas have a mapping file that you can use with this feature? (I've posed the same question with Veritas, so it's a race to the answer!) Any experiences you can share about this feature? Robert -- Please see the

Re: 9i Ques

I believe that when you create a database with the GUI it sets undo_retention to 10800. Perhaps if you set it to blank then 9.2 will default to 900.

RE: Partitions of table read only

Ah... That's why the example helps... The text above the example is unclear but the example is a little bit better... If you find it is taking a long time for the tablespace to quiesce, it is possible to identify the transactions which are preventing the read-only state from taking effect.

RE: Oracle releases by the different platforms...

Title: RE: Oracle releases by the different platforms... This story makes it sound like SCO is an attorney's office that specializes in scoring rainmaker lawsuits based on purchasing old rights to software. Doesn't sound like a software company to me. I'd be updating my resume if I was a

Re: INDEX REBUILD

Anup this view will not help in 8i. thanks anyway! From: Arup Nanda [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: INDEX REBUILD Date: Thu, 19 Jun 2003 08:20:06 -0800 Seema, Select last_ddl_time and timestamp from

Re: 9i Ques

Hi, option a is the default . option c if you have create the database with DBCA Alessandro - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 9:34 AM Hi Group, What is the default value of Undo_retention? a. 900 b. 0

RE: Partitions of table read only

much better -- now I understand :) --- Johnston, Tim [EMAIL PROTECTED] wrote: Ah... That's why the example helps... The text above the example is unclear but the example is a little bit better... If you find it is taking a long time for the tablespace to quiesce, it is possible to

Re: APPS 11i (Linux) question

Hi Senthil I don't have any information on your specific problem - but I did write up a summary of my experiences installing 11.5.7 on Redhat 8 and SUSE 8.1 You might find elements of this to be useful during your install. http://databee.com/apps11i_install.htm Kind regards - Dale

Re: Inserting blanks from a PROCOBOL program

Can't he use a working storage variable that is defined with value space? Else try inserting ASCII value for a blank. - Kirti --- Schauss, Peter [EMAIL PROTECTED] wrote: I have a programmer who wants to insert blanks from a PIC X host variable into a not null CHAR column from a COBOL

RE: INDEX REBUILD

8i which release? It was broken in 8.1.6 and before, but fixed in 8.1.7. -Original Message- Sent: Thursday, June 19, 2003 2:01 PM To: Multiple recipients of list ORACLE-L Anup this view will not help in 8i. thanks anyway! From: Arup Nanda [EMAIL PROTECTED] Reply-To: [EMAIL

RE: RMAN FILESPERSET

The question has to do with backup sets not pieces. A backup set can comprise many pieces. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 17, 2003 9:15 AM To: Multiple recipients of list ORACLE-L You have the maxpiecesize set

copy a datafile to a raw device

hi all: I need to move a SYSTEM datafile from a filesystem to a raw device. I have shutdown the database, copied the file via dd if=system of=/dev/raw renamed the file in the database, but couldn't open the database because of the error: Unknown File Header Version read for file number 1. I

RE: data architecture/conferences/documents/lists

Title: RE: data architecture/conferences/documents/lists Interested in data architecture issues beyond a particular RDBMS (sorry guys just have to be) and I was wondering if anyone had any good resources: -listservers -conferences (what are the best for a ltd. budget) -good

Re: oracle authentication from windows

Hm I haven't tried on Windows, but... have you tried: IDENTIFIED EXTERNALLY??? using remote authentication I guess... HTH JL --- AK [EMAIL PROTECTED] wrote: We want our client users ( forms user ) to just enter windows password and then automatically able to get in to oracle .Is

Re: recreating a create database file

I just logged on to sqlplus using the logon / as sysdba and did an 'alter controlfile backup controlfile to trace;' This creates a file in your dump destination. Then you can recreate the db using this file. HTH, Ruth - Original Message - From: laura pena To: Multiple

RE: Passwords and authentication

Title: Passwords and authentication Label Security = Sometimes we need to compile forms against production instance (please don't ask) to resolve some really stupid issues. When compiling, the form has to be compiled with schema owner (again don't ask). As the production

Re: Passwords and authentication

Title: Passwords and authentication Mladen, Thanks for bringing it up. In my book I will cover the VPD (vitual private database) in detail and will explain how to use the application user model into making a secure authentication and authorization model. Label security is nothing but a

Re: recreating a create database file

Thanks, Mladen. I will look forward to it. Meanwhile, I at least have something to recreate them as they are. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 12:40 PM I have it at home. It's a modified version of the

Re: IO Topology Anyone???

Yes, there is file mapping that works with 9ir2 and veritas. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 7:55 PM Anyone use the IO Topology features with Oracle9iR2 and Veritas? Does Veritas have a mapping file

Re: Passwords and authentication

Reginald, Could you explain how, please. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 12:05 PM Yes it is. RWB

RE: data architecture/conferences/documents/lists

Paula - My impression is that the data architecture arena is now split between OLTP (normalized) and DW (star schema), with different mindsets accordingly. The best resource for normalized data modeling that I have found is: The Data Modeling Handbook by Michael C. Reingruber and William W.

Re: Re: Passwords and authentication

what will be the name of your book? when will it be out? you have an extract of what it will cover yet? From: Arup Nanda [EMAIL PROTECTED] Date: 2003/06/19 Thu PM 03:31:43 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Passwords and authentication Passwords

RE: Passwords and authentication

Title: Passwords and authentication Bummer! I was hoping for a commission from Oracle! Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 3:18 PMTo:

RE: Re: Passwords and authentication

http://www.dba-oracle.com/bp/bp_titles.htm Look about in the middle of the page. -Original Message- what will be the name of your book? when will it be out? you have an extract of what it will cover yet? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:

RE: copy a datafile to a raw device

Well heck. Nobody else has replied, so I might take a stab at it here. I suspect that the format of the data (bits and bytes) required on a raw device is different than the format of the data in a file in a file system. I'm stretching a bit here, but I think an analogy would be what would

RE: oracle authentication from windows

That, of course, will render your database totally insecure and open to anybody who can bring in a WinXP laptop, change the windoze username and log in as he pleases. DBA that sets his production parameters the way Arup described deserves to be publicly tortured by Bill O'Reilly in the

Read SQL Server from Oracle

I need to be able to read SQL Server tables from an Oracle procedure. Can anyone point me in the right direction for info? Ron Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by

Re: Re: Passwords and authentication

Title: Passwords and authentication The book is called "HIPAA Security and Auditing for Oracle".from Rampant TechPress. Although it is targetedtowardsthe organizations and individuals in US healthcare scene affected by the new law HIPAA,the books is ahandbook for security and auditing in

Re: oracle authentication from windows

Got it . Thanks Arup . - Original Message - From: Arup Nanda To: Multiple recipients of list ORACLE-L Sent: Thursday, June 19, 2003 12:45 PM Subject: Re: oracle authentication from windows Sure. Just declare these in your init.ora

RE: INDEX REBUILD

Guang - Below is what Jared said on this topic: Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 26, 2002 9:14 PM To: Multiple recipients of list ORACLE-L Though I have published a script for determining indexes that

RE: copy a datafile to a raw device

Title: RE: copy a datafile to a raw device It's been a number of years since I did anything with raw devices, so this is all ancient and possibly out of date/incorrect. I believe Stephen to be wrong. The bits and bytes written on the data file are identical, regardless of whether the

RE: Read SQL Server from Oracle

Title: RE: Read SQL Server from Oracle Can use Heterogeo. Services and an ODBC driver (just be careful case-sensitivity is an issue) or pay extra for a Gateway to SQL Server. -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 19, 2003 4:27 PM To:

Book Recommendation for Apache

Hi, Any recommendations on good Apache books? We will be bringing in Oracle 9iAS shortly. Third party application constraints require the use of Forms 6i, which in turn requires that we stay with 9iAS Release 1 (version 1.0.2.x.x). We are currently running Oracle Application Server.

RE: copy a datafile to a raw device

Gene Good ideas from Stephen. A more basic issue if you haven't dealt with it is that copying a system datafile is different from copying other datafiles. You can't have the database open. I recall that you have to STARTUP MOUNT and ALTER DATABASE DATAFILE. This procedure is covered in the

Re: copy a datafile to a raw device

Gene, I recall a similar scenario (this was Oracle7, so it may not apply). The real issue was that oracle uses different file header configurations for cooked and raw files when it uses them. I don't think you can copy the file to a raw device and expect oracle to be happy about it. I

RE: copy a datafile to a raw device

What platform is this on? On some UNIX platforms the file header for the raw device may vary in size. (It has been a while since I dealt with raw devices). You may have to use seek= option (dd command) to skip the header bytes before actually writing the data using 'dd'. Or just call Oracle

RE: OEM question

Title: Message You are correct about the chicken/egg problem with the repository. You don't necessarily require a repository if you are using it as a management console rather than an application managament framework. I have tried to automate various things with OEM jobs and events and

RE: Read SQL Server from Oracle

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96544/admi n.htm#169283 -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 1:27 PM To: Multiple recipients of list ORACLE-L Subject: Read SQL Server from Oracle I need to

Re: Book Recommendation for Apache

Drums along the mohawk. [EMAIL PROTECTED] 06/19/03 04:44PM Hi, Any recommendations on good Apache books? We will be bringing in Oracle 9iAS shortly. Third party application constraints require the use of Forms 6i, which in turn requires that we stay with 9iAS Release 1 (version

RE: copy a datafile to a raw device

Dennis, Thanks for your input. I am doing what the manual says - shutdown , copy, mount, alter, open and every time I'm getting the unknown file header message. I suspect that I am missing some parameters in my dd command because of - as Stephen suggested - different formats. I guess I will have

RE: copy a datafile to a raw device

I might expand on this some. If you think about it, any time you store bytes on something, the storing process has to make a note of where it put the bytes; maybe how many bytes it put there; if the bytes are not contiguous, then info about where one set leaves off and where the next set picks

RE: OEM question

No No. THOSE guys did replication. Then the worst of the bunch worked in conjunction with the authors of graduate Math texts to come up with Advanced Queuing. -Original Message- I have tried to automate various things with OEM jobs and events and eventually decided that at and dbms_job

Re: copy a datafile to a raw device

Gurelei,ÄúºÃ£¡ hi, what is your OS? In some os, you have to skip some block on that raw device for lvm usage. If you use rman copy, rman will handle it for you. Good luck === 2003-06-19 10:55:00 ÄúÔÚÀ´ÐÅÖÐдµÀ£º=== hi all: I need to move a SYSTEM

TEXT FILE

Hi, Is there any other packages thru which we can generate text file except UTL_FILE? I want to generate text file dump into another server ,that server will indexes and processing that data and improve search. How to do that? Thanks -Seema

Re: IO Topology Anyone???

Freeman Robert - IL,ÄúºÃ£¡ It seems that in oracle10i, there is such feature. But I have not read much about it. === 2003-06-19 09:55:00 ÄúÔÚÀ´ÐÅÖÐдµÀ£º=== Anyone use the IO Topology features with Oracle9iR2 and Veritas? Does Veritas have a mapping file that you can use with

RE: copy a datafile to a raw device

Concerning my speculation about error messages in the Oracle kernel, the following is an actual error message in an app here. Of course, the error is never supposed to occur -- so says the programmer when I asked about it. SERROR_MESSAGE := 'How did I Get Here? Where is my car? Who is that

RE: TEXT FILE

Sure, write your own pro C++ to text converter. Otherwise nothing I know about. Allan -Original Message- Sent: Thursday, June 19, 2003 4:35 PM To: Multiple recipients of list ORACLE-L Hi, Is there any other packages thru which we can generate text file except UTL_FILE? I want to

RE: copy a datafile to a raw device

Well, this oracle file system is the logical storage structure of tablespace, segment, extent, db blocks which is the same on File System or raw device. Richard Ji -Original Message- Sent: Thursday, June 19, 2003 5:20 PM To: Multiple recipients of list ORACLE-L I might expand on this

RE: Re: Passwords and authentication

HIPAA Auditing for Oracle Database Security Nice. Well, Arup, Get to publishing! ;-) --Scott -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/19/03 3:19 PM http://www.dba-oracle.com/bp/bp_titles.htm Look about in the middle of the page. -Original

RE: copy a datafile to a raw device

You left out, ...and why is there a goat in the corner? Sounds like a fun way to have at my duhvelopers (not the good ones). -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/19/03 4:49 PM Concerning my speculation about error messages in the Oracle kernel, the

Wrox Press catalog purchased by APress (was RE: Book Recommendati on for Apache)

I believe it's true that wrox is out of business. But APress (www.apress.com) has purchased the bulk of their catalog, so hopefully they'll resume publishing these books... Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Thursday, June

Re: Re: Passwords and authentication

Thanks, Scott. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 6:04 PM HIPAA Auditing for Oracle Database Security Nice. Well, Arup, Get to publishing! ;-) --Scott -Original Message- To: Multiple

RE: copy a datafile to a raw device

You didn't mention what Unix platform you are on. But since a striaght dd didn't work, you need to use seek to skip some blocks. -Original Message- Sent: Thursday, June 19, 2003 2:55 PM To: Multiple recipients of list ORACLE-L hi all: I need to move a SYSTEM datafile from a filesystem

RE: TEXT FILE

It depends. What version of Oracle? You can also create a file via Java Stored Procedure (requires at least v8.0, possibly 8i?). If you're able to grant JAVA_SYSPRIV to the account creating the file, you can also avoid the hassle of being restricted to directories specified by the UTL_FILE_DIR

Re: oracle authentication from windows

Mladen, This is precisely the content I have gone in depth in my upcoming book where this practice of OPS$ accounts have been discussed. The security hole in OPS$ accounts is a bit overrated. Chagnign username in Windows XP alone does not allow logging in to the database directly if OPS$

  1   2   >