I have an intel celeron 1.1 Pc with 815EEP2 intel Motherboard with 512 SDRAM support.I have changed one 128 MB RAM but it is not working in my PC, working in other PCs perfectly.I have checked the RAM slots and they are perfectly working.I have interchanged the RAMs between the slots still not...
I have a Celeron 1.1Ghz PC running in win98. I want to install Oracle8(Personal) and D2K in my machine. i am facing the following problems at the time of installation :
Problem - 1 : My Oracle & D2k installer are not of same version. So when I am trying to load D2k after first...
Hi,
Sorry, it is not possible. Any way you have to start the listener of the database first, otherwise VB or any frontend tool can connect it. But you can shutdown the database by telnet.
With best wishes.
When a row gets locked I querying the SID & Serial# from v$session and issuing the command ALTER SYSTEM KILL SESSION 'SID,SERIAL#' from system user.But the session most often does not get killed.Most of the times database needs to be shut down . Suggest alternative ways to get rid of the locks.
Hi,
Your are missing a comma after APLICATION_YEAR NUMBER(4)though I don't know whether it is a typing mistake or not.Apparently there is no mistake in the line no.1. But you can try by changing the table name without using any reserve word.My suggestion is, you may use VARCHAR2 instead of...
Hi smacattack,
dba_temp_files shows informations similar to that of dba_data_files for the temporary files in the database. You can see these by writing;
SQL> SELECT TABLESPACE_NAME,FILE_NAME,BYTES,
AUTOEXTENSIBLE
FROM DBA_TEMP_FILES;
Probably DBA_TEMP_FILES are new for Oracle...
Hi,
Write in SQL prompt :
SQL> DESC DBA_FREE_SPACE;
sql> SELECT SUM(BYTE)/(1024*1024)
FROM DBA_FREE_SPACE WHERE
TABLESPACE_NAME =DATA (or you can write &1
for generalization)
GROUP BY TABLESPACE_NAME;
I hope this will solve your problems...
Hi JadeDesign,
Your problem seems that it is a communication problem or the user written program is not logged on. So, hope this will solve your problem.
With best wishes.
Koshal.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.