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
0answers
29 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
48 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
38 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
27 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
28 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
106 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
48 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
85 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 ...
-1
votes
2answers
115 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
159 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
36 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
88 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
50 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
26 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
59 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
71 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
28 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
136 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
97 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
91 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
114 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 ...
0
votes
1answer
62 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
64 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
246 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 ...
0
votes
1answer
142 views
What's the most effective way to back-up / save data on Oracle 11g large data sets?
We have a database(actually more databases split by primary access path, modulo on a key.) with millions of records (about 400 millions ). Right now I need to save a specific table userData(which has ...
1
vote
1answer
216 views
Passing parameters to a procedure executed by DBMS_SCHEDULER
I have a scheduler program that runs a stored procedure that requires input parameters.
BEGIN
DBMS_SCHEDULER.DROP_PROGRAM
(program_name => 'MYSCHEMA.EXPORT_SCHEMA_STARTING');
END;
...
0
votes
3answers
75 views
Built-in XML functions
I am trying to use built-in XML functions, but I'm getting an %s: invalid identifier error. Selects works fine without the XML functions.
Any ideas where is the mistake?
select id,full_name from ...
0
votes
1answer
49 views
using row data for column headers
I have a table
CREATE TABLE "AUTOMATION"."TESTRESULTS"
(
"BUILDNUMBER" VARCHAR2(30 BYTE),
"TESTNAME" VARCHAR2(100 BYTE),
"STATUS" VARCHAR2(100 BYTE)
)
sample data would be
...
1
vote
1answer
96 views
Why we need auxiliary instance in TSPITR
Need help!
I've read Database Backup and Recovery User's Guide 11g but I can't uderstand why we need auxiliary instance to perform tspitr.
We can do complete recovery of tablespace within same ...
0
votes
0answers
136 views
pl/sql developer show errors with arabic letter
I have pl/sql on my PC but when an error occurred while I write an incorrect sql query the oracle error message show with Arabic letter as below
ORA-00936:???? ????? ??????
I am using oracle-client ...
1
vote
1answer
476 views
grant execute on utl_file to user in Oracle 11g XE
sqlplus connect <sys>/<pwd>
grant execute on utl_file to <user>
connect <user>/<pwd>
DESC utl_file
then i get:
ORA-24372: invalid object for describe
How can I access ...
0
votes
1answer
267 views
Error AWR Operation failed: CATPROC not valid when creating database with dbca
I have a fresh installation of Oracle 11g enterprise edition on CentOS 6, both 64 bits. I have installed Oracle and so far everything looks fine. I have already added an started a listener. The ...
1
vote
0answers
274 views
Registry error while trying to install Oracle 11g on Win 2008 R2
I am new to Oracle and trying to install Oracle database 11g Enterprise Edition on Windows 2008 Server R2 but getting this error all the time...
It gives me error when updating registry key ...
0
votes
1answer
104 views
extproc env variables oracle 11g
I have oracle 11g with extproc separately configured in listener.ora.
Users report some environmental variables that should be exported are not set.
From where does extproc gets it environment ...
0
votes
0answers
57 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 ...
1
vote
1answer
216 views
Oracle Forms 10g to 11g migration Error
I having problems from first steps, while migrating Oracle Forms from 10g to 11g. Some of libraries dose not want to compile. the compiler just hangs up when I try to compile them, and Forms builder ...
2
votes
1answer
267 views
Update oracle sql database from CSV
I tried google at first but no luck.
Is it possible to update tables from csv file?
I am using SQL developer and I am using a script to export edited rows to a csv file. I would like to update the ...
4
votes
3answers
559 views
Unable to start Oracle (11g1) due to bad memory configuration (ORA-00837)
I decided to reduce the memory allocation of a local developer instance, and was told that the following command did the job;
alter system set memory_max_target = 512M scope = spfile;
Which I guess ...
2
votes
1answer
418 views
unique constraint violated (ORA-00001) in concurrent insert [closed]
I have a procedure that is called from concurrent transactions:
//Some actions here
INSERT INTO table1
(table1_id, table1_val1, table1_val2, table1_val3)
VALUES
...
4
votes
1answer
3k views
Oracle 11g listener fails with ORA-12514 and ORA-12505 errors
I run an instance of Oracle 11g locally on my development machine and can connect to the local instance directly via SqlPlus:
c:\>sqlplus ace
SQL*Plus: Release 11.2.0.2.0 Production on Mon Mar ...
2
votes
1answer
120 views
Fast paginated result, for various filter clauses
I have been working on obtaining a paginated result from a table in my database (11g). While I have a query that does work (ie, the result is correct) it does not perform as well as I'd like to and I ...
1
vote
1answer
125 views
Unable to start Oracle Database Server : Get an error as I try to start it
I just installed Oracle Database Express Edition 11g Release 2 for windows.It created a short cut icon on the desktop :
but as I click this icon I see this dialog box :
What is it ? How do I ...
5
votes
1answer
124 views
Designing Simple Schema for Disaggregation of Demand Forecast
I am doing a simple database design task as a training exercise where I have to come up with a basic schema design for the following case:
I have a parent-child hierarchy of products (example, Raw ...
1
vote
1answer
328 views
Oracle 11G Can't create database from template
I am attempting to create a new database from an existing template in Oracle 11G.
I have done this before using dbca and haven't had a problem, but now I am hitting the following error:
TNS-04404: no ...
4
votes
1answer
2k views
temporary table inside procedure oracle
I'm in a situation right now. I'm migrating several procedures from Mysql 5.0 to Oracle 11g.
Mysql procedures allow me to:
1. Create temporary tables
2. Insert data into temporary tables / Query these ...
0
votes
1answer
2k views
How and when to use sys_refcursor in oracle
Can some one give me a small explanation about how and when should someone use sys_refcursor ?
3
votes
1answer
115 views
Use a Context namespace in a multi-tenant database?
I'm developing an Apex application that uses database Contexts in conjunction with Row Level Security. I'd like to install a second copy of the schema and workspace on the same instance; this works ...
0
votes
0answers
96 views
Renaming the system generated partitions during interval partitioning
I am trying to rename the system genrated 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 ...
2
votes
1answer
153 views
Invalid File Name on login to SQLPLUS
The moment I log into SQLPLUS I get an SP2-0556 error. I recently moved OS but am connecting to the same database so I am not sure if it's because I'm using my old TNSNames or what. I can connect and ...
1
vote
0answers
154 views
PeopleSoft or Oracle App Designer Tool Alternative
We are using PeopleSoft app designer tool to manage and create projects, database objects - tables, columns, views etc in Oracle database. This tool has limitation that we cannot create tables/columns ...
