Relational database management system from Oracle Corporation.

learn more… | top users | synonyms

0
votes
0answers
19 views

Cannot run an application as a non-admin

Ladies and Gents, Please Help >_< Scenario: Hospital setting, all PC on the same domain and have a mess of GPOs pushed to them... An application (Horizon Blood Bank) compatible only on XP needs ...
0
votes
0answers
32 views

Load data from mailbox to oracle table

I have an incoming mail which has the below format in the body Number of output records -: Consumer Extract |: TOTL_OUTPUT_REC: 10684 Number of output records -: Campaign Extract |: TOTL_OUTPUT_REC: ...
0
votes
0answers
122 views

Failed to open a session for the virtual machine, obiee sample app (windows 8)

I have just installed virtualbox 4.3.14 r95030, that works fine; have decided to install obiee sample app v406 on it that worked fine, however when it comes to starting it i get the dreaded failed to ...
0
votes
0answers
84 views

TNS: protocol adapter error when it is tried to login from DevSuiteHome

I installed Oracle Database 10g Release 2 (10.2.0.1.0) for Microsoft Windows and Oracle Developer Suite 10g (10.1.2.0.2) for Microsoft Windows (my OS is Windows 7). I can login to the database by ...
0
votes
0answers
114 views

How to load the BLOB to oracle table

I need to load blob files to one of my column in the table. I have the list of .pdf files placed in the folder( which i have fetched and loaded to the Temporary table ). - please see below Temp ...
0
votes
1answer
273 views

Oracle Linux 6 download files?

I want to download Oracle Linux 6 for basic use to install on my laptop to use oracle 11g r2 database since this is one of only few linux distros which is supported. When I go to the downloads section ...
0
votes
1answer
392 views

“Access denied” error when setting up Oracle 10g

I have installed Oracle 10g on my Windows XP SP3 system. When I try to add TNSORANAMES.ORA to the ADMIN folder, I get the following message: ERROR:-ACCESS DENIED. What is the problem and how can I ...
1
vote
1answer
535 views

Get a list of net service names in Oracle 10g

I'm trying to connect to a Oracle 10g database using the "Oracle Administration Assistant", however there's a field there called "Net Service Name". I'm not sure what to put in there, I only have ...
0
votes
0answers
2k views

can't start listener, TNS-12541: TNS:no listener

I couldn't start oracle, I check services, listener was not started, I try start get error: The OracleOraDb10g_home1TNSListener service on Local Computer and then stopped. Some services stop ...
2
votes
1answer
2k views

“Edit” command in SQL Developer

In Toad, you can use edit tablename where ... and then simply edit the data in DB. Is there any equivalent in Oracle SQL developer?
0
votes
1answer
516 views

What command in MySQL is like the command “host” in oracle sqlplus

Oracle sqlplus allows you to drop down to a system command line shell which lets you run operating system command like ls, cd, cp, etc. Here are examples SQL*Plus_FAQ, docs.oracle.com Is there some ...
0
votes
1answer
2k views

X11 on CentOS VM with OS X Lion client

I am using OS X Lion. I have a Vagrant box running CentOS 6.0 minimal on my mac. I am trying to install Oracle 10g on my CentOS 6. I keep getting an error Can't connect to X11 window server I have ...
1
vote
1answer
477 views

Updating a table in oracle using another table rows

I want to update each row of a oracle table based on another table's rows. To be more specific, There's a table called Contact with the following fields: code(PK), name, mobile, email There's ...
0
votes
1answer
797 views

how to permanently set hostname for sqlplus?

I have the following situation: a windows 7, 64-bit OS; in which I have an Oracle 10g setup; on top of Win 7 - XP Mode; in which I have Oracle 11 client. As I try to connect to the Oracle ...
1
vote
1answer
401 views

Oracle - strange behavior - why?

I had to setup an Oracle environment. The stage is as follows: there are Oracle 11.2 client and 10g express server, the OS is Windows 7, 64-bit. I have the ORACLE_HOME, ORACLE_SID and PATH env. ...
1
vote
1answer
5k views

How can I connect to an Oracle database through a shell script?

I have tried to connect to an Oracle database using the below command: sqlplus -s LOGIN/PASSSWD@SERVERNAME:ORA_PORT/SERVICE_NAME However I couldn't connect. It was throwing the following error: ...
1
vote
2answers
4k views

How to delete a database file (.dbf) from Oracle 10g?

I need help deleting a DB file from Oracle. I suppose I should use the DROP command, but I cannot make it work. I tried dropping all the users, except system user, from dba_users, hoping that this ...
3
votes
1answer
15k views

How to remove Oracle 10g from Windows 7?

I have to remove Oracle 10g XE from my PC. It turned out to be far more complicated than I had thought: I couldn't find any suitable software products to remove from 'Add or Remove Programs'. I then ...
1
vote
3answers
13k views

OS X Lion - Installing Oracle 10g Standard Edition

Im trying to install oracle 10g on to OS X Lion, I have previous achieved this on snow leopard with the following ...
1
vote
1answer
61 views

Why does oracle move id's to caps?

I had lowercase id and it didn't find it until I moved it to caps.
1
vote
3answers
8k views

How to backup certain tables in oracle?

I want to continue working on oracle db from home and I need certain tables I created. How do I back them up then restore them?
0
votes
2answers
9k views

Oracle 10g Client for Windows 7?

I downloaded the Oracle 10g Client Release 2 from this link, the one that says it is compatible with Vista, Windows Server, and Windows 7. However, when I run the installer, it says that the ...
1
vote
0answers
331 views

Complete removal of Oracle Developer Suite 10g from Windows XP (SP3) [duplicate]

Possible Duplicate: Complete removal of Oracle Developer Suite 10g from Windows XP (SP3) Does anyone know how to remove/uninstall Oracle Developer Suite 10g from Windows XP (SP3) ? It's not ...