The second and terminal release of Oracle Corporations Oracle 11g database product. 11.2 was released for Linux on September 1st, 2009. New features added include RAC One Node, Improved data compression ratios (up to 20x), Edition Based Redefinition, Recursive Subquery Factoring, Instance Caging, ...
0
votes
1answer
19 views
User with dba privs can't login to APEX, but can from SQL*Plus
I'm using Oracle 11gR2 XE. A user with dba privileges can't log in to the APEX interface, but can from the command line with sqlplus.
I just created user:
CREATE ROLE administrators;
GRANT dba TO ...
0
votes
0answers
22 views
Duplication Oracle Database to remote host
I have two scenarios.
1 ) Let's say , I have the same file system and same SID on both nodes. I've created any directories necessary for start the duplicate database.
First I used command below.
...
2
votes
2answers
89 views
Duplicating a Database with RMAN
I would like to duplicate to the same server Oracle Database with RMAN. I've configured flash recovery area for Oracle Database. My database is using SPFILE as shown below.
SQL> SELECT ...
1
vote
1answer
68 views
NLS_TIMESTAMP_FORMAT changing automatically and randomlly
I am using Oracle 11gR2. My nls_timestamp_format is changing randomly from dd-mon-rr to yyyy/mm/dd.
Does anyone have any clue why this is happening?
0
votes
1answer
31 views
How to purge logs by using Flashback feature in Oracle Database
I’ve configured flash recovery area for Oracle Database. My question is: how can I delete Flashback Database log?or is there any retention policy for that?
2- After I’ve enabled archive log mode and ...
0
votes
1answer
44 views
Efficient way to perform approximated search?
I have to perform a join between table_a and table_b, using three fields as key being one of them the date of the event, say, both tables have id1, id2 and evnt_time for eache record.
As it happens ...
0
votes
3answers
61 views
Exporting schema data (tables, permisions) into another schema on same database
I want to take data from one schema schema1 and put it into schema2 this should be quite easy to do but i have searched through the oracle documentation and can't find a way to do it.
0
votes
1answer
35 views
How to clean up duplicate objects in SYS/SYSTEM
I have a sql query like below to check duplicate objects in SYS/SYSTEM.
select OBJECT_NAME, OBJECT_TYPE from
DBA_OBJECTS where OBJECT_NAME||OBJECT_TYPE
in (select OBJECT_NAME||OBJECT_TYPE from
...
-1
votes
0answers
45 views
Installing Oracle 11g on ubuntu 12.10 [closed]
I am installing Oracle 11g so I can work through practice excerises. I am following the installation walkthrough at link.
In the terminal when I run chown -R oracle:oinstall database
I get Operation ...
0
votes
0answers
40 views
one vs two column index difference when doing JOIN query?
Let`s suppose that alfa,beta and gamma contains milions of rows so we need to create indexes obviously to get optimal performace for this query :
SELECT * FROM alfa
JOIN beta on beta.id = ...
0
votes
1answer
23 views
Dynamic where condition in a stored procedure
I am using Oracle 11g. I am trying to get the table data with this procedure:
CREATE OR REPLACE PROCEDURE test(p_table IN varchar2)
IS
v_sqltxt varchar2(4000);
BEGIN
v_sqltxt:='select count(*) from ...
-9
votes
0answers
43 views
Creating view and traverse [closed]
Creating and traverse by using n Primary Key and n foreign keys and relations? on oracle 11g
1
vote
0answers
37 views
need the most efficient way to handle unique constraint errors
I am looking for the most efficient way to solve this situation:
We are an Oracle shop. I need to load data from one table to another. My source table, which contains 30 million rows, has a person ...
0
votes
2answers
51 views
How to set Proxy Settings when installing Oracle 11g on Windows 7 Ultimate Edition?
I have downloaded the file - "win32_11gR2_database_1of2.zip" from oracle site.
While installing Oracle 11g, I find this window in the first place:
What to do?
What values should I put on the ...
1
vote
1answer
47 views
Delete shared memory segments left over by an Oracle instance
We're using Oracle Enterprise 11rR2 running on Solaris.
How can I delete/remove allocated shared memory segments using ipcrm?
I'm getting this error:
ORA-01041: internal error. hostdef extension ...
