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.

learn more… | top users | synonyms

0
votes
0answers
24 views

Oracle XE 11g (ORA-12514: TNS:listener does not currently know of service requested in connect descriptor ) [duplicate]

I have already seen the questioned in the stack overflow that might relate to my problem but let me emphasize that none of them could resolve my issue. issue is: when I wanted to integrate OWASP ...
0
votes
0answers
90 views

Oracle AQ Message Replication

We are upgrading our infrastructure and for that we are migrating from Oracle 10g to 11g. We are using Oracle GoldenGate for data replication and it does not support replication of AQ messages as far ...
0
votes
1answer
86 views

EMStagePatches_$ORACLE_SID is using up space

We have this directory: $ORACLE_HOME/EMStagePatches_$ORACLE_SID We are running out of space and this directory is using up a lot of space. Is it safe to delete it? I think it is something to do ...
0
votes
2answers
630 views

Changes in Oracle Database implicit conversion rules for select statement

Due to hardware failure after a power outage we had to recreate the database for one of our 3rd party applications from an dumpfile (created via exp). The old hardware had Oracle 10G R2 running while ...
0
votes
0answers
777 views

Oracle EXP Error ORA-12704: character set mismatch

I need to duplicate a Oracle 11g Express Edition database from one computer to another computer. I tried exp sys/password FULL=Y FILE=backup.dump (the idea is to do a imp on the other pc) But it ...
0
votes
0answers
433 views

Alternatives for UPDATE statement Oracle 11g

I'm currently using Oracle 11g and let's say I have a table with the following columns (more or less) Table1 ID varchar(64) Status int(1) Transaction_date date tons of other columns And this ...
0
votes
0answers
1k views

How to concatenate multi row sql output

Version Information: Oracle Database 11g Release 11.1.0.7.0 - 64bit Production HP Server Automation v9.14 I am creating a report of all my HP-SA managed servers. The report includes data from ...
0
votes
1answer
143 views

Where is my blob stored?

Using oracle 11, Although a lot was already written about blobs, there is something that is not still clear for me. I was told that by default blobs stored in row if the are < 3900. Does it ...
0
votes
0answers
51 views

Any recommendation on tuning following query

My query has lot of select statements and unions. I think it is querying database multiple times and combining data. Is there a way we can eliminate multiple passes to the database? I would like to ...
0
votes
1answer
235 views

Error while opening Oracle 11g Database

I have a problem with oracle 11g database, I have shutdown my computer this morning normally, but in the evening when I tried to connect to my database I fond a problem. I cannot connect as normal ...
0
votes
0answers
286 views

No network ACL, yet my user can successfully connect to external server

This one's had both me and our dba scratching our heads. We have an Oracle 11.1.0.7.0 instance, DEV, with a user who can successfully connect to our ldap server, e.g.: DECLARE l_session ...
0
votes
0answers
250 views

Renaming the system generated partitions during interval partitioning

I am trying to rename the system-generated partition names (generated during interval partitioning). I try to do this while my table is live(data read and write is happening). I need two scripts. I ...
0
votes
1answer
79 views

What is contained in the controlfile of oracle database?

As we all know that controlfile contains datafile locations and redo log locations along with their names.It also contains dbname,timestamp,checkpoint info,log sequence number,rman backup info.In ...
0
votes
3answers
533 views

Delete all the data from all tables

I have a little problem. I have to delete all the data from our database. I don't want to drop tables, only delete the data sets. These are 47 tables in total. I tried the following: Delete ...
-1
votes
1answer
2k views

Commit and rollback in Oracle stored procedure

In my Oracle stored procedure, I have multiple insert and update statements like below: create or replace PROCEDURE SPTest AS BEGIN insert into emptest(empid,empname,deptno) (1,'ravi',10); ...
-1
votes
2answers
4k views

How do I determine the licensing cost of Oracle Standard Edition for HyperV instances? [closed]

I'm confused by Oracle's licensing for their Standard Edition. My understanding is that licensing for the Standard Edition is determined by the number or physical processors (actual chips, not cores) ...
-1
votes
1answer
103 views

Problems working with decode function when there is more then one expression

I am using Oracle 11g. I have these two tables: Table acct: acctnbr || Name || Mailing address 000001 || Slater || 000002 || Baker || Alt 000003 || Parke || Table addruse: ...
-1
votes
1answer
683 views

Importing only one user data from a Dump file

I am using oracle 11gr1 SingleByte Database, I am trying to import a Dump file. but strangely the dump file contains multiple user objects(i.e, Import(IMPDP) is not done properly). example: . . ...
-1
votes
1answer
1k views

difference between oracle 11.2.0.1 to 11.2.0.2

In my environment Oracle 11g version 11.2.0.1 was installed and it was working ok. Now I am considering upgrading to version 11.2.0.2. What is the main difference between 11.2.0.1 and 11.2.0.2.
-1
votes
1answer
31 views

sequence id in oracle

I am using Oracle 11g. I have a senario like: I need to increase auto increment id like below 00000001 00000002 00000003 00000004 For example, my table looks like below id empid name ...
-1
votes
1answer
3k views

error:ORA-01008: not all variables bound

I created a bus table and when I try to insert values in the table like: insert into bus values(&bus_no,&source, etc.,); I get an error: ORA-01008 not all variables bound
-2
votes
1answer
53 views

Moving from Oracle 11.2.0.1 to 11.2.0.3

We are going to upgrade our database soon from Oracle 11.2.0.1 to 11.2.0.3 We have our customer relation application that runs on the Oracle background. Both Oracle and the company that designed the ...
-2
votes
2answers
33 views

creating tablespace failed!

I've restored a db and its failed with many errors. When I look into the log file, I found that the tablespace does not exist. So when I try to create a tablespace in plsql am getting the following ...
-2
votes
1answer
2k views

what's the fastest method to export a table through sql query ? 11g - performance

I'm connected to the oracle server remotely. I need to export a table data(the whole table) with millions of records but due the hosting restrictions I can only use SQL (no exp , expdp) . Therefore ...
-4
votes
1answer
5k 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 ...