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
1answer
22 views
Using CURSOR in Oracle 11g database to locate all matches for specifed string in DB
As far as I know in Microsoft SQL Server it is possible to use CURSOR to "scan" database and get all tables/entries where specified string is mentioned. Can I do this in Oracle 11g DB? Any ...
0
votes
0answers
18 views
Restoring Oracle DB using RMAN
I am a application developer doing DBA work. I have to restore an oracle database on our test server. The databases are backed up using RMAN and the last db restore that was done on this server was in ...
0
votes
1answer
33 views
Oracle 11g accessing data in Oracle 7
I am working on a project that involves converting production data from an Oracle 7 DB to our system, which use Oracle 11g. In our other projects, we use DB link to access the other system DB, which ...
0
votes
1answer
121 views
What is the Difference between IN and Not IN performance wise?
I am new to database.I am having doubt that what is the difference between IN and NOT IN performance wise.
When I am using IN, takes less time for the same query(Logically same query) when I use NOT ...
0
votes
1answer
26 views
Orace tablespace extension operation
Could somebody clarify whether tablespace expansion procedure in Oracle 11g database requires any downtime or could impact availability of the database? My understanding that this can be done "on the ...
0
votes
2answers
73 views
oracle active sessions waiting for scheduler
Load on my 11g RAC looks like this:
and I don't understand how to get insight into what this "scheduler" wait class is. It seems like "scheduler" that it refers to is the process that runs ...
0
votes
1answer
40 views
How to run procedure in Oracle SQL developer
Hello I have a table named CITY in oracle SQL developer, my problem is how to run the procedure
-- start the script
SET SERVEROUTPUT ON
SET LINESIZE 400
SET TIMING ON
CREATE OR REPLACE PACKAGE BODY ...
0
votes
0answers
28 views
Bad Header Format in Data files ---Repair Data files [duplicate]
I have 1 corrupted Data file in Oracle
Oracle complains "Bad Header Format found" in Alert Log
I can open the DB in Mount Mode
Can U help how I can repair the Datafiles and recover Data
Thanks
0
votes
1answer
42 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
1answer
43 views
ADD Column ON UPDATE TIMESTAMP
I want to alter a table to include modified and created columns. However, I am having trouble with adding the modified column. I get the following error:
SQL Error: ORA-00907: missing right ...
0
votes
0answers
95 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
2answers
78 views
Why can't an owner create a view?
There is a user as HRS. I am creating a view in HRS as
CREATE VIEW HRS.RNS.....
I am getting
ORA-01031: insufficient privileges
Edit
As i remember, i only execute following commands for ...
1
vote
1answer
105 views
Why can't I log in to SYSTEM without AS SYSDBA
When loging in to sqlplus as SYSTEM, why does the login fail with an invalid username/password error if I do not include "AS SYSDBA"
C:\Windows\System32>sqlplus /nolog
SQL*Plus: Release ...
0
votes
0answers
22 views
what privileges are required to run 'GRANT USE ON EDITION'?
We've just started using oracle edition-based redefinition, which is a great feature.
One DB user can run the following command without problems, and another will get ORA-01031:
grant use on edition ...
1
vote
1answer
49 views
Open a Oracle 7.3.x database in Oracle 11
Is there any way to open or convert an old Oracle 7.x database into Oracle 11g?
Thanks in advance!
0
votes
0answers
76 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
1answer
395 views
Oracle alternative edition for Windows Server 2012
Does Oracle 11.2 support Windows Server 2012? Any alternative for Windows Server 2012 with respect to Oracle editions?
I checked in internet but their forums, and this question says its not ...
1
vote
1answer
132 views
Oracle 11g XMLType Experience
We are currently evaluating possibilities to store generic data structures. We found that at least from a functional point of view Oracle XMLType is a good alternative to the good old BLOB. Because ...
2
votes
2answers
888 views
Oracle 11g: LRM-00109 followed by ORA-01078 when using PFILE created by SPFILE
I know this is long, but please bear with me - I think the background info may be important.
OS: Windows Server 2008 R2 64-bit
DB: Oracle 11g 64-bit Enterprise Edition
Yesterday evening we had to ...
0
votes
1answer
473 views
Oracle 11g Enterprise downgrade to Standard One
I'm checking possibilty of downgrade Oracle 11g from Enterpise Edition to Standard One edition. I've cross-checked edition comparison with
select name from dba_feature_usage_statistics where ...
1
vote
2answers
261 views
Oracle's UTL_FILE when connected locally or through listener has different behaviour
We have a procedure which creates a CSV file with UTL_FILE. (env is Oracle 11.2.0.1 and RHEL 6.4)
Until now, we were storing that CSV file into system oracle (the oracle owner) user home ...
0
votes
1answer
55 views
How to see profile assigned to a user
Let's say i have created a user as 'TEST_USER', and then i assigned a profile to it.
Now how can i see for TEST_USER which profile has been assigned?
I want some query that will check what profile a ...
-1
votes
2answers
672 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) ...
0
votes
0answers
225 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 ...
-1
votes
1answer
182 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
vote
2answers
2k views
insufficient privileges while executing oracle stored procedure?
Im getting insufficient privileges error while executing the following oracle stored procedure. Im using Oracle Database 10g Express Edition.
CREATE OR REPLACE
PROCEDURE sp_update_acounts(
...
0
votes
2answers
388 views
ORA-1033: ORACLE initialization or shutdown in progress
I am stuck with a little Oracle problem. My PC was shut down improperly after my graphics card freaked out, which caused Oracle 11g Express to not properly close down. This means that I get the above ...
1
vote
2answers
81 views
Using max for each sub group does not seem to work.
I have a table that looks like this in Oracle 11g:
+----------------------------------------------------------+
| ACCT_NBR | MAIL_TY | ORGA | PERS | RUN_DATE |
...
-1
votes
1answer
60 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: ...
0
votes
0answers
97 views
Use Oracle Wallet without autologin enabled
Question: is it possible to use the Oracle Wallet without enabling auto login in Wallet manager?
Problem I'm facing: When auto login is disabled, the sqlplus call:
sqlplus /@orcl
fails with:
...
1
vote
1answer
60 views
Query for View with unique entries from Database with repeated entries
I have a table with columns of Hotel names, city name and country name (of the respective hotels). I need to create a view of unique entries which will contain city name and country name columns. Any ...
3
votes
2answers
2k views
How to execute this procedure in PL/SQL?
I have this table in the below format:
Persnbr | Userfieldcd | Value
01 | Port | Funds
01 | Vip1 | Systems
02 | Port | Bank
02 | Vip1 | Authority
This is how I want ...
2
votes
1answer
500 views
Replicate or Call java encryption function in Oracle pl/sql
I am trying to replicate encryption/decryption method present in java in Oracle DB, so that data encrypted in java can be decrypted through Oracle Function.
Below is java code:
package com.encr;
...
2
votes
2answers
129 views
how to make a particular field into seperate columns?
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production.
I have this table in the below format:
No | User | Value
01 | Port | Funds
01 | Vip1 | Systems
02 | Port | Bank ...
0
votes
2answers
2k views
Oracle Enterprise Manager Database Console - default login and password?
I've just installed an Oracle 11g Standard Edition Database. It ran successfully and everything, however when going to Oracle Enterprise Manager Im not really sure what my "username" would be.
I ...
0
votes
2answers
757 views
ORA-04031: unable to allocate 4708660 bytes of shared memory
I am running Oracle 11g R1 on my local development machine.
I have been trying to run an anonymous block to test the FORALL statement in Oracle to insert 25,000 records.
I get the following error:
...
0
votes
1answer
62 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 ...
3
votes
1answer
199 views
Negative number of rows inserted
I just ran a rather simple insert statement (that I think processed alot of rows), and I got the message: "-1,311,750,183 rows inserted". Should I be concerned about the fact that it's negative?
2
votes
0answers
168 views
Oracle 11g bug ? not returning the record until I triggered index to invisible and then to visible
We are using Oracle 11g, 11.2.0.3.
We know a record exists in a table but a select is not returning it for some odd reason.
The execution plans the general query, not forcing any index, shows that ...
0
votes
0answers
36 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 ...
3
votes
2answers
118 views
Can I grant privileges to a role without specifying an object?
I am trying to create a role to simplify granting a set of privileges that I often give to users. I am wondering if there is any way to grant these privileges on only the objects owned by their schema ...
0
votes
1answer
121 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
30 views
Oracle: Lost significant part of foreign-keys
I wonder how it's possible to lose in database about 80% of foreign keys?
We had development and test databases in parallel.
Now I have found that diff of the schemas shows that FK's are not there. ...
2
votes
1answer
373 views
Why do shadow processes exist?
Oracle architecture has two types of process: server process or foreground process and background process, but:
Some people use it to refer to foreground processes, others use it
for background ...
1
vote
1answer
133 views
What signals do the DBWn processes send to LGWR?
I would really like to know what signals are in the following quote from the Process Architecture docs, and how does DBWn know LGWR has completed?
Before DBWn can write a modified buffer, all redo ...
2
votes
1answer
207 views
Does SQL Server have a reference partitioning equivalent?
Oracle 11g has introduced a new feature that is called Reference Partition.
Using reference partitioning, a child table can inherit the partitioning characteristics from a parent table.
...
2
votes
0answers
277 views
Insert into table from a query to a linked database hangs
I have a schema with some database links to other schemas that we use to pull data from. We pull the data into a staging table, massage it, and then do some merges into our schema/database.
The data ...
1
vote
1answer
204 views
USER_ID field in alert logs (also in V$DIAG_ALERT_EXT view)
Does anyone know what triggers the USER_ID field in the log.xml to be populated? The value also exists in the V$DIAG_ALERT_EXT view.
I've found by observing the logs that if a temp tablespace fills ...
0
votes
3answers
78 views
How to manage constants within an Oracle Database
This question touches on a few different parts of Oracle that I'm not particularly familiar with so bear with me:
I am trying to redesign some of the procedures and functions within the database I ...
-2
votes
1answer
492 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 ...
