Search results for query: *

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????

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

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

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

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

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

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

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

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

ok thanks a lot it is working

yes, there are only patches...

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

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

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

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

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

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

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???

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

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