Recent content by gansen

the only way you can check is by checking the ascii value of the first character of the column ex : column name ename table emp select ename from emp where ascii(substr(ename,1,1)) between 97 and 122; Hope this help to solve your issue

select l.lmode, l.sid, l.id1, o.object_name from v$lock l, dba_objects o where type='TM' and o.object_id=l.id1 /

what os you are in and what ver of oracle you are using

Oracle and Developer should be installed on different directories., If you are using the connect string then check for TNS_ADMIN string in the registry where its looking for the tnsnames.ora config file and make sure the connect string exists in the file.,

use shutdown abort

what terminal type you are using while running runinstaller It should be set to xterm, export TERM=xterm It the TERM is set to xterm and still you have problem then you might have to set the ORA_NLS33 parameter to $ORACLE_HOME/ocommon/nls/admin/data Hope this will solve your issue

You better do a fresh install, which may solve your issue Dont forget to delete entry in registry before doing fresh install

You can keep a month data and delete the old ones., Trace files are only useful when something goes wrong like system crash which wont happen freqently., If its unix platform you can run a cron job to do this in an automated fashion., Hope this helps you.

Have you started the listener through services., Everytime you start the database you have to start the listener., Let me know the exact error with error no, so i can help you

Recreate the package and try

It looks like initial value is o/s specific If unix make sure initial value less than 2 Gig

after adding an entry in listener, have you stopped and started the listener, if not do it, it solves your issue., If not, check the connect_string is same as the entry in tnsnames.ora

select x,x,x, to_char(decode(trans_ukey1, 'HOME', rate1, trans_ukey1)) department from x as per my knowledge the rate1 column or trans_ukey1 conlumn must have a value of lengrh 40, thats why the col is created with 40. Try inserting a value of 233 length in rate1 column or trans_ukey1 column...

Oracle 8i personal edition is good to practise in home., Oracle 8i enterprise edition needs more memory and diskspace Try increasing your memory which will solve the issue Is oracle running before you connect using sql*plus

use alter database rename command to rename the datafile and try