RE: Export question.

Well whaddya know... Analyzed the table with estimates statistics (sampled 30 percent) and bingo. My table is now reporting that it is 4.4Gb and not 330Mb. Avg row length went from 6 bytes to 81. On a 50+ million row table that made some difference to the calculation. Many thanks Anita

RE: does oracle supports oracle 8.1.7. on sun solaris 8 (64bit) -

Hello, 8.1.7 64 bits will come out in June not before. 8.1.7 64 bits is late because Sun cluster 3.0 was late. As you probably already know. Oracle wants to certifie Oracle 8.1.7 64 bits with Sun cluster 3.0 Regards Henrik On Tue, 15 May 2001, Boivin, Patrice J wrote: I am confused

Two scenarios, pl/SQL

I have a database, with some table relationed to each other, I would like to have 2 scenarious, Case 1: I have 4 tables, table1, table 2, table 3 and table4 included in a join, this query should run in the most common query. In table 1 and in table 2 exist a relation, id_nr in table1 and

Re: RMAN Catalog - Backup Strategy

Hello, Yes it is a decent way. We do the same but we also sunc with our client befaore do the export. Regards Henrik On Tue, 15 May 2001, Raj Gopalan wrote: DBAs I am taking the export backup of RMAN catalog DB from the Target DB server , immediately after the target DB RMAN backup. Is it

ORA-3113 and PLSQL Runtime Dump

Hi all, lately for few packages I am getting this dump. A sample is attached below. Is there a way to read this stuff to pinpoint where exactly in code this is happening? How to read this? or this is *oracle only* stuff (I guess ..) Thaks in advance Stefania Pessoz Trace file:

Re: Two scenarios, pl/SQL

You can have a if ..then...else condition loop. When first condition is satisfied the first query can run and in the else part second query can run. No need to create procedure for simple queries. -Saumyajit --- [EMAIL PROTECTED] wrote: I have a database, with some table relationed to

Error handling

Can someone give me an example on how to write the code to trap errors where the field is too large to fit in the size of the PL/SQL variable? I also want the errors to be logged in a table. Please give me a good example on PL/SQL code and also includ ethe insert statement into the table.

Ynt: enqueue waits

Hi, you can find the time spent in each enqueu by itrprof. - Original Message - From: Diego Cutrone To: Multiple recipients of list ORACLE-L Sent: Tuesday, May 15, 2001 9:50 PM Subject: enqueue waits Hi List, I'm trying to identify the possible cause of

ORA-3113 and PLSQL Runtime Dump

Hi all, lately for few packages I am getting this dump. A sample is attached below. Is there a way to read this stuff to pinpoint where exactly in code this is happening? How to read this? or this is *oracle only* stuff (I guess ..) Thaks in advance Stefania Pessoz Trace file:

Oracle Replication Special Interest Group.

Hello, Is there anybody that know where I can find the mailing list for Oracle Replication Special Interest Group. ? Thanks for your help. Regards Henrik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenberg INET: [EMAIL PROTECTED] Fat City Network

RE: ORA-3113 and PLSQL Runtime Dump

Hi Stefania, AFAIK, there are several bugs, all having to do with problems in processing the cursor queries. Try searching metalink. Possible solutions are: - add aliases for every table/view in the from-clause - don't use parallel query for the cursor query - don't use functions in the group

RE: Duplicate keys message two

-Original Message- Sent: Tuesday, May 15, 2001 5:16 PM To: Multiple recipients of list ORACLE-L borrowed from Ari Kaplan of this list: delete from table_name a where rowid (select min(rowid) from table_name b where a.column_name=b.column_name) / Original message rejected due to

RE: set term off

I don't have my manual nearby but how about: set feedback off? -Original Message- Sent: Tuesday, May 15, 2001 6:40 PM To: Multiple recipients of list ORACLE-L Anyone had any problems with setting term off? I'm running 8.1.7 and I go to do this sqlplus -s /nolog set term off conn

Upgrade question

All, Are there any white papers out there (or personal experiences) that you know of specifiying gains/losses in upgrading from Oracle8 to 8i. We are on Compaq Tru64 4.0f and Oracle Version 8.0.5.0.0 TIA Lee The information contained in this communication is confidential, is intended

RE: From SID to connected machine

Title: From SID to connected machine Linda, Have you checked the v$session view? I believe that it shows the OS user and machine associated with the session id. Hope this helps. Ron -Original Message-From: Hagedorn, Linda [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 15, 2001

ora-600 ora-7445 trace file needed

Hi, I need ora-600 ora-7445 trace files. if possible, can you send these files to [EMAIL PROTECTED] regards... -- Use itrprof SQL Analyzer. itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to

RE: does oracle supports oracle 8.1.7. on sun solaris 8 (64bit) - pro

A long time ago, Oracle was developping on Vax/VMS, then Oracle switch to unix (HP and SUN), then Windows NT came in so Oracle was developping on SUN and Windows NT. I'm not sure now what is the current development environment. --- Boivin, Patrice J [EMAIL PROTECTED] a écrit : I am confused

Imedia query tuning

Dear DBA Gurus, I have the following two queries along with execution plan and statistics. The first one is taking a long time to execute. The second query is taking a long time to execute when I use the order by clause. I am also sending the table details. Is there any way I can

RE: From SID to connected machine

Try this statement out: select sid, username, osuser, process, machine, terminal, from v$session where username = 'PALMAPP; HTH Mark -Original Message- Sent: Wednesday, May 16, 2001 02:56 To: Multiple recipients of list ORACLE-L Hello, I'm looking

Imedia query tuning

Dear DBA Gurus, I have the following two queries along with execution plan and statistics. The first one is taking a long time to execute. The second query is taking a long time to execute when I use the order by clause. Is there any way I can reduce the execution time as these queries

Re: How to avoid sorting in the select statement?

Hi Ranganath, If the column on which u perform ORDER BY has a index then try using INDEX_ASC or INDEX_DESC optimizer hint in your SELECT statement to avoid SORT. hope this may help u. Arul. Ranganath K wrote: Dear DBA Gurus, I have some static data in two of my tables which

RE: Imedia query tuning

Hi Ranganath, Do you realy need the subquery ? Try replacing the ... in (...) condition by category.status=0. You already have a condition which states that fk_category must equal pk_category_id. If it's still slow: how many rows are there in each table ? Remco -Oorspronkelijk

Re: DB Link Between Prod and Test?

On Tue, 15 May 2001,Rocky Welch scribbled on the wall in glitter crayon: -How about creating a user that only has read-only rights? But that still allows the query from hell syndrome that can bring a prod box to it's knees. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.

RE: set term off

Isn't it : set feedback off ? Mark -Original Message- Turner Sent: Tuesday, May 15, 2001 11:40 To: Multiple recipients of list ORACLE-L Anyone had any problems with setting term off? I'm running 8.1.7 and I go to do this sqlplus -s /nolog set term off conn username/passwd

RE: File open event

Thanks for the reply Steve, this event was not proping up before until we enabled QUICK I/O and that too after we enabled Cached Quick I/o. one more thing I wanted to know have you faced any issues are come across, When you have enabled QUICK I/O on Sun Solaris it causes causes too much wait

job offer from SAUDI ARABIA

Hi all , I have taken an offer from a company in Europe to work in Saudi Arabia for 2 years. But I must learn the living conditions there. Ýf there is an Arabian here , can you answer these.. 1) How are the living conditions?Expensive? 2) Will my wife have to cover her hair? Is it

RE: LSNRCTL Password

I tried host=localhost on some test boxes and clients could not connect. Next I'll try host = 127.0.0.1 (7.4 on Sun 2.6) Mike -Original Message- From: Hillman, Alex [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 8:02 PM To: Multiple recipients of list ORACLE-L Subject:

Re: Imedia query tuning

Hello, I'm not a guru : I just try to help you. :- Hint for Query 2 : Have you try to hint so you run on the editor_choice index. If it works. Can you remove the Order command. Because the index is already ordered. Regards Henrik E. On Wed, 16 May 2001, Ranganath K wrote: Dear DBA Gurus,

Create Snapshot failed - why ?

Dear All, two days ago, we created the following snapshot (see above) without any problems. CREATE SNAPSHOT ksa_dba.sys_schnr_webksa_max_repl STORAGE ( INITIAL 40k NEXT 40k PCTINCREASE 0) TABLESPACE TS_SCH NOLOGGING BUILD IMMEDIATE USING INDEX STORAGE( INITIAL 40k NEXT 40k

RE: File open event

Hi Arun, Did you check whether LGWR and CKPT are the main culprits? Yes, I have seen lots of 'file open' waits on a Solaris system running Cached Quick I/O, but they had lots of web servers making frequent short connections to the database, so I did not associate it with QIO. Interesting

Re: Oracle Replication Special Interest Group.

Henrik Ekenberg wrote: Is there anybody that know where I can find the mailing list for Oracle Replication Special Interest Group. ? I've been a subscriber for a while. About two weeks ago I got the attached message saying they've converted it from a mailing list to an OTN forum at

Re: Oracle Replication Special Interest Group.

Henrik, It's been replaced by the replication forum on technet: http://technet.oracle.com Choose Discussion Forums underneath Collaboration on the left hand menu. HTH, -- Anita --- Henrik Ekenberg [EMAIL PROTECTED] wrote: Hello, Is there anybody that know where I can find the

Re:How to avoid sorting in the select statement?

Ranganath, You will notice a delay with the order by clause since Oracle has to extract the data from the tables into a un-indexed temp table, and then sort the data. Can you cluster it, Sure. Will it help performance, depends on whether or not all of the items in the items in the order by

RE: Upgrade question

Lee, I don't know of any white papers but we had to upgrade Tru64 to v5.1 in order to install Oracle 8.1.6. I don't recall any other drawbacks to making this conversion. Ron -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 16, 2001

Oracle Reports Demo Tables

Hi, I recently installed Oracle Reports; however, they didn't send me the demo cd that contains the sample tables, I can use to play with the product. Does nyone have a copy of the script to create the demo tables that they can send me? Bill Carle ATT Database Administrator 816-995-3922

OT RE: Mean/Median

better than being a pile of pig fundament... [EMAIL PROTECTED] 05/15/01 03:22PM ROFL! I am an idiot || -Original Message- || From: [EMAIL PROTECTED] || [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 15, 2001 2:11 PM || To: Multiple recipients of list ORACLE-L || Subject: RE:

RE: Mean/Median - Another method

median; adjective: (statistics) relating to or constituting the middle value of an ordered set of values (or the average of the middle two in an even-numbered set) This is the definition of median. It's not a calculated value, it's more of a derived value. [EMAIL PROTECTED] 05/15/01 07:38PM

RE: Intermedia

Title: RE: Intermedia Hi Gary, This is what happened. A regular install would not succeed with the CREATE INDEX statement. I put a call in to support. Lucky for me I got a knowledgeable woman on the phone who knew exactly what the problem was. The libraries could not be created when

RE: cdump, bdump, udump

I also monitored the processes and found that alert.log file is constantly accessed at least by one Oracle process during a period of one hour continuous monitoring. Hence, my conclusions: 1. By removing alert.log, the space would not be reclaimed by the disk on Unix machines immediately until

RE: Imedia query tuning

Title: RE: Imedia query tuning Henrik, FYI The ordered hint refers to the order in which the tables are accessed in the query. It has nothing to do with an index. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton

RE: job offer from SAUDI ARABIA

Bunyamin, I worked in Saudi Arabia for 5 yrs. (approx.). I could help you and clarify your various other questions.  If interested, please contact me directly. Rao [EMAIL PROTECTED] -Original Message- From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]] Sent:

RE: set term off

Doesn't work on 7.3.4... sqlplus -s /nolog set feedback off set term off set echo off connect x/* Connected. However if you have an externally identified user and do a: sqlplus -s / select * from v$database; NAME CREATED LOG_MODE CHECKPOINT_CHANGE#

RE: set term off

That won't help either.. I tried it with 8.1.7 on HP-UX 11.0 and AIX 4.3.3. hpserv1 [ICDP]: sqlplus -s /nolog set feedback off conn system/manager Connected. I don't think it is possible to suppers 'Connected.' with '/nolog' and 'connect' options. Regards, - Kirti Deshpande Verizon

RE: set term off

Dave - Put your commands into a script philip more tmp.sql set term off connect user/password select sysdate from dual; exit philip sqlplus -s /nolog @tmp philip Termout only works on commands run from a script. HTH Linda -Original Message- Sent: Tuesday, May 15, 2001 4:40

What is the cost of replication?

We have a small but critical application running on NT. The user wants to implement replication. We have never done replication for Oracle. Can someone give me an idea of how much difficult it is to maintain a replicated database on NT. How much of my time will I need to allocate to keeping

RE: OT RE: /TEST/IDIOT/Re: ADMIN: 2nd Beta of web-based ODTUG arc

Could you please be more PRECISE? -Original Message- Sent: Tuesday, May 15, 2001 7:12 PM To: Multiple recipients of list ORACLE-L archive How about SAVANT? or moron imbecile vegetable || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent:

RE: job offer from SAUDI ARABIA

I'm sorry but I can help but laugh out loud that you took a job and didn't research this.At a minimum your new employer should have informed you of what to expect. I too at one time looked into taking a job in Saudi Arabia. I have known several people who have worked and/or visited on

RE: Imedia query tuning

May be you could rewrite your queries like this.. select /*+ ORDERED use_nl(b) index(a index_on_pk_category_id) index(b index_on_fk_category) */ depth, title, description, url, editor_choice from category a,site b where b.fk_category = a.pk_category_id and a.status=0 and b.status=0

STOP this THREAD: job offer from SAUDI ARABIA

Discussing this here will not add any value except triggering flames. Please send directly to the person email address. Regards, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

Re: job offer from SAUDI ARABIA

I would suggest that you contact the taxing authorities in you native country to determine if you owe any income taxes on what you make and also on any expenses that Saudi Arabia will give you. My 2 cents, Ken Janusz, CPIM Hi all , I have taken an offer from a company in Europe to work in

OEM /98 / and 8.1.6 on Linux

Group, Team, List, and others. In the past I have used OEM2.2r3 on an NT server/workstation and it worked okay. Due to NT licenseing I could not keep the setup. I converted to RedHat Linux 6.2 and Oracle 8.1.6.1 as the server. I am using Win98 as the client that has the OEM loaded. The DBA

RE: DB Link Between Prod and Test?

William: Check my old post. I agree with that Matthew. But if you still have to use the link make sure you give the user the appropiate provileges and assign him a profile to limit the ammount of resources he can consume with his queries. This way he can't slow down the prod instance

RE: job offer from SAUDI ARABIA

Ican answer your question# 2 It would be very wise for your wife to cover her head and you.. your butt!! think twice before you make a move. Sunil Nookala -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 16, 2001

RE: OEM /98 / and 8.1.6 on Linux

Hi, Ron, I think, you can't discover OMS server on Linux box from your workstation. 0. You need OEM Console and OMS versions to be the same. You cant connect from 8.1.7(OEM2.2) to 8.1.6 (OEM2.1). You can setup OEM 2.2 and use 8.1.6 for repository, but they cannot share ORACLE_HOME.

Re: What is the cost of replication?

We have advanced multimaster replication. I have spent about 70% of my time looing into replication related isues. I came to site with no experience of replication, no documentation about the environment and no transfer of knowledge since the previous dba already left. Now this may be because

RE: Vocabulary

It is unit of measurement in India. One Lakh = 100, 000 Rao [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 16, 2001 1:56 PM To: Multiple recipients of list ORACLE-L I have seen this several times, and I am very curious as to what lakhs are. Is this a standard of

RE: newbie question

Hi, Yes, you can modify instance parameters in the initXYZ.ora file. After you change them, they take effect when you bounce the instance (shutdown and startup) Also, there are some parameters that can be modify on the fly, without bouncing the instance. check this. SQL desc

RE: Vocabulary

way cool -- thank you :) From: Khedr, Waleed [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Vocabulary Date: Wed, 16 May 2001 10:19:24 -0800 Look at this: http://www.kshitij.com/utilities/LnCtoMnB.shtml -Original

Re:RE: job offer from SAUDI ARABIA

When I retired from the USAF, Lockheed offered a job in Saudi at what could only be described as an exorbitant salary ($150K plus) to go work as a C-130 Radar Tech. I was an extremely qualified AN/APN-59E Search Radar tech while in uniform. The only advice that they constantly talked about was

RE: Vocabulary

It comes from the Metric System. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 11:41 AM To: Multiple recipients of list ORACLE-L Subject: RE: Vocabulary way cool -- thank you :) From: Khedr, Waleed [EMAIL PROTECTED]

RE: job offer from SAUDI ARABIA

http://www.arabia.com - Unfortunately Al-Jazira TV in Qatar doesn't seem to have a working web site. ??? Something linked from CBS news 60 Minutes: http://www.aljazeera.net/ http://www.cbsnews.com/now/story/0,1597,13502-412,00.shtml ---excerpt--- Recap: Sunday, May 6 ...

RE: From SID to connected machine

Title: RE: From SID to connected machine I can get all the session info, but the machine name isn't externalized. By elimination I've found the problem machine is va8. Since I have the processes in place and they're not hurting anything, I have time to research. Here is the sid/pid logic,

Re:RE: job offer from SAUDI ARABIA

I find the topic interesting. If you don't like, hit the old delete key :) [EMAIL PROTECTED] 05/16/01 02:30PM When I retired from the USAF, Lockheed offered a job in Saudi at what could only be described as an exorbitant salary ($150K plus) to go work as a C-130 Radar Tech. I was an

RE: job offer from SAUDI ARABIA

Title: RE: job offer from SAUDI ARABIA -Original Message- From: Brian MacLean [mailto:[EMAIL PROTECTED]] Read the following excerpt and follow the links, and Be Very Very Afraid. ... One of my former colleagues worked in Saudi Arabia and said that the life there was very quiet

RE: job offer from SAUDI ARABIA

Bunyamin, Conditions cut both ways - depends on how you see it... Loss of religious, social and cultural freedom against the possibility of earning (and saving because you can't spend) lots of $$. Having said that, as long as you stick to the straight and narrow path (as defined by the Saudi

Export Split Script

I tries using a compressed export and the output is still over 2G. Does anyone have the export script that splits the export files into multiple files? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L.

RE: job offer from SAUDI ARABIA

At 11:32 -0800 16/5/01, Jacques Kilchoer wrote: One of my former colleagues worked in Saudi Arabia and said that the life there was very quiet and much different from our western lifestyle. However, in his opinion, if you made the effort to respect the local traditions, you could live there

BMC Patrol - 2nd Wave

So my boss calls me over yesterday and tells me he needs two servers for 2nd Wave to install BMC on to monitor the databases. I say, huh? Apparently the CIO decided to have a consulting company (2nd Wave) install and configure BMC to monitor all the databases (Oracle and SQL Server) in the

Re: Export Split Script

On Wed, 16 May 2001,Smith, Ron L. scribbled on the wall in glitter crayon: -I tries using a compressed export and the output is still over 2G. Does -anyone have the export script that splits the export files into multiple -files? - -Ron Smith -Database Administration -[EMAIL PROTECTED] - Go to

RE: Export Split Script

http://www.oracle.com/oramag/code/tip01168.html Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 2:57 PM To: Multiple recipients of list ORACLE-L Subject: Export Split Script I tries

Security Functions

How do I restrict access to functions? Chris Rezek Database Administrator DotClick http://www.dotclick.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: What is the cost of replication?

I'd agree, replication can be a pain when you are first learning how to do it. I've also had some problems with the Replication Manager gui crashing/hanging on me. You might want to spend the extra time and learn how to do everything from the command line. Besides, real dbas don't use

Re: Export Split Script

http://www.oracle.com/oramag/code/tips1998/index.html 1/16/98 I tries using a compressed export and the output is still over 2G. Does anyone have the export script that splits the export files into multiple files? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the

Re: Export Split Script

On the LazyDBA website there are scripts written by Rachel Carmichael on do a compressed export into files of 2 gig and the corresponding import. If you can't find it let me know and I will try to send it to you. I can always send you the one I edited. My email address is below. Ruth B.

Re: Security Functions

Whoops - just realized all I needed was a 'grant execute'. Chris Chris Rezek wrote: How do I restrict access to functions? Chris Rezek Database Administrator DotClick http://www.dotclick.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek

RE: Export Split Script

If you are using Oracle on Unix , You may want to use unix pipes ( mknod). - most people use this method to manage files 2GB. Rajaram (Now that I am at the top of a mountain - I dont know how to get down!) -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent:

RE: Export Split Script

Thanks to all who replied. By the way 'I tries' was a typo. I try. Thanks! Ron -Original Message- Sent: Wednesday, May 16, 2001 3:17 PM To: Multiple recipients of list ORACLE-L http://www.oracle.com/oramag/code/tips1998/index.html 1/16/98 I tries using a compressed export and the

RE: Security Functions

alter system electrocute user when an execution of [FUNCTION NAME] is attempted; -Original Message- Sent: Wednesday, May 16, 2001 4:17 PM To: Multiple recipients of list ORACLE-L How do I restrict access to functions? Chris Rezek Database Administrator DotClick http://www.dotclick.com

RE: Export Split Script

Rajaram, Please give me details on how to use mknod to split export files larger than 2 GB. We have broken our jobs into over 50 separate export jobs on the table level just to keep our files less than 2GB. Michael Armstead Application Database Administrator, OCP-Certified US

RE: OEM /98 / and 8.1.6 on Linux

Vadim, Thanks for the info. It appears that I did not get a complete install in the Linux box. None of the commands you recommend can be found. I will have to dig up the original cdrom and try to install the OMS option. I think that I might just upgrade the Oracle to 8.1.7 on RedHat 6.1. IT

RE: BMC Patrol - 2nd Wave

Title: RE: BMC Patrol - 2nd Wave My experience is that BMC leaves a big footprint on the systems it monitors. So unless you have a system with 6+ cpu's the hogs reported are BMC related or the slow system is caused by BMC. And the $$ it costs, ouch. I have seen better results in shops

Executing a remote call from Oracle database server using Java

I am posting the following question for a colleage. We are using Oracle 8.1.7 and jdk version 1.1.3 and Weblogic version 5.1 (we are planning to go to 6.0): Can a Java code on an Oracle database server give a call to a Java code on a Weblogic application server? Thanks, Cherie Machler Gelco

ORA-01489 result of string concatenation is too long

Hi! I'm concatenating two LONG columns (2800 characters each). I get an ORA-01489 result of string concatenation is too long Cause: String concatenation result is more than the maximum size. Action: Make sure that the result is less than the maximum size. Although the variables used are set as

Re: BMC Patrol - 2nd Wave

Jay, Not sure about you, but if my CIO pulled that one on me, he'd have my resignation in about half a minute he knows it. That is just one of those run all over your people things that every management course tells you NOT to do. Otherwise I don't know of any real problems with BMC

insert very long string of text into LONG column

Hi! How do I insert a very long string of text (about 200k in notepad) into a LONG column with a standard SQL insert command? What would be the best way to achieve this? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut

RE: Security Functions

Make sure you have your 220V signal from the server connected to users PC so that the response is immediate. Might want to nice this process to take priority over any others on the server. ;^) Rodd Holman Original Message On 5/16/01, 3:40:29 PM, Gogala, Mladen [EMAIL PROTECTED] wrote

RE: Export Split Script

there is a note out on Metalink on how to do this. You can also break the export into separate files in later versions of Oracle8i. or you can run the following script (modified to suit your system, it was last tested on Solaris/Oracle 7.3.4) #!/bin/sh # cd $EXPORT_DIR # # set maximum file

RE: Export Split Script

1. Create a Pipe , say usr1.pipe. A pipe is a FIFO structure. /bin/rm /dsk1/usr1.pipe /bin/mknod /dsk1.usr1.pipe p ( See your version of UNIX - mknod differs in its usage - i mean the syntax - some strains require that u mention -p ) 2. Let compress listen at one end of the pipe. cat

Re: Export Split Script

Hi, all professionals, I am just wondering why we cannot use the parameter FILE parameter? With this parameter and FILESIZE, data will be split to multiple files automatically... Armstead, Michael A wrote: Rajaram, Please give me details on how to use mknod to split export files

RE: BMC Patrol - 2nd Wave

One advantage to never having been consulted on whether it should be done and having consultants installing it is that it would be hard to blame me for anything that goes wrong :). -Original Message- Sent: Wednesday, May 16, 2001 5:13 PM To: Multiple recipients of list ORACLE-L My

RE: imp/exp privilege ?

Thank you. I did not realize that BECOME USER only allowed you to import someone else's exported schema. This privilege is perfect for what I need. Elegant and simple. Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com

RE: Export Split Script

Thanks, Rachel. You're a sweetheart. Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 5:28 PM To: Multiple recipients

Re: insert very long string of text into LONG column

PL/SQL will let you go up to 32k, after that you're into 3GL (for a LONG). If you use LOB's then you have more options.. hth connor --- Helmut Daiminger [EMAIL PROTECTED] wrote: Hi! How do I insert a very long string of text (about 200k in notepad) into a LONG column with a standard SQL

RE: imp/exp privilege ?

I am curious, why couldn't you just do an import and issue the FROMUSER and the TOUSER? I do it all of the time and it works fine for me. Kev -Original Message- Nechama Sent: Wednesday, May 16, 2001 5:56 PM To: Multiple recipients of list ORACLE-L Thank you. I did not realize that

RE: imp/exp privilege ?

i believe the reason that you can do an imp fromuser/touser is that either they have dba type privileges, or that they have imp_full_database privileges. I do not wish to give the users those privileges as they can be dangerous. If i am incorrect please let me know as i am still new at this.

How to make DBA cannot 'see' User's Tables?

Title: How to make DBA cannot 'see' User's Tables? Dear gurus, How to make DBA cannot 'see' user's datas? I build an application which very important and top secret even DBA cannot 'see' this data. But DBA can backup this data.What is the solution for this problem? TIA, Ahmadsyah Alghozi

RE: How to make DBA cannot 'see' User's Tables?

Data Encryption? -Original Message- Sent: Wednesday, May 16, 2001 7:01 PM To: Multiple recipients of list ORACLE-L Dear gurus, How to make DBA cannot 'see' user's datas? I build an application which very important and top secret even DBA cannot 'see' this data. But DBA can backup

RE: How to make DBA cannot 'see' User's Tables?

If its a stored procedure i know that you can use a oracle tool called warp ( or wrap?) to encrypt the code. Its a comand line utility. Rajaram. -Original Message- From: Ahmadsyah Algozhi Nugroho [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 7:01 PM To: Multiple

RE: How to make DBA cannot 'see' User's Tables?

You can encrypt Decrypt data using the DBMS_OBFUSCATION_TOOLKIT package (comes with 8.1.6) Srinagesh What do I know any way Battula -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L

Script that will remove redundant rows from table

Title: auditing tables A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. Can someone please forward or point me to such a script. I have an Oracle Names server that stores the database connect descriptors in a table within the Region

  1   2   >