Questions tagged [oracle-10g]
Relational database management system from Oracle Corporation.
28
questions
1
vote
1
answer
2k
views
Can't create extension orafce in Postgresql
my os is redhat 7.3 and I am trying to install orafce to postgresql with psql version 9.2 and server version 9.6. Firstly, i try to install via the script orafce downloaded on github but after reading ...
0
votes
2
answers
6k
views
Eclipse will not run Hello World (Error occurred during initialization of boot layer java.lang.module.FindException: Module Moussa.java not found)
enter image description here
Does anyone know how to fix this issue in Eclipse?
It will not let me run the code. Everytime I press the "run" button the same error pops up:
Error occurred during ...
3
votes
0
answers
846
views
No Support for Oracle UDT in latest version of oracle.manageddataaccess.dll
With oracle.DataAccess.Types we were able to integrate user defined types in oracle. But In latest version of Oracle.ManagedDataAccess.Types UDT is not supported.
It seems that ODP.NET Managed Driver ...
0
votes
1
answer
643
views
How to change SQLDeveloper's language to Chinese?
I've seen many posts on how to change SQLDeveloper's language to English, by using the following method:
sqldeveloper.exe --AddVMOption=-Duser.language=en
I have tried this method with both English (...
2
votes
1
answer
2k
views
Failed to install Oracle client with an error "path is too long"
I'd like to know how to install Oracle Client on my Windows 10 pro PC/Dell Vostro 3860 properly cause of I got a problem to install the client software that "PATH is too long" error.
What I tried to ...
1
vote
1
answer
5k
views
Recommended size of memory and hard disk for a VirtualBox VM for Solaris with Oracle
I have a laptop with Windows 7 64-bit operating system. I have installed VirtualBox 5.1.14 on it. Now I want to create a Solaris 10 VM where I would like to install Oracle 10g. What is the recommended ...
2
votes
1
answer
12k
views
Error occured while installing Oracle Developer 6i on Windows 10 (64-Bit)
I have recently installed Windows 10 (64-Bit) Operating system on my computer and tried installing Oracle Developer 6i (Forms & Reports) but to no avail. It keeps failing and showing an error ...
0
votes
1
answer
232
views
Is it safe to connect (select, update, insert) to Oracle database 10G with a 11G client?
I have to work in an Oracle 10G database. The normally used client is Oracle SQLDeveloper. But it has some limitations not related to the database use (Java versions on my PC, but that is another ...
0
votes
1
answer
671
views
Comparison between Oracle RAC Cluster Database (10gR2, 11gR2 and 12cR1) and deployed Oracle DB on Linux Cluster [closed]
Oracle RAC implementation may be costly for small enterprise, but how it would be if Linux cluster is implemented and then standard Oracle DB is deployed on that cluster to achieve availability like ...
0
votes
1
answer
914
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 ...
1
vote
1
answer
1k
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
1
answer
2k
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 ...
4
votes
2
answers
21k
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
1
answer
1k
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
1
answer
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
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 ...