Sqlplus formatting problem with English and Unicode

lumn. Any idea on how 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

RE: Re: Documenting databases

d what relationships exist between them. It's also great to give to managers who love diagrams... :-) Thanks again, Alan Alan Aschenbrenner Oracle DBA I

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 de

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 O

Unicode: UTF-16 to UTF-8 conversion

I have read 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

Re: Bus Error (Urgent)

rocess 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

Re: streams comments

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

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 Oracl

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 an

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. . Alan Jare

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 delet

RE: 8.1.7.3 - Good or Bad?

y* 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 the offic

8.1.7.3 - Good or Bad?

is release? Thanks, 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 Inter

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! Al

Re: Number of CPUs vs. Speed of CPUs

marking Pentiums (up 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=

RE: Multiple Listeners

also send the HELP command for other information (like subscribing). -- Please see 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 I

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: OT - Wrap-up of 'Serious Question (believe it or not)...'

PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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 se

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

RE: Script that will remove redundant rows from table

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: Alan Aschenbrenner INET: [EMAIL

RE: What is the cost of replication?

don't use 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 W

RE: Removing files with PL/SQL

he command. 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 D

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

/etc/system parameters on Solaris 8

know that story.  Ask Ross Mohan for the details on Metalink   Thanks,   Alan   Alan Aschenbrenner Oracle DBA IHS Group (303)-858-6394 [EMAIL PROTECTED]