Search results for query: *

Now the NLS_LANG format is AMERICAN_AMERICA.CL8MSWIN1251 How to modify it ? do i just have to change the regitry key for the right value? or do i have to make a new install ? Thanks for your help SantaMufasa and Sem

Hy SantaMufasa I've tried the requiest and here are the results I've inserted in both database the name AZERTY which is in cyrillic something link a (Fi)(mu) Y KEH in database A (CL8ISO8859P5 character set) i see ?????? Typ=1 Len=6 : 63,63,63,63,63,63 in database B (CL8MSWIN1251 character set)...

Hy every one I'm working on a windows 2003 server and Oracle 10g server standard my windows OS is english and i add the Russian for keyboard. the install of oracle was made with both the Russian ( CL8ISO8859P5 ), english languages. I have created a database A with the character set...

Hy i've got a simple question, is there a way to make the function dmbs_repair.check_object verify more than one table? I'd like to check each table of a particular schema. Thanks for your help. Best regards.

Hy we had the same problem few months ago and we also tried the flush memory solution but it not solved the problem just reduce the frequence of the problem. We so found out that it could be an oracle software problem. We so upgarde oracle to 8i1.7.4.1 and since the problem never occurr again...

Hello all, This subject may not be helpfull but is to train to good react to a specific problem. some mounth ago i got a bad experience with corrupted block in a windows 2000 Server Oracle database 8i1.7.0 I made some research and i read that the package dms_repair is helpfull to detect and...

I sorry for the lack of information i gave. The database is running under Win2K Server. Thanks Mufasa have you got a same tips under windows

Hello everybody, Do you a know if there is a way to find out if Oracle database has corrupted block by the way of a query? not reading each morning the log files ? Thanks,

You'r write LKBrwnDBA thanks

hello my question may seem simple but i don't find a solution for the moment i hope that one of you can help me. I made a soft with a function that call a query that delete on cascade informations in lot of tables. When i apply this function the soft seems frozen. the query is Ok but while the...

Hello i was used to work with Oracle 8i and using Pro*C. the makefile i used analyzed the .pc file to generate a .c then gcc make the executable file. The uses of the same makefile under Oracle 10g create a new file with the extension .lis Resume Oracle 8i...

I saved my most used scripts in files and i was used to execute a script in server manager by the way of @<Directory Way>/ScriptName.sql When i learned that server manager is no more supported by oracle 10g, i decided to use SQL Plus. Problem : sometimes the execution of @<Directory...

Hello, i'm going mad with the error unable to allocate.... I follow your advise and i grow the size of java_pool_size and shared_pool_size But the error occurred one more time. For memory the OS is Windows 2000 Server, Oracle Standard Edition 8.1.7.0 My source code use bind variable, i flush...

I think i was not clear enought. I create the database link with enought priviledges. the answer of this request : select * from Table@link; is : Field1 Field2 ----------------- 1 one 2 two 3 three but the following request select Field1, Field2 from Table@link...

Hy, I successfully create a public database link from my oracle database (vers. 8.1.7.0) to an SQLServer. from server manager i succeed the command : select * from table@SQLSERVER; but if i try to specify the field i want to report from the SQLServer table the command failed select field1...

Hello, I'm a newbie with SQL Server. I'd like to know what is the best way to connect to a windows SQL Server database from a linux RedHat 7.3 system. is there a dedicated client for SQL Server under Linux? Will i have to use an ODBC under linux if it existes? is there an sql server language...

Thank for your answer, but can you explain me the link between the two variables shared_pool_size and java_pool_size. I don't use any java code in my program, i just call store procedure and function from C code. Or the name java is not really good if it is used for other things. I will made...

Hy every body, I've got different database server with the same hardware configuration and same database structure. But if some databases work fine (one year with no particular intervention) I've got one the every two or tree week is down because of the error unable to allocate 4096 byte of...

Hi All Is there a red hat linux driver to connect with sql Server? if yes where can i find it Thanks

hi just a simple question : does one of you knows some difficultes to upgrade a db2 version 7.2 to a 8.1 my question is more for the differences with the embedded sql code that make request to the db2 database. do you also know if the linux client for version 7.2 is the same for the 8.1 version...