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) ...
-2
votes
0answers
24 views
Creating a server on client machine [closed]
I'm trying to learn SQL and this post is regarding two questions.
I know that MySQL is already installed on my machine (OS X 10.8) and I've seen the command line, but I'm not quite sure how to set ...
1
vote
1answer
23 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
15 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 ...
0
votes
0answers
33 views
How do you take export dump files on Oracle 7.3 running 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@[hostname] FULL=Y LOG=EXPORT.LOG
Did ...
1
vote
1answer
24 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
33 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
18 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
34 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 ...
0
votes
0answers
20 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
16 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
25 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
43 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
27 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
63 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
39 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
53 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
1answer
52 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
26 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
26 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
17 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
49 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
43 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
29 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
42 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
53 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
40 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
19 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
25 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
72 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
54 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
68 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
48 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
55 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
78 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
3answers
49 views
Should I use two databases or two schemas?
We are currently having one Oracle instance on RAC with one database created. A new requirement came to our database team to temporarily (1-2 months) host a new application that is independent of ...
0
votes
1answer
21 views
Enable Oracle Database options in an existing database
I want to enable Oracle Real Application Testing option in my existing database, but I couldn't find the way to do that using Oracle Universal Installer (OUI) or Database Configuration Assistant ...
0
votes
1answer
27 views
How to load .dbf to run select queries?
I had asked for database(Oracle 11g) back-up files (for a particular date)from a third party vendor. The files I received were with the following extensions : .dbf , .svd , .arc , .ctl (PFA ...
-1
votes
1answer
49 views
populate table header and data in another table column [closed]
I have 2 tables: Departments and Employees, where Department_Id is primary key in the departments table and a foreign key in Employees table.
Departments Table:
Department_Id Department_Name
10 ...
2
votes
1answer
117 views
Oracle UPDATE followed by SELECT in LinqPad
I'm trying to UPDATE values in an Oracle database table (of salary information) that has no row IDs or a primary key. I'm writing these statements in LinqPad.
This syntax should work just fine in ...
1
vote
3answers
41 views
Oracle TNS names configuration
I've edited added new TNS name to tnsnames.ora.
Toad for Oracle started to work at once. SQL Plus doesn't work even after logoff/logon, the same problem with my build scripts.
Getting the error: ...
1
vote
1answer
60 views
Accessing the insert statement which triggers a trigger inside the trigger's body
I have some table and I have enabled auditing on this table. Currently, I am collecting the data about who has inserted records and at what time. Now I also want to log what was the exact query he/she ...
0
votes
0answers
45 views
What are the host credentials for Enterprise Manager 11g?
I am trying to use Database Replay in 11g Release 1 using Enterprise Manager. In the last step it asks for 'Host Credentials' to start the capture. But when I give the username and password for the ...
0
votes
0answers
51 views
How to clone a database from one environment to a database on another environment?
OS: RHEL
DB: Oracle 11g version 11.1.0.7.0
I am trying to clone a database on one environment (environment A) to another database on a separate environment (Environment B). Environment B's database ...
0
votes
0answers
32 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;
...
