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 Rhinorhino 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: doti
  • Order by date
  1. doti

    Date format in oracle/sql

    I don't need two columnt to hold the same date. what i want is to have: two columns like this: Time Date_ 17:30 20/03/05 can i do it in some simple way without modifying the select statement????
  2. doti

    Date format in oracle/sql

    ok, but I changed the NLS_DATE_FORMAT a few times already My current settings are: NLS_DATE_FORMAT='dd/mm/yy hh24:mi' I created a table: create table TimeTable( event_id number(2) constraint e_pk primary key, cinema char(20), title char(20), time date, date_ date, income number(4)); then i...
  3. doti

    Date format in oracle/sql

    Unfortunatelly, it doesn't work. In my database I have entries for time which are to be of the format hh24:mi but i also have entries for date - yyyy-mm-dd when i try to set the format of date f.e alert session set NLS_DATE_FORMAT='hh24:mi'; it changes all the entries in my data base to...
  4. doti

    Date format in oracle/sql

    Hi, I have a small problem with date format while creating a table under oracle sql. I want to create a table in which one of the columns will be the starting time of the movie f.e 17:30; I typed: create table Movie_tbl( Movie_Id number(2), Title char(20), Time date); and then I wanted to...
  5. doti

    swap problem

    i tried the Thread60-686702, but i cannot create the swap file. It says that there are no swap devices available. in my partition table there is no swap partition. I tried to modify the partition table but it was impossible since I had other partitions mounted. is there anything i can do to...
  6. doti

    swap problem

    hi, I have problem with my swap, it's too small the input of df -h for swap is: swap 73M 300K 73M 1% /tmp I need it to be 400MB at least then if i type swap -s there is: total: 93504k bytes allocated + 8660k reserved = 102164k used, 76268k available but swap -l gives back: no swap...
  7. doti

    java.lang.OutOfMemoryError

    Hi, I am installing Oracle 10 on my Solaris platform. I have done it before on the other computer ( exactly the same as this one - the same components and parameters) and there was no problem. Now during the installation there is an error: Exception java.lang.OutOfMemory Error: requested 16400...
  8. doti

    java.lang.OutOfMemoryError

    Hi, I am installing Oracle 10 on my Solaris platform. I have done it before on the other computer ( exactly the same as this one - the same components and parameters) and there was no problem. Now during the installation there is an error: Exception java.lang.OutOfMemory Error: requested 16400...
  9. doti

    Java problem

    Hi, I am installing Oracle 10 on my Solaris platform. I have done it before on the other computer ( exactly the same as this one - the same components and parameters) and there was no problem. Now during the installation there is an error: Exception java.lang.OutOfMemory Error: requested 16400...
  10. doti

    missing packages

    ok thanks a lot it is working
  11. doti

    missing packages

    yes, there are only patches...
  12. doti

    missing packages

    hi I am using solaris 10 and I am missing SUNWlibms and SUNWi1cs can you tell me where i can download them from????? thanks doti
  13. doti

    oracle 10 on solaris 10

    i have a problem with installing oracle 10 on solaris 10. At the beginning of installation it says that: Checking operating system version: must be 5.6,5.7,5.8,5.9, Actual 5.10 Failed<<<< What can i do about it. Can i overcome it in some way??? Thanks in advance for your help. Doti
  14. doti

    gunzip file

    Thanks for milion, I moved it despite it tokk me some 3 hours :-) and coul unpack successfully.
  15. doti

    gunzip file

    ok any instructions, how should i do it???? i checed man pages for gunzip but there is nothing about unpacking to certain directories.... how should i do it??? doti
  16. doti

    gunzip file

    hi, I have the oracle version in gzip format on the cd. I need to unpack it to the hard drive. Do i have to copy the file from dcrom to the hard drive and then unpack or can i unpack it stright from the cdrom??? thanks in advance, Doti
  17. doti

    cannot use admintool

    Thanks for milion, it's working, i can log now as oracle Thanks once again!!!
  18. doti

    cannot use admintool

    so, in /home directory there is nothing i mean it's empty. i have already tried userdel and i have created the user again using /usr/sbin/useradd -g oinstall -G dba oracle; and the result is the same i don't have any directory in /export so how can i change the directory for /export/home/oracle???
  19. doti

    cannot use admintool

    the entry for oinstall is in the /etc/group and looks like this: oinstall::101:
  20. doti

    cannot use admintool

    there is no such entry in/etc/passwd instead there is : oracle:x:101:101::/home/oracle:/bin/sh

Part and Inventory Search

Back
Top