Oracle is a RDBMS (Relational Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java. Also included is support for C (Pro*C, OCI and EXTPROC), C++ (OCCI) and Java (JDBC) ...
0
votes
0answers
5 views
How to embed a sub-prodecure call in a SELECT statement in an Oracle 11g PL/SQL stored procedure
I need to figure out a way to embed an Oracle PL/SQL sub-procedure call in a SELECT statement, within another procedure in the same package.
I am using SQLDeveloper 3.0 with an Oracle 11g database. ...
0
votes
1answer
24 views
Oracle database link via ODBC to SQL Server does not recover automatically
I have a test environment with an Oracle 10XE database which is linked to an SQL-Server 2005 via an ODBC data source. For reference here I named the connection MSSQL_LINK. The production environment ...
0
votes
2answers
29 views
Restore Oracle tablespace to 2 days before
I have multiple test tablespaces in an Oracle SID. One of the tablespace is updated with wrong data. It works fine 2 days before. I want to restore the tablespace to 2 days before.
Can anyone ...
1
vote
3answers
59 views
Shell: How to time a script running in SQLPlus and kill it after x amount of minutes?
I have a little tool which automatically runs a series of SQL scripts when and outputs to .XLS when an appropriate request is made. However, some SQL scripts need to be ran on a live database, and I ...
1
vote
1answer
24 views
Exadata exachk.sh
I would like to run exachk.sh on regular basis.
Now I have to interact with the script and answer all kinds of password questions before the script starts to extract Exadata information.
I want to ...
-6
votes
0answers
28 views
How do I create a database+tablespace+user in Oracle 11gR2? 1 [closed]
I keep getting database not open error whenever I try committing anything with the user \ as sysdba how do I get started, create a table, create a tablespace and a user?
0
votes
0answers
25 views
I want to change ORACLE level#2 to log archiving mode instead of the current mode
I want to make that change to the archive log mode to use the redo log files to use it to make replication to database to another server.
This is easy and possible when the server is single not ...
0
votes
1answer
19 views
Unable to connect to Amazon RDS instance
I recently created an oracle instance on Amazon RDS. Unfortunately, I'm not able to connect to the instance using Oracle SQL Developer.
The (relevant) information I have from Amazon;
Endpoint - The ...
1
vote
2answers
54 views
how to change a user password while checking the current password in oracle?
In my application i have a change password form which users enter their current password and the new password. then i change their password using the following command:
alter user user_name ...
0
votes
2answers
30 views
Communication between two database servers
I have 2 databases running on different virtual servers. I have some database processes running on one node. These processes connect to Database Gateway (PG4MQ) and process the messages.
I need to ...
1
vote
1answer
31 views
Is shrink a safe online operation?
We are planning to run the following space management command:
alter table XXX shrink space cascade
on a production database (Oracle 10g). The XXX table is a transactional table heavily used for ...
0
votes
0answers
26 views
Longest prefix search in Oracle
I have a list of phone number prefixes defined for large number of zones (in query defined by gvcode and cgi).
I need to efficiently find a longest prefix that matches given number PHONE_NR.
I use ...
1
vote
0answers
59 views
Exporting database Oracle 7.3 on Windows NT 3.51
How to take dump files on Oracle7.3 running on Windows NT 3.51?
Should you stand in the Orant/bin folder and run one of the programs there like>
exp73 SYSTEM/password@[dbinstance] FULL=Y ...
1
vote
1answer
28 views
Is it possible to define package procedure/function outsize of package body block (for Oracle)?
Is it possible to define package procedure/function outsize of package body block (for Oracle)?
Simplified syntax for defining package body is:
create or replace package body <package_name> IS
...
1
vote
1answer
38 views
Role audit in Oracle 10g
Is it possible with Oracle auditing to find out if the role can be revoked from particular user without loosing any privileges that he actually uses?
Something like AUDIT webadmin_role BY webapp_user ...
-1
votes
0answers
24 views
script to startup oracle database [closed]
I found out below script that helps me to start up a Oracle database:
set serveroutput on;
WHENEVER SQLERROR EXIT SQL.SQLCODE
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "MY_DB" NORESETLOGS ...
1
vote
0answers
19 views
BLOB storage in rows
I have a database that has several BLOB columns scattered across multiple tables. Since I am a developer and am looking at making application code writing easier, I wanted to turn these columns into ...
-1
votes
0answers
39 views
Bulk inserts in Oracle 11g SCAN cluster environment
A Large Volume of Data from a table need to populated into another table this is taking a very long time Using SQL Developer on an Oracle 11g SCAN Cluster Environment. We experience Connection ...
1
vote
1answer
34 views
where is oracle session timezone set?
I have a logging table
CREATE TABLE EMAIL_LOGGING
(
ID NUMBER(9) NOT NULL,
SEND_DATE TIMESTAMP(6) DEFAULT LOCALTIMESTAMP NOT NULL,
...
0
votes
1answer
23 views
How to automate Oracle DB installation (like a 'hands-free' install)?
I installed the Oracle 11g2 'standard' edition using the following zip-files:
linux.x64_11gR2_database_1of2.zip
linux.x64_11gR2_database_2of2.zip
I used the installation guide by Oracle which I ...
0
votes
1answer
26 views
Filter on a window function without writing an outer SELECT statement
Since window functions cannot be included in the WHERE clause of the inner SELECT, is there another method that could be used to write this query without the outer SELECT statement? I'm using Oracle. ...
0
votes
2answers
51 views
How to forcibly flush the undo log/tablespace of UNDOTBS1
I'm looking for a way to flush the undo logs so that the UNDOTBS1 doesn't give me an error saying that my tablespace isn't large enough. I tried using a commit, but without success, it still gives me ...
-1
votes
0answers
29 views
How to correct my Oracle SYSTIMESTAMP?
My database's timestamp has 8 second difference with my OS system time (as well as time from the internet). This caused some bug in my code. How to correct this?
0
votes
2answers
72 views
How to quickly startup/shutdown Oracle 11?
I am wondering what is the quickest way to properly startup/shutdown a Oracle DB daemon (Oracle 11.2, installed on a test machine).
I need it for C/C++ programs that use the OCI/Pro*C API.
Currently ...
0
votes
0answers
20 views
Oracle Grid Control
How can I implement all the mentioned below points for monitoring in Oracle Grid Control?
Datasource Monitoring
JMS Monitoring
Composites (State (Stop/Retired/Undeployed)
Physical servers (Virtual ...
-4
votes
1answer
40 views
Oracle database and data has been corrupted. Is there a way to get it back? [closed]
The Oracle database has been corrupted and both the data and backups were lost in the corruption. Is there anything I can do to recover my data? It would be terrible if it were all lost.
1
vote
2answers
55 views
Need an Oracle query to get the Oracle Home directory for a particular instance
I am searching for a query to get the Oracle Home for a particular instance name, say Eagle (if there are more than one instance on the host).
0
votes
0answers
37 views
Oracle 11gR2 DBCA installation failing with TNS Lost contact
I am getting below errors while running DBCA with silent install using response file
ORA-12547: TNS:lost contact
PRCR-1079 : Failed to start resource ora.ocl.db
It's a fresh installation and not ...
0
votes
1answer
53 views
Creating oracle database physical files from migrated DB
I migrated a database from SQL Server to Oracle 11g and there doesn't seem to be any physical files created after migration.
The client requires that they receive a copy of the database so they can ...
1
vote
0answers
37 views
Is it possible to use 'restore UNTIL SCN' with rman and Oracle 9i in NOCATALOG mode?
I'm trying to do a hot backup with rman that I can copy to a USB drive so I can recover it on a new server.
The backup was done two days ago and the restore database command was working on the same ...
2
votes
1answer
18 views
can rman backup a subset of a table
I have been asked to make incremental backups of a table based on the value of one of the fields in the table (called groupid). They want a separate incremental backup for groupid=1, groupid=2, ...
-2
votes
0answers
27 views
Connecting To Oracle with D2K & PHP [closed]
I've D2K installed on Windows XP [client] and Oracle 9i on the server. How to connect to the database using PHP ? Installing Oracle on the client is not an option !
1
vote
1answer
19 views
Finding oracle physical database files
I'm using oracle 11g and I need to find the database files to copied to another server. The database was created from migrating from SQL Server 2008 to 11g. There doesn't seem to be a counterpart for ...
-2
votes
1answer
55 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 ...
-1
votes
1answer
44 views
Adding a column at a specific position using DBMS_REDEFINITION
Can anybody tell me how I can add a column to table at a specific position using the DBMS_REDEFINITION package from Oracle?
1
vote
1answer
32 views
Appending data from one program to the other using batch commands
I have a database which sometimes crashes. I want to create a batch program that does this:
Runs SQL*Plus.
Makes SQL*Plus run a script from a plain text file.
Gets the results back to the main batch ...
-5
votes
0answers
45 views
Query for Oracle database [closed]
I have a problem in writing a Database Query
Problem: I have the below fields in my table Fields: Primary_ID(PK) ,E_ID, Bank, REQUEST_STATUS, START_DATE, STATUS
Data: REQUEST_STATUS may contains ...
-4
votes
0answers
42 views
oracle database query [closed]
I have a problem in writing a Database Query
Problem: I have the below fields in my table Fields: Primary_ID(PK) ,E_ID, Bank, REQUEST_STATUS, START_DATE, STATUS
Data: REQUEST_STATUS may contains ...
0
votes
1answer
52 views
Oracle 11g install on Debian Wheezy does not start
I successfully installed Oracle 11g R2 on my laptop for evaluation, by mixing various sources of documentation. I saw the Oracle daemons after installation.
But I have a few problems :
After a ...
1
vote
1answer
41 views
Data Migration from Oracle to SQL Server [duplicate]
If you need to do a data migration from an Oracle database to SQL server, what approaches and technical solutions are the best practice?
Our database has about 100 million rows and a total of 52 ...
5
votes
1answer
54 views
Sudden increase in log_file_sync waits
I'm on Oracle 11gR2 with a 2 node RAC system. It's shared fiber storage to an EMC Clariion.
Last friday things went bad..fast. All of the sudden processes that normally ran fine for years became ...
2
votes
2answers
43 views
Understanding oracle SCN
I am currently working as junior Oracle DBA in a company.Now my team leads always tell me that I have to understand how SCN works and what I can do with the knowledge about SCN.So,are they really ...
0
votes
1answer
20 views
Oracle DB 11gR2 netca installation failing
I am getting below error when I run netca from command line
cmd: /u01/app/oracle/product/11.2.0/db_1/bin/netca /silent /responsefile=/oracle_binaries/database/response/netca.rsp
[main] [ 2013-05-17 ...
0
votes
2answers
27 views
copy package from schema B to schema C
I am in the next situation: I am using oracle 11g. I am connected to an user, lets say schema1, where are a lot of permissions. I want to create a script which will copy the Package1 (and its body) ...
3
votes
1answer
75 views
How do DELETE / TRUNCATE affect table / tablespace?
I am piggybacking off of this question, but asking it from the Oracle perspective.
Specifically, how does a DELETE/TRUNCATE affect the size of the table and/or tablespace?
1
vote
0answers
55 views
Performance Hit when upgrading to Oracle 11gr2
I am experiencing the same symptoms as noted in this question which was closed and does not have a satisfactory answer.
Original Question
We've recently upgraded from Oracle 10gR2 (10.2.0.4 ) to ...
0
votes
2answers
72 views
Use an Alias in Where Clause Subquery
I need to show some fields from another table in Oracle. Here is my query:
SELECT
ANGGARAN.SIMPEG_PEGAWAI.ID_PEGAWAI AS KODE,
ANGGARAN.SIMPEG_PEGAWAI.NAMA,
ANGGARAN.SIMPEG_PEGAWAI.NIP,
...
7
votes
3answers
49 views
Tablespace on ephemeral storage
For performance reasons in some scenarios, e.g. Amazon EC2, you have access to a faster and cheaper storage device, which loses all its data on reboots, so it is called "ephemeral".
This question is ...
0
votes
0answers
62 views
PL/SQL extremely slow FETCH performance
I have a stored procedure that includes (among many other things) a dynamic query with a LOOP and a FETCH. The fetch has to potential retrieve a large amount of data as one column contains spatial ...
0
votes
1answer
82 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 ...
