Sqlplus formatting problem with English and Unicode

to make sqlplus format the unicode correctly? Another way to put this is, how can I tell sqlplus to format it's columns character-wise, rather than byte-wise. I'm guessing sqlplus is too primitive to do this... Thanks, Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] -- Please

RE: Re: Documenting databases

exist between them. It's also great to give to managers who love diagrams... :-) Thanks again, Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED

Documenting databases

up with something else. So, I thought I'd ask everyone on the list how you do it. Text files? In a database (oracle, or other)? Spreadsheets? What are the pros and cons? Etc Thanks, Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] -- Please see the official ORACLE

Re: Documenting databases

Dan, That's a good idea for documenting structures inside the database. However, my database manager wants more high level info: database name / host, oracle version, listeners, applications that use it, cron job descriptions and times, main schemas and what they are used for, lists of

Unicode: UTF-16 to UTF-8 conversion

the pros and cons in the manual, but actual experiences could change my mind. Thanks, Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: Bus Error (Urgent)

was picld, an O/S process that is known to have a memory leak. Hope that helps... Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED

Re: streams comments

share? Thanks, Alan --- Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] [EMAIL PROTECTED

RE: JDBC and MTS

The bug Jeffrey is referring to is supposedly fixed in 8.1.7 (but I've seen metalink posts that suggest otherwise). The bug numbers are 1304130 and 1309641 - the dispatcher goes to sleep occasionally for 60 seconds before waking up and servicing requests again... Alan Aschenbrenner Oracle DBA

Re: Replication

Robin, If you can have an hour of downtime, you could probably just create a clone of the original database and be done with it (but make sure you change the DB Name and the DBID if you are using RMAN). Of course, depending on your disk and network speed, this could take more or less that

Re: Unix - scheduling

Aww, come on, crontab -e isn't that bad! The most dangerous thing about it is accidentally running crontab -r instead of -e. Using crontab -e is no worse than using a wildcard with the rm command, i.e. 'rm a *' instead of 'rm a*'. One deletes all files that start with 'a', the other

Re: Unix - scheduling

Jared, Point taken. So I guess I like to live on the edge a little... :) I've been using crontab -e for years without problems though. knock on wood. Alan

RE: 8.1.7.3 - Good or Bad?

(a *very* painful experience) ... Kevin makes it sound like a terrible patch. What do all of you think that have gone to 8.1.7.3? Was it worth it? Anyone using LOBs and/or XML utilites with this release? Thanks, Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] -- Please see

8.1.7.3 - Good or Bad?

, Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] -- 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: One way replication in multimaster environment

One way to handle this problem is to not schedule your jobs to push from Y and Z to X. If transactions occur on Y and Z, they will become deferred transactions, waiting to be pushed to X, but will never push. Then, periodically you can delete the transactions from Y and Z (bound for X). I

Re: PATCH?

Lisa, Instead of a patch, I'd say it's more like a core dump. :-) Although, a core dump usually frees up resources, but in this particular case the resource load will only continue to go up over time. Maybe it's closer to a forked process in either case, good luck and congrats!

Re: Number of CPUs vs. Speed of CPUs

to the 2.4 GHz chip) against Athlon XP + (up to the Athlon XP 2100+) chips: http://www.anandtech.com/cpu/showdoc.html?i=1605 And for those of you curious about the future of AMD, here's a sneak peak at the Claw Hammer: http://www.anandtech.com/cpu/showdoc.html?i=1591 Alan Aschenbrenner

RE: Multiple Listeners

= (SID_NAME = DBAME2) (ORACLE_HOME = /path/to/oracle/home) ) ) After you have set this up, you can start the listeners individually: lsnrctl start listenerdb1 lsnrctl start listenerdb2 Hope that helps... Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] (303

RE: Multiple Listeners

-- Author: Alan Aschenbrenner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

RE: OT - Wrap-up of 'Serious Question (believe it or not)...'

://www.orafaq.com -- Author: Alan Aschenbrenner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

RE: What next ?

You think an 11:1 database to dba ratio is bad? Try about a 35:1 ratio! Just not enough hours in the day to check on them all Alan Aschenbrenner IHS Group [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (303)-858-6394 -Original Message- Sent: Thursday, June 07, 2001 1:47 PM

RE: Script that will remove redundant rows from table

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

RE: What is the cost of replication?

guis anyway, right!? Metalink has some good tars that demonstrate command line setup and maintenance Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 16, 2001 11:56 AM To: Multiple recipients of list ORACLE-L We have advanced

Removing files with PL/SQL

Hey listers, Does anyone know of a way to remove files from an O/S file system using PL/SQL without calling a java or an external C routine? Thanks, Alan Alan Aschenbrenner Oracle DBA IHS Group (303)-858-6394 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http

RE: Removing files with PL/SQL

. host erase c:\my_dir\my_file.txt [EMAIL PROTECTED] 03/02/01 02:32PM Hey listers, Does anyone know of a way to remove files from an O/S file system using PL/SQL without calling a java or an external C routine? Thanks, Alan Alan Aschenbrenner Oracle DBA IHS Group (303)-858-6394 [EMAIL