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 Chris 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: *

  • Users: spesknight
  • Order by date
  1. spesknight

    CREATE TABLE LOOP of dates

    When you do FULL_CT = (SELECT COUNT(BOOK_ID) FROM CJI_BOOK_RELEASE WHERE TO_DATE(POP_DATE, 'MM/DD/YYYY') full_ct will have the count at 00:00 AM. I think you need the count at 12:00 PM. Try this FULL_CT = (SELECT COUNT(BOOK_ID) FROM CJI_BOOK_RELEASE...
  2. spesknight

    ORA-03113: end-of-file on communication channel

    It seems your connection to the db is dropped after you launch the procedure, or you opened your session before a restart of the db. There could also be a problem in the db engine, try to look at the alert.log file
  3. spesknight

    Easiest way to import 8i into 9i ?

    You should do it without problems, if you have access to metalink, read note 132904.1. How do you launch the import? Maybe the problem is in the way you launch it and not on the dump file.

Part and Inventory Search

Back
Top