Questions tagged [oracle-10g]
Relational database management system from Oracle Corporation.
28
questions
1
vote
1
answer
913
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 also ...
0
votes
1
answer
1k
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 Server ...
1
vote
1
answer
457
views
Login Issues with Oracle databases
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
1
answer
15k
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:
...
2
votes
2
answers
10k
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
1
answer
19k
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
3
answers
13k
views
OS X Lion - Installing Oracle 10g Standard Edition
I'm trying to install Oracle 10g on to OS X Lion. I have previous achieved this on Snow Leopard with the following tutorial.
The issue I'm having is that the ulimit settings in the oracle/....
1
vote
1
answer
76
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.
3
votes
5
answers
34k
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
2
answers
12k
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 ...
0
votes
1
answer
3k
views
Can't connect SQL*Plus to Oracle 10g from within VMWare Fusion VM
I am attempting to connect to an Oracle 10g server (remote host on LAN) from within a Windows XP VM hosted by VMWare Fusion on OSX. While I can connect to the service using Oracle Net Manager, I can ...
1
vote
0
answers
336
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 ...
16
votes
3
answers
72k
views
How can I change the binding order of network adapters in Windows 7?
The end goal here is that I am trying to install an Oracle 10g server on my Windows 7 x64 dev box. I use DHCP, and the Oracle installer is throwing up this warning:
Checking Network Configuration ...