Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gansen

    how to check lowercase letters in a string value?

    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
  2. gansen

    locking problem with tables

    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 /
  3. gansen

    Reg :- errror in oracle

    what os you are in and what ver of oracle you are using
  4. gansen

    TNS Lost Contact

    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.,
  5. gansen

    Oracle Error with shared memory

    use shutdown abort
  6. gansen

    Installing Oracle8i problems on SuSe Linux7.3. Need Urgent Help

    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
  7. gansen

    Setup problem in Personal Oracle8i

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

    Oracle .trc files

    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.
  9. gansen

    listener trouble?

    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
  10. gansen

    advanced queueing support

    Recreate the package and try
  11. gansen

    Problem in Oracle Import

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

    ORA-12505: TNS:listener could not resolve SID given

    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
  13. gansen

    Length change

    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...
  14. gansen

    not connected to ORACLE

    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
  15. gansen

    Create Controlfile Fails

    use alter database rename command to rename the datafile and try
  16. gansen

    Question for a champion : 2 instances with different charset

    unset variable NLS_LANG and try
  17. gansen

    display output horizontally instead on vertical

    Here is my question select column_name from dba_tab_columns where table_name = 'EMP'; Gives column_name ------------ ename empno salary mgr Is there a way to get the above output in a single line like ename empno salary mgr Thankz in advance
  18. gansen

    Query/Procedure to recompile all views and triggers

    Try this in sqlplus do set heading off set feedback off set pagesize 0 spool alter_view select 'alter view ', view_name, ' compile',';' from user_views; spool off @alter_view.lst do the same for user_triggers
  19. gansen

    relation betweel rollback segment and redo logs

    Rollback segment hold uncommited data, for further rollback Redo logs has commited and uncommited transaction., Once you issue a commit, rollback segment for that transaction is removed and ready to hold data for next transaction

Part and Inventory Search

Back
Top