| Recent Answers from Edson |
 |
2008-09-04 snap shot dropping(internal error): This can be many things, but the last time I saw this I had to put oracle down and then star it again. The problem occurred because the data dictionary was corrupted, and when I reinicialized the database...
|
2008-07-17 Rearrange Columns in Table: There is not a thing such this. What we usually do is to create another table with the same structure and data of the main: create table a_bkp as select * from a; Then, disable the indexes (pay...
|
2008-07-01 describe all tables in database: There is not a thing such that. What you can do is to make a script: SET HEAD OFF SPOOL D:\SCRIPTA.SQL select 'PROMPT ' || A.TABLE_NAME || CHR(13) || 'DESC ' || A.TABLE_NAME SCRIPT from cat...
|
2008-06-30 Profile: "oratab" is a file created by Oracle in the /etc or /var/opt/oracle directory when installing database software. Originally ORATAB was used for SQL*Net V1, but lately is's being used to list the databases...
|
2008-06-26 Oracle8i- TNS could not resolve service name: Hi there. It can be many things, but there are some more possible: 1) The file TNSNAMES contains the configuration of host and sid of the remote oracle server. See if its rigth. 2) Do you have...
|
| More Answers for "Oracle" |