Today's Messages (on)  | Unanswered Messages (off)

Forum: Forms
 Topic: Biometric ZDKeco
Biometric ZDKeco [message #681643] Wed, 12 August 2020 03:06
Amjad_1975
Messages: 82
Registered: January 2017
Member
Hello.everyone

My question is i have a biometric machine ZDKeco which i have successfully installed in pc and i.also registered my test thumb in machine now my problem is how to view record on screen which we scanned thumb i.need guidence how use thus machine with oracle application


Thanks
Forum: Networking and Gateways
 Topic: Oracle to Sql server
Re: Oracle to Sql server [message #681645 is a reply to message #681638] Wed, 12 August 2020 05:39
mdarifdxb20
Messages: 5
Registered: August 2020
Junior Member
No i dont have any idea on this.
Forum: Backup & Recovery
 Topic: I don't have script file of an Oracle utility, named CSALTER.PLB.
I don't have script file of an Oracle utility, named CSALTER.PLB. [message #681644] Wed, 12 August 2020 05:35
Itzhak Ben-Ari
Messages: 2
Registered: August 2020
Junior Member
I have to convert character set of an old database of one of our clients.
The database version is 9i and I need to convert current character set of this database, WE8MSWIN1252, to ALT32UTF8.
I already executed CSSCAN utility which approved that this conversion will be flawless and now
I need to execute CSALTER.PLB script file.

Ufortunately, I don't have CSALTER.PLB scipt file in my $ORACLE_HOME/rdbms/admin directory, so I need you to email me this script file.
I need a CSALTER.PLB script file for ORACLE9i.
My email address is itzhak_ba@supercom.com.
Re: I don't have script file of an Oracle utility, named CSALTER.PLB. [message #681646 is a reply to message #681644] Wed, 12 August 2020 05:49
John Watson
Messages: 8321
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read

Are you sure that csalter existed in release 9.x? From some ancient notes I have, I once did it like this:

STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET AL32UTF8;
SHUTDOWN IMMEDIATE;
STARTUP;
Re: I don't have script file of an Oracle utility, named CSALTER.PLB. [message #681647 is a reply to message #681646] Wed, 12 August 2020 06:52
Itzhak Ben-Ari
Messages: 2
Registered: August 2020
Junior Member
Hi John,

I see that you right.
According to the following Oracle Support Site, CSALTER utility started in ORACLE 10G -
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=284449647594013&parent=EXTERNAL_SEARCH&sourceId=BULLETIN& id=260192.1&_afrWindowMode=0&_adf.ctrl-state=4757a47qb_266

This is what I found in ORACLE9i documentation regarding using alter database command:
The ALTER DATABASE CHARACTER SET statement does not perform any data conversion, so it can be used if and only if the new character set is a strict superset of the current character set. Another restriction of the ALTER DATABASE CHARACTER SET statement is that it can be used only when the character set migration is between two single-byte character sets or between two multibyte character sets.
WE8MSWIN1252 is a single byte character set and ALT32UTF8 multi byte character set.
Do you believe that I will run into trouble if I use alter database in my case ?
I ran CSSCAN utility and the I found no exceptions nor any convertible data, so I don't have to be worried of running ALTER DATABASE, according to this check.
Re: I don't have script file of an Oracle utility, named CSALTER.PLB. [message #681648 is a reply to message #681647] Wed, 12 August 2020 07:54
Michel Cadot
Messages: 67296
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

CSALTER does not exit in 9i.
I would not recommend to use ALTER DATABASE to migrate to (AL32)UTF8, it is sure that from 10g you will screw your Oracle dictionary. I don't know with 9i as I don't know if CSSCAN scans this dictionary and your result is safe.

The safest way is to use exp/imp.




Current Time: Wed Aug 12 08:11:13 CDT 2020