Oracle 11g is the July 11th, 2007 release of Oracle’s primary database product. New features added in 11.0.1 include Virtual Columns, Automatic Memory Management and Interval Partitioning.
0
votes
2answers
371 views
Oracle dump import
After a system failure I bought a new server and now I'm trying to recreate the Oracle database I had.
I have a dump file which was made with the command exp and full=y. Can I restore the full ...
4
votes
2answers
451 views
Hibernate Query Running Slow
I am currently facing a problem with a slow running Hibernate query that is being kicked off from a Java program. It is making a call to Oracle 11g at the back end.
This query is taking anything from ...
2
votes
1answer
548 views
Oracle error “too many values”, must be solved with nested SELECTs
I have hit upon a "too many values" error in Oracle, when working with some intricate nested SELECTs.
A simplified description of my problem, on a toy problem describing the hierarchy in a company. ...
0
votes
2answers
1k views
sqlnet.ora or tnsnames.ora changes require reboot?
Anytime you change Oracle's sqlnet.ora or tnsnames.ora files, does the system require a reboot? In my instance, I only have the Oracle client installed on the machine I'm referring to, but out of ...
4
votes
1answer
2k views
Connection to an oracle db from another computer
I have installed Oracle 11g to an ubuntu, I can connect to DB using sqlplus from the localhost, But I cannot connect from another computer, I have configured my tnsnames.ora as followed;
ELIF =
...
9
votes
1answer
382 views
Commit vs Fast Commit vs Commit Cleanout in Oracle Database
I was wondering whether someone could verify my understanding regarding the differences between those 3 terms as pertaining to Oracle Databases.
Many sources confuse these terms and do not explain ...
1
vote
1answer
50 views
Supporting Multiple Oracle Clients
I have an application where the data repository is moving to Oracle 11g. This means we need the new Oracle 11g client on the application server to support the retrieval of their data.
Is it ...
2
votes
1answer
318 views
How do I export data from Oracle 11.1 to 10.1?
I have a 11.1 oracle server and I need to export a dump file for a client who has a 10.1 server.
While reading the documentation, I figured out I needed the 10.1 Export Utility. I searched the ...
0
votes
0answers
68 views
Connecting PCs with APEX
I am working on a Project using APEX.
I want to connect my friend to APEX so we can do work and assign tasks to each other.
Our PCs are connected to the same LAN and I can PING both PCs, however I ...
0
votes
0answers
251 views
Uninstalling Oracle 11g RAC from a Windows Server 2008
Trying to uninstall a Oracle 11g RAC from a Windows Server 2008.
Following instructions on:
http://docs.oracle.com/cd/E11882_01/install.112/e25666/rem_orcl.htm
I was able to run batch:
...
1
vote
3answers
96 views
Query missing one date; only happened today
This should be pretty reproducible I hope.
I'm on Oracle 11g. This query, which I use as part of another query, is acting strangely:
SELECT TRUNC(SYSDATE - ROWNUM) DATEITEM
...
4
votes
1answer
198 views
How to I interleave logs from two different Oracle tables?
I have two log tables, which are populated from two different PL/SQL packages. It's often useful to keep the data separate, but sometimes I'd like to "interleave" the two tables so I can see what's ...
2
votes
1answer
226 views
How do I connect to Oracle Server without installing Oracle Client on client machines?
I am using Microsoft VB.Net to create a Windows application, and would like some suggestions on how to connect to an Oracle database.
1
vote
0answers
1k views
Oracle 11g displaying ORA-01034, ORA-27101, and Linux “error 2” messages.
When I try to connect to Oracle 11g using:
sqlplus noah/noah@orcl
I get these errors:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or ...
1
vote
1answer
605 views
ORA-12541: TNS:no listener using EXPDP
I need to export an Oracle 11g database to an Oracle 10g instance. I have the command, which I believe is correct:
expdp user/pass@192.168.10.8 full=Y VERSION=10.2 directory=m_dump
...
2
votes
1answer
56 views
Regular Expression Difficulty
I'm trying to extract 456 from the string :123:456: as follows:
select regexp_substr(':123:456:', ':(\d+):', 1, 2, 'i', 1) from dual
However, this query returns null. What am I doing wrong?
1
vote
1answer
121 views
Size of an empty database
Continuing with my school-project, now I have to estimate the size of the database from here to 5 years. They give me a formula, so, in that formula, one of the values is the size of the empty ...
4
votes
1answer
10k views
How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora?
I have access to a ORACLE 11g server using the following listener.ora
# listener.ora Network Configuration File: D:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by ...
0
votes
0answers
55 views
Upgrading from Oracle 10 to 11g, what to look for in SQL embedded in code?
We're planning to upgrade our enterprise database to 11g.
We have a number of web applications using it via Weblogic and Hibernate 3.6.5, and both of those support 11g.
There are a number of direct ...
0
votes
0answers
171 views
How to Import a file to Oracle APEX & what are invalid files to import? [closed]
APEX is running. I tried to import a workspace that I exported in a 4.0 version of APEX
After choosing the file I get this message:
the export file has been imported but is not a valid workspace ...
1
vote
0answers
65 views
Port no in Oracle Forms 11G
Which port number to be used in forms 11G Preference-->Runtime--> Application ServerURL Section? I have:
1521-Given at the time of database creation
7003 and 7004-Given at the time of WLS Domain ...
1
vote
2answers
1k views
Troubleshooting Oracle ORA-08103 - object no longer exists
I am getting this error from Oracle intermittently. A trigger is truncating a partition from a partitioned table while a long-running query is running against it.
Since I'm truncating a different ...
2
votes
1answer
143 views
ETA: translate Oracle SQL queries to MySQL
task: replace Oracle 11g with MySQL
current setup:
Oracle 11g SE One
about 80 tables
stored procedures, PL/SQL are in place but out of scope for this question
client applications do not use a ...
1
vote
1answer
193 views
Help with getters & setters in PL/SQL
I am not a db guy, and I have a very beginner's knowledge bout PL/SQL. That being clear now the question:
I have 2 tables one file level & another batch level. In a day, only 1 file_id is ...
1
vote
2answers
690 views
Unable to mount oracle instance
I am trying to shutdown the system, then I want to mount it. I have tried this:
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
...
1
vote
1answer
306 views
Oracle out-of-place upgrade on same host: impdp issues
I am testing an out-of-place Oracle upgrade from 11.2.0.2 to 11.2.0.3 on the same host. From what I've read, expdp and impdp is the way to go. My problem is that since I am importing to another ...
10
votes
4answers
9k views
Best way to delete very large recordset in Oracle
I manage an application which has a very large (nearly 1TB of data with more than 500 million rows in one table) Oracle database back end. The database doesn't really do anything (no SProcs, no ...
-4
votes
1answer
1k views
primary key, foreign key relationship between the department and employee tables How do I install? (sql_developer) [closed]
EMPLOYEES TABLE
COLUMN NAMES:
EMPLOYEE_ID
EMPLOYEE_NAME
EMPLOYEE_LASTNAME
JOB
EMPLOYEE_BUSINESS_PHONE
EMPLOYEE_GSM
SALARY
HIRE_DATE
E_MAIL
DEPARTMAN_NO
NOTE:FOR THIS TABLE: EMPLOYEE_ID IS PRIMARY ...
2
votes
0answers
1k views
Encoding problems with sqlplus, Linux
I use sqlplus and all non-Latin characters appear as '?' when I run select queries. When I run insert or update queries with non-Latin characters I get question marks on a web page.
select * from ...
0
votes
2answers
722 views
Oracle - capture row commit order in a table
Is there a way to capture the order in which rows get committed in a table ?
Our application has clients that query the table based on a sequence_id column of the table, that is supposed to reflect ...
2
votes
0answers
124 views
How to Connect R to Oracle?
I need to connect R to oracle and I have been unsuccessful so far. I downloaded two packages: RODBC & RODM.
This is the statement that I've been using: DB <- ...
0
votes
1answer
155 views
How to troubleshoot/debug Oracle permission problems
An application is connecting to Oracle to do stuff. It's not working but I don't get any ORA errors in the application itself. I'm thinking its a permission problem. So my question is what is the best ...
0
votes
1answer
70 views
Can you search using an index while indexes are being updated in oracle11g?
I am using oracle 11g. I noticed some performance problems that causes hanging on some search operations.
Can I still search based on an index while that index is being updated in the database?
1
vote
0answers
87 views
Oracle ASM failover strategies
I inherited a production system with the following setup:
Disk A, Failgroup AB
Disk B, Failgroup AB
Disk C, Failgroup CD
Disk D, Failgroup CD
Diskgroups AB and CD are configured with normal ...
3
votes
2answers
321 views
Migrating to Oracle Flashback for Historization on Oracle 11g
Our application built using Oracle 11g requires that we keep historic data.
The historization is legally mandated, and is mainly used for manual queries, when investigating problems, etc. Basically ...
1
vote
1answer
262 views
Oracle Client vs Oracle Instant Client on Linux!
to have the following setup on a Linux box:
SQLPlus
client library (oci.dll)!!!!
ORACLE_HOME is set for users
is Oracle Instant Client enough or I need to have the Oracle Client installed on the ...
2
votes
2answers
4k views
ORA-01502: index or partition of such index is in usable state problem
I have a table in my Oracle database, where
select pkcol, count(*) from myTable group by pkcol having count(*) > 1;
yields
PKCOL COUNT(*)
------- ----------
1 2
2 ...
3
votes
1answer
485 views
SOA + Fusion + Weblogic + Oracle 11g - STUCK threads
This is sort of a last-ditch effort. We have Oracle SOA on Fusion, 11.1.1.5.0 (+ patches on a separate server) running, and nearing the point where we're taking it into production. I've posted on ...
2
votes
2answers
3k views
Oracle 11g SYSDBA login
I installed Oracle 11g on my win xp machine. Now I want to connect to the database. I was told that to connect to the database from command prompt I should use
SQLPLUS "/ AS SYSDBA". But I want to ...
6
votes
4answers
11k views
How can I unload Oracle database tables into a csv files?
I need to retrieve certain data from an Oracle 11g release 1 database and provide it as one or more CSV files. The data resides in multiple tables and/or views. All this should work via the command ...
2
votes
1answer
310 views
Alter in PL SQL Loop
I just started learning PL/SQL an hour ago... I'm trying to set profile settings dynamically... I select distinct profile names from dba_users and I'm trying to run an alter profile command for each ...
1
vote
1answer
449 views
How can I change default backup location for oracle11g using RMAN?
I want to change to another drive due to lack of disk space.
How can I change the default location of backup files used by oracle to another drive using RMAN?
By default it's in the folder ...
0
votes
1answer
1k views
Oracle SQL for left outer join to rownum = 1 of another query?
Background
I have a query joining many tables together, the chief of which is a workorder table.
I also have a table called WOStatusHistory, which stores every status for every workorder.
A diagram ...
1
vote
1answer
442 views
How do you monitor specific SQL statement of a specific user ?
We have a few standalone users here which cause high server loads for several 11.1.0.7 Oracle's.
I spoke with them a few times but it seems that their queries are causing high loads and probably ...
4
votes
1answer
786 views
How to use the METHOD_OPT parameter in DBMS_STATS.gather_table_stats
Hi there I was just wondering what would be the difference between these 2 METHOD_OPT parameter settings:
FOR COLUMNS SIZE 5 some_column
and
FOR COLUMNS some_column SIZE 5
both will create a ...
3
votes
1answer
1k views
Oracle11g password expiry issue
I have a user which has a default profile in oracle db.
I want to reproduce the following warning
ERROR:
ORA-28002: the password will expire within X days
In dba_profile I set following values.
...
1
vote
1answer
328 views
In Oracle, what grants do I need as a non-schema user to view rows in all_objects?
I have two instances of an oracle 11g database, both have the same object definitions in the schema: tables with indexes and constraints, a sequence, and a stored procedure.
The facts of the case:
...
4
votes
1answer
908 views
Partitioning a table with LOB columns in Oracle 11g
we have a fairly small table (~25k rows) that is being heavily written to and most of the rows go away quickly (it's part of a scheduling application which stores information about the jobs in that ...
2
votes
1answer
2k views
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
I have a problem with a SPFILE as shown below.How can I get rid of that problem?Any suggestions?
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE ...
5
votes
1answer
369 views
Execution plan using B+ tree index, but also sorts
I'm using Oracle sqlplus. And I have the following query:
SELECT fooID from foo MINUS
SELECT fooID from bar;
I have created two unclustered B+ tree indexes. One in the field fooIDof the table foo ...
