Re: Cache Object

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

[Fwd: Importing data from dump exported with different character set]

--- David A. Barbour [EMAIL PROTECTED] wrote: Brijesh, What are the Oracle versions you're exporting from and import into? UTF8 is a superset of US7ASCII, so you shouldn't be having problems. What error are you receiving? If you can't get it to work, can you redo the export

Re: Importing data from dump exported with different character set

, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED

Re: Tivoli??

Actually ADSM is the backup software. They moved it over to the Tivoli brand last year and now call it their Data Protection product. Tivoli generally specializes in network management products, much like CA. See www.tivoli.com Regards, David A. Barbour C.S.Venkata Subramanian wrote

Re: Why I can not create temporary tablespace?

Robert, Check your syntax. CREATE TEMPORARY TABLESPACE c2tmp TEMPFILE '/oracle/oradata/c2datatmp.dat' SIZE 50M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2M; Regards, David A. Barbour Robert Chen wrote: hi, I connect as sys/change_on_install and execute this: create TEMPORARY

Re: Security Functions

BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL

Re: file output of a SP

Bunyamin, Check the UTL_FILE Oracle-supplied package references on OTN. You'll need to set a directory(directories) in your initSID.ora file to use the package which means you'll need to bounce the DB. Regards David A. Barbour Bunyamin K. Karadeniz wrote: Hi Gurus, I have a problem, I

Re: Running remote scripts

Rajesh, You can't run interactive commands using rsh. You should be able to put all your commands into a script(s) and execute those. Otherwise try rlogin. Regards, David A. Barbour Rajesh Dayal wrote: Hi All, Env. is TRU64 Unix and Oracle 7.3.4 This is a standby server

Re: Data Reporting tools

. The Discoverer solution was much simpler and more cost-effective for all involved. They were quite proud of their ability to create ad-hoc reports, and very lavish with their praise of the 'support' they were getting from the DBA! Regards, David A. Barbour Ruiz, Mary A (CAP, CDI) wrote: Hi Dick

Re: PL/SQL-procedures

Write a package. David A. Barbour [EMAIL PROTECTED] wrote: How can I write procedure which runs 3 different subprocedures.? Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: Taking your time when a crisis occurs

Eric, What's with you and Barbie? David A. Barbour Eric D. Pierce wrote: RE: Taking your time when a crisis occurs - http://www.amazon.com/exec/obidos/ASIN2/B4SU3E Barbie as Glinda from The Wizard of Oz Our Price: $19.99 Availability: Usually ships within 24 hours

Re: images question

Check out BLOBs. They're stored externally. Can be tough to work with but also can be very worthwhile. Regards, David A. Barbour Oracle DBA,OCP Casas, Claudia wrote: Do you recommend storing images in an oracle database or just storing the directory path to them instead. Somebody told me

Re: E-mail from Alert Logs

Siv, Check out all the email tools available at: http://www.freedownloadscenter.com/Email_Tools/ Regards, David A. Barbour Oracle DBA, OCP Siv Chelakkara wrote: Bunyamin, Would you please send a copy of the attachment directly to me, since the list does not allow binary

Re: Fwd: please help

them, and everything goes to h*%$ in a handbasket, you can always give 'them' back something. David A. Barbour Jared Still wrote: Dick, Backing up the redo logs can have some serious consequences. Let's say you are restoring the database files, and a number of archived logs to roll forward

Re: FILE SYSTEM BUFFER IN JFS : ON OR OFF

What flavor of UNIX and what type of storage are you considering? Regards, David A. Barbour Raj Sakthi wrote: Hi List , I posted this on friday but didn't see it on the list so I am posting this again . I am redesigning a major system and particular attension is being given

Re: Urgent: How to Automate Procedure Execution

dba_jobsLists all the jobs in the database. user_jobs Lists all jobs owned by the user. dab_jobs_running Lists all jobs in the database that are currently running (join with V$LOCK to identify jobs that have locks). Hope this helps. David A. Barbour Oracle DBA, OCP abdul latif wrote

Re: date format ?

far so good, but the day/month is a problem. How would you evaluate '212' - as 2 December or 21 February? Regards, David A. Barbour Oracle DBA, OCP MOHAMMAD AMER wrote: hi oracle gurus, my client is very weird,he wants to enter the date in the format 'dd-mm-' without pressing space

Re: PLEASE HELP !

multiple tasks). Regards, David A. Barbour Oracle DBA, OCP Andrea Oracle wrote: Hi all, Our trainer needs to build training database/s, she is asking the following questions: 1. use Sybase or Oracle as the database server? We have some projects using Sybase databases

Re: Trace file does not reside in user_dump_dest. Why ?

Chor Ling, Go to the /dg1/oracle/niecomn/admin directory and run ls -al. If you see an arrow pointing to a directory description /dg1/oracle/nieora/8.1.6/rdbms/log, then it is a link. Regards, David A. BArbour Oracle DBA, OCP CHAN Chor Ling Catherine (CSC) wrote: Hi David, How do I

Re: Please Advice on Performance Tuning

NJ, For each SQL statement in each instance, run a trace, then run tkprof against it with the explain option. When you compare the two, it should tell you what they are doing differently and what you're biggest time waster is. Regards, David A. Barbour Oracle DBA, OCP N J Neog wrote: Hi

Re: Please Advice on Performance Tuning

if you get different results? Regards, David A. BArbour Oracle DBA, OCP N J Neog wrote: Hi David, Thanks for your suggestion. I thought TRACE,TKPROF, EXPAIN PLAN will be the last thing thing I will do. Because There may be lot of SQL Statement I have to select from these two Package

Re: Trace file does not reside in user_dump_dest. Why ?

Catherine, Just a WAG, but could the udump directory be a link to the nieora/8.1.6/rdbms/log directory? David A. Barbour Oracle DBA, OCP CHAN Chor Ling Catherine (CSC) wrote: Hi Ed, SQL select name, value 2 from v$parameter 3 where name like '%user_dump%'; NAME

UTL_FILE error

). Generally I'd see these types of errors when the UTL_FILE package isn't installed or there are too many open file handles tried to eliminate this by bouncing the instance). Does anybody have a clue here? Thanks, David A. Barbour Oracle DBA, OCP (Obviously not a path to enlightenment) Worn

Re: SQLLDR - whitespace (tab space) problem

Helen, You can use the optionally parameter to specify multiple enclosed by/terminated by parameters. NULLIF is also available to assist in loading blanks. Regards, David A. Barbour Oracle DBA, OCP Helen Zhung wrote: Hello: I'm new to SQL Loader. Is there a way to code in control

Re: UTL_FILE error

) with no luck. This is on AIX 4.2.1 with which I used to pride myself on having some sort of familiarity. Pride goeth before a fall. Any other ideas? David A. Barbour Oracle DBA, OCP(and still searching for enlightenment) This is MacGregor, Ian A. wrote: You need to handle the exception

Re: Problems with hot backup via BCV's...

it that, they called it corrupted SCNs). There was supposed to be a patch (has to do with the AIX implementation of AIO), but I never saw it, never changed this parameter back, and haven't had any problems since. Regards, David A. Barbour Oracle DBA, OCP (still seeking the one true path) Jim Hawkins wrote

UTL_FILE Problem Solved

everyone has a great weekend. David A. Barbour Oracle DBA, OCP (feeling a little lighter as I trod the path) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: Ftp

solution will be possible. Why don't you get a logon to OTN ( http://otn.oracle.com/index.html ) and do some research They also have some dandy examples. Hope this helps. David A. Barbour Oracle DBA, OCP [EMAIL PROTECTED] wrote: How can I write a PL/SQL procedur that connects to a ftp server

Re: cdump, bdump, udump

, ALTER SESSION and the dbms_trace package come to mind here). If you were able to get the doc on OFA, you now need to go and get the docs on Initialization Parameters and Oracle Supplied Packages as a minimum. Regards, David A. Barbour Oracle DBA Sinardy Xing wrote: Hi all, When those logs

Re: MTSCost based Optimzer

in the select and where clauses of SQL statements. Regards, David A. Barbour Oracle DBA Deepender Kr Gupta wrote: How would you decide that out of total big and small tables (say 1500) these are the tables need to be analysed and these are not, as in our case Transaction types are both OLTP

MTS and Cost Based Analyzer

configuration and setup of your listener. Again, go to OTN and check out the docs. Regards, David A. Barbour Oracle DBA Venkat_Kalepalli wrote: Hello folks! I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS on the Oracle server. Next we are running with Rule based optimizer

Re: Awfully annoying SQLLDR problem

-mounted drive that could be accessed by the target and have sqlldr kicked off on the target via a trigger on a simple insert by the source into a DATA_LOAD_REQUIRED table on the target? Regards, David A. Barbour Oracle DBA [EMAIL PROTECTED] wrote: Thank you ever-so-much to Tim, Kirk, Peter

Re: Listener.log

Okay, you moved the old one. Perhaps you haven't had any activity that would cause an entry to be generated for the log? Or have you changed any of the parameters in your listener.ora file? Regards, David A. Barbour Oracle DBA Nguyen Thanh-truc wrote: Hello everyone, After moving

Re: set dml_lock value without bouncing db?

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: cdump, bdump, udump

Uh oh - here's one for Mladen. Sinardy, have you ever heard of OFA? Check your initSID.ora file and check out OTN /*+ SEARCH ON OFA */ David A. Barbour Oracle DBA Sinardy Xing wrote: Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system

Re: Where can I find real-life-examples about ORACLE installations?

William, Have you tried to figure out Portal? Next to this beast, Remedy looks pretty good. David A. Barbour Oracle DBA "Thater, William" wrote: On Thu, 19 Apr 2001,Jared Still scribbled on the wall in glitter crayon: -If you're familiar with the Help Desk software 'Re

Re: Need Help.

this helps. David A. Barbour Oracle DBA udaycb wrote: Hi All, Recently we moved the database(Oracle 8.0.5) from NT to Sun machine. Now this database is going online very soon. When we were testing we observed that, the application (select statement) is running very slow. (I don't know how

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

Okay Robert, you've had you 15 minutes of fame. Too bad it made you look so silly. Jared, humor was banished (although it tends to flourish with tongue-in-cheek replies), how about political diatribes (or at least the political diatriber - is that a word?)? Regards, David A. Barbour Oracle

Re: crontab script problem

this helps. David A. Barbour Oracle DBA, OCP Rajesh Dayal wrote: Hi All, I am facing some problem while running sqlplus scripts from crontab. Env is Tru64 Unix 4.0f and Oracle 7.2.3. Through crontab all system commands run fine, but when I try to invoke sqlplus

Re: shell script to send mail

mail at all try: mail -s 'Test' myusername@myunixhostnamemsg If you don't get the mail, see your sys admin. If you do, then the problem most likely lies in one of the two files I mentioned earlier. You'll probably need to see your sys admin there as well. Hope this helps. David

Re: Oracle repository

://www.cvshome.org/ Regards, David A. Barbour Oracle DBA [EMAIL PROTECTED] wrote: I would be grateful if you can advise me if there are other products than Oracle Designer 6i which is able to build automatically a version control baseline and track the changes at the packages and stored

Re: Recovery from noarchive db corrected

a DBA. Start with one of the tuning manuals off OTN, then pick up (and read) Steve Adam's "Oracle 8i Internal Services" from O'Reilly. You'll be a better DBA, and who knows, you might even be able to teach the developers a trick or two. Good Luck. David A. Barbour Oracle DBA ---

Re: Max # of Open Files for UTL_FILE in 7.3.4.3

is heavily chained and contains 27 million rows. Sorts, orders and groups are not an option. Thanks. David A. Barbour Oracle DBA "Khedr, Waleed" wrote: I'm not answering the question but suggesting sorting your data on that date column and opening, writing to, and closing a file

Re: Unable to open the database,Urgent!!!

Saroj, It appears you do not have enough semaphores available to bring up both instances. What flavor of UNIX are you operating on? David A. Barbour Oracle DBA "Dash, Saroj (CAP,CEF)" wrote: Hi, In a Unix Machine I want to create two instance on a single server.Its memory s

Max # of Open Files for UTL_FILE in 7.3.4.3

find either the default number of files (has to be 10) or any way to change it for 7.3x. Does anyone know if it can be increased and how? Thanks, David A. Barbour Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED

Re: Concatenate rows

on a web browser, but the same syntax applies if the elements had been selected from tables. Hope this helps. David A. Barbour Oracle DBA, OCP Wendy Y wrote: Hello: Is there a way that we can Concatenate several rows (say 6 rows from a select statement) into one variable? Thanks

Re: SQL*Loader help

within the enclosures are loaded. Otherwise, the field is loaded as null. More details on whitespace are presented in Trimming Blanks and Tabs and in Preserving Whitespace. Hope this helps. David A. Barbour Oracle DBA, OCP [EMAIL PROTECTED] wrote: Maybe some could help me. I'm having trouble

Re: SQL*Loader help - Another approach

the enclosures are loaded. Otherwise, the field is loaded as null. More details on whitespace are presented in Trimming Blanks and Tabs and in Preserving Whitespace. Hope this helps. David A. Barbour Oracle DBA, OCP [EMAIL PROTECTED] wrote: Maybe some could help me. I'm having trouble

Re: Crontab

Luc, One possible solution: Run the cron every Sunday and have the first part of your shell script check to see if that day's date plus seven days falls into another month. Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth "DEMANCHE Luc (Ce

Re: Crontab - Ooops

Charlie Mengler wrote: Just curious. Using your algorithm, what happens on those rare months where there are FIVE sundays? "David A. Barbour" wrote: Luc, One possible solution: Run the cron every Sunday and have the first part of your shell script check to see if

Re: Insert without telling column names

, but as far as I'm aware, this will work only for a select * from another table. Dynamic SQL works pretty well for this kind of stuff. What are you trying to do? Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth [EMAIL PROTECTED] wrote: Hallo, How can I

Re: DBMS_OUTPUT.PUT_LINE

Roland - Depending on how your inserts are being generated, why don't you use a counter or the ROWCOUNT function? Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth "Bunyamin K.Karadeniz" wrote: I looked at the documentation and cou

Re: Insert without telling column names

or script is to be reused, it's probably best not to assume the table structure you think will be there actually is there. With humble apologies, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth William Beilstein wrote: You are misinformed. If you have

Re: Need Help For Installing Oracle On AIX

Neena, If I understand correctly, you have a server with the OS on it, and the DB on a set of external drives - right? Cable the external drives to the working server, reboot, and import the volume groups. Your database should be right there. Regards, David A. Barbour Oracle DBA Formerly

Re: problem with UTL_FILE.FILE OPEN

filesystem oracle can write to is fair game. Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth Connor McDonald wrote: utl_file_dir = * is VERY bad news... for i in ( select file_name from dba_data_files ) loop open file i.file_name for write end loop

Re: problem with UTL_FILE.FILE OPEN

uot; I'm wondering if the directory location in the procedure or package is entered correctly OR the filename is invalid for the operating system. I've had that problem when trying to dynamically name a file. Regards, David A. Barbour Oracle Database Administrator Formerly with the n