Reputation
2,671
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
7 20
Newest
 Yearling
Impact
~283k people reached

1d
comment sqlplus (Oracle XE) doesn't start on CentOS 7
Besides the PATH variable you have tset and export the ORACLE_HOME and LD_LIBRARY_PATH variables, too. Because you use the same Oracle installation as the database you should set the ORACLE_SID, too.
1d
comment sqlplus (Oracle XE) doesn't start on CentOS 7
This error message means that bash does not find the sqlplus program. You have to set up your environment appropriate. But that will not help to run Orace if Tomasz Klim is write.
1d
comment sqlplus (Oracle XE) doesn't start on CentOS 7
how do you start sqlplus? what is the exact error message?
2d
revised How to fix an ORA-12505 error?
edited title
2d
revised ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
corrected a copy and paste error: the listener output was pasted in the tnsnae entry
Jun
26
comment Oracle user locks (dbms_lock): guaranteed order of requests granted?
-1 , that is not a useful answer without any references
Jun
26
comment Partitioning existing table in Oracle
why do you file the foo table with a select? Why don't you directly fill the LOGGING_EVENT_PARTITIONED with a select from LOGGING_EVENT?
Jun
26
comment Partitioning existing table in Oracle
these picture are not useful. Can you show us a describe foo and a describe LOGGING_EVENT_PARTITIONED
Jun
26
answered Using output value of column from function for another column in SQL*Loader
Jun
26
comment DBMS_REDEFINITION don't copy data?
1) It seems that you want to redefine your table frequently to get rid of the data in the table. 2) And it seems that you assume that the redefinition does not disturb the processes loading the data. But 1) is not the intended purpose of the redefinition process and you have to check if 2) is true. The term 'online' sounds nice but maybe it does not work as you expected.
Jun
25
answered Error trying to SET a field when two fields in different tables match
Jun
25
comment Error trying to SET a field when two fields in different tables match
I think tha is MsSql Syntax. For mysql you need: UPDATE ykz2d_maps_integration as ymi join ykz2d_crmery_deals as ycd on (ycd.company_id=ymi.company_id) SET ymi.catid='584' ;
Jun
24
revised DBMS_REDEFINITION don't copy data?
added 18 characters in body
Jun
24
answered DBMS_REDEFINITION don't copy data?
Jun
23
comment Dual table default value?
the output of your second query is a fake. The actual ouput contains the caption 'N' and not 'D'.
Jun
23
comment error:ORA-01008: not all variables bound
There are a lot of error messages in the Oracle 9i Error Messages manual that i cannot find in the manuals or the alter releases. ORA-01008 is one of them.
Jun
23
comment ORA-00933: SQL command not properly ended from function
There are a lot of error messages in the Oracle 9i Error Messages manual that i cannot find in the manuals or the alter releases. ORA-0933 is one of them.
Jun
22
comment Is it possible to upgrade Oracle 8i to 12c?
there is a manual covering upgrade of databases docs.oracle.com/database/121/UPGRD/toc.htm
Jun
22
comment error:ORA-01008: not all variables bound
-1 That is not a useful question. A lot of information is missing. It is almost impossible not to find an answer to this question hen . This is the first answer I found.
Jun
22
comment error:ORA-01008: not all variables bound
-1 no, that is wrong. In this case the error is 'ORA-00947: not enough values', see sqlfiddle.com/#!4/9c503/1