I am working on Oracle 8.0.5. Sometimes when I start the machine, I get Error - > ORA-1034-Oracle Not Available. What could be wrong? How can I manually remove Oracle 8.0.5 from the system?
To access the Oracle Database through the client, the TNSListener80 service must be started but on my Server machine, the TNS Listner Service is not working and still I am able to perform all the functions on the database. How is it possible?
I have a number of tables in the Salary Database. I want to modify the Salary of some employees. Is is possible through SQL, to search each table for the existence of Employee, say, ECode= 453. Incase the Employee exists, disable the constraints applicable on the table, modify his Basic Salary...
Does Import / Export of Database, change the Internal RowID of Data being maintained by Oracle. Does installing a new version of Oracle, changes the RowID of Data already entered through the lower version.
Hello
I am faced with a wierd problem. The tablespace of my database is growing contantly and is nearing the limit. What needs to be done? How can I reduce it? Can it lead to Oracle crash. Any suggestions. I am new to databases.
Thanks
ksr
I have a Table having "Security" field as VARCHAR2(2000). The contents of this field are something like "2-3//4; 1/2MIN; 3/4-5MIN MIN; 2&3//5/6 3/4-5MIN 1-2/3//4-5;" and so on. There may or may be delimitters like ";" above. The input in the Table is coming from a Security Form designed in VB6...
I have a Cutomer Table having Customer Ids as "123 J","342-J","786","876/J","453 JAL". I want to update this Table and all other Tables wherever the pre-updated value of "CustomerId" exists in the Database with only the Numeric portion of CustomerId concatenated with 3 character code like "JAL"...
Is it possible with a single SQL Statement to know the names of all the tables having column "MemberID" and check the existence of "MemberId - 2365NRM" is all the scanned tables.
I have a Members Table having a column name as "MemberId", which is of varchar2 datatype. The MemberIds contained in the Table generally are "1NRM", "2NRM","3NRM" and so on. Now when I sort the Table on MemberId, the sorting output comes as...
Dear Sir,
I am working in an organisation whose area of operation spreads all over the state. It has got 85 branches (presently, likely to expand) located at far distances, all over the state. Each branch shall have One Server and three other networked computers with modem connected to the...
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.