Tagged Questions
-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 ...
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 ...
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;
...
0
votes
3answers
46 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
32 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
...
0
votes
0answers
81 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 ...
0
votes
0answers
115 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
138 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
0answers
39 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
113 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
204 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 ...
4
votes
1answer
950 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
68 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
75 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 ...
4
votes
1answer
95 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 ...
4
votes
1answer
519 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
645 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
90 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 ...
1
vote
1answer
132 views
oracle streams apply: how to get a reason why LCR message was not applied
I've set up bidirectional oracle streams replication (11gR1) using identical scripts on both machines (DB1 and DB2). Although changes from DB1 are being applied to DB2, changes from DB2 to DB1 aren't.
...
2
votes
1answer
97 views
Generating an arithmetic sequence
I would like to generate a named table in a WITH clause which will contain this arithmetic progression:
╔══════════╗
║ mynumber ║
╠══════════╣
║ 0 ║
║ 30 ║
║ 60 ║
║ 90 ║
║ ...
4
votes
3answers
274 views
SQL Server pivot query on Oracle source
I have a SQL Server instance that has a linked server to an Oracle server. There is a table on the Oracle server called PersonOptions which contains the following data:
╔══════════╦══════════╗
║ ...
-2
votes
1answer
62 views
Best indexing for users table [closed]
This scenario occurs so many times (for almost every website) that I thought I would ask here:
What would be best indexing for a users table:
Edit: I think index on email-addresses and username may ...
3
votes
2answers
123 views
Support ticket system - when/how to move old tickets?
I don't have access to the partitioning feature, but consider a support ticket system with tens of thousands of tickets being opened everyday and taking about a week to a couple of months in getting ...
2
votes
1answer
48 views
Transaction stays in capture queue
I set up simple bidirectional db replication using Oracle Streams. I used enterprise manager for this. Streams are active and their status is ok. The problem is that the replication is very slow. What ...
7
votes
1answer
631 views
Why am I NOT getting a mutating table error in trigger?
It's (or at least was) known that you cannot use DML statements on a mutating table inside a trigger. An excerpt from the Oracle documentation:
A mutating table is a table that is being modified ...
2
votes
1answer
560 views
Oracle error “too many values”, must be solved with nested SELECTs
I have hit upon a "too many values" error in Oracle, when working with some intricate nested SELECTs.
A simplified description of my problem, on a toy problem describing the hierarchy in a company. ...
4
votes
2answers
454 views
Hibernate Query Running Slow
I am currently facing a problem with a slow running Hibernate query that is being kicked off from a Java program. It is making a call to Oracle 11g at the back end.
This query is taking anything from ...
0
votes
2answers
1k views
sqlnet.ora or tnsnames.ora changes require reboot?
Anytime you change Oracle's sqlnet.ora or tnsnames.ora files, does the system require a reboot? In my instance, I only have the Oracle client installed on the machine I'm referring to, but out of ...
0
votes
2answers
374 views
Oracle dump import
After a system failure I bought a new server and now I'm trying to recreate the Oracle database I had.
I have a dump file which was made with the command exp and full=y. Can I restore the full ...
9
votes
1answer
385 views
Commit vs Fast Commit vs Commit Cleanout in Oracle Database
I was wondering whether someone could verify my understanding regarding the differences between those 3 terms as pertaining to Oracle Databases.
Many sources confuse these terms and do not explain ...
1
vote
1answer
50 views
Supporting Multiple Oracle Clients
I have an application where the data repository is moving to Oracle 11g. This means we need the new Oracle 11g client on the application server to support the retrieval of their data.
Is it ...
2
votes
1answer
327 views
How do I export data from Oracle 11.1 to 10.1?
I have a 11.1 oracle server and I need to export a dump file for a client who has a 10.1 server.
While reading the documentation, I figured out I needed the 10.1 Export Utility. I searched the ...
0
votes
0answers
68 views
Connecting PCs with APEX
I am working on a Project using APEX.
I want to connect my friend to APEX so we can do work and assign tasks to each other.
Our PCs are connected to the same LAN and I can PING both PCs, however I ...
1
vote
3answers
96 views
Query missing one date; only happened today
This should be pretty reproducible I hope.
I'm on Oracle 11g. This query, which I use as part of another query, is acting strangely:
SELECT TRUNC(SYSDATE - ROWNUM) DATEITEM
...
4
votes
1answer
202 views
How to I interleave logs from two different Oracle tables?
I have two log tables, which are populated from two different PL/SQL packages. It's often useful to keep the data separate, but sometimes I'd like to "interleave" the two tables so I can see what's ...
2
votes
1answer
56 views
Regular Expression Difficulty
I'm trying to extract 456 from the string :123:456: as follows:
select regexp_substr(':123:456:', ':(\d+):', 1, 2, 'i', 1) from dual
However, this query returns null. What am I doing wrong?
1
vote
1answer
123 views
Size of an empty database
Continuing with my school-project, now I have to estimate the size of the database from here to 5 years. They give me a formula, so, in that formula, one of the values is the size of the empty ...
1
vote
1answer
977 views
Oracle.exe (SHAD) process keeps increasing
I have an Oracle Server 11g that we use for integration tests. For some reason, the processes count [select count(*) from v$process;] keeps increasing up to the limit, causing ORA-12514: TNS:listener ...
0
votes
0answers
55 views
Upgrading from Oracle 10 to 11g, what to look for in SQL embedded in code?
We're planning to upgrade our enterprise database to 11g.
We have a number of web applications using it via Weblogic and Hibernate 3.6.5, and both of those support 11g.
There are a number of direct ...
6
votes
3answers
421 views
ALTER SYSTEM DISCONNECT SESSION doesn't work
Oracle 11g. The devs leave sessions connected overnight, sometimes certain cron jobs fail because of that. I am trying to kill all user sessions, but I can't.
I login as:
sqlplus system/[password] ...
1
vote
1answer
607 views
ORA-12541: TNS:no listener using EXPDP
I need to export an Oracle 11g database to an Oracle 10g instance. I have the command, which I believe is correct:
expdp user/pass@192.168.10.8 full=Y VERSION=10.2 directory=m_dump
...
1
vote
2answers
1k views
Troubleshooting Oracle ORA-08103 - object no longer exists
I am getting this error from Oracle intermittently. A trigger is truncating a partition from a partitioned table while a long-running query is running against it.
Since I'm truncating a different ...
1
vote
1answer
193 views
Help with getters & setters in PL/SQL
I am not a db guy, and I have a very beginner's knowledge bout PL/SQL. That being clear now the question:
I have 2 tables one file level & another batch level. In a day, only 1 file_id is ...
1
vote
1answer
306 views
Oracle out-of-place upgrade on same host: impdp issues
I am testing an out-of-place Oracle upgrade from 11.2.0.2 to 11.2.0.3 on the same host. From what I've read, expdp and impdp is the way to go. My problem is that since I am importing to another ...
1
vote
2answers
696 views
Unable to mount oracle instance
I am trying to shutdown the system, then I want to mount it. I have tried this:
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
...
1
vote
1answer
1k views
Oracle server connection reset by peer socket write error
Full disclosure, I'm not a database admin, but if anyone is able to help me, it would be you guys.
Our Oracle 11g database server stopped working, I'm not aware of anything that could have caused it, ...
0
votes
0answers
171 views
How to Import a file to Oracle APEX & what are invalid files to import? [closed]
APEX is running. I tried to import a workspace that I exported in a 4.0 version of APEX
After choosing the file I get this message:
the export file has been imported but is not a valid workspace ...
2
votes
1answer
226 views
How do I connect to Oracle Server without installing Oracle Client on client machines?
I am using Microsoft VB.Net to create a Windows application, and would like some suggestions on how to connect to an Oracle database.
-4
votes
1answer
1k views
primary key, foreign key relationship between the department and employee tables How do I install? (sql_developer) [closed]
EMPLOYEES TABLE
COLUMN NAMES:
EMPLOYEE_ID
EMPLOYEE_NAME
EMPLOYEE_LASTNAME
JOB
EMPLOYEE_BUSINESS_PHONE
EMPLOYEE_GSM
SALARY
HIRE_DATE
E_MAIL
DEPARTMAN_NO
NOTE:FOR THIS TABLE: EMPLOYEE_ID IS PRIMARY ...
2
votes
0answers
1k views
Encoding problems with sqlplus, Linux
I use sqlplus and all non-Latin characters appear as '?' when I run select queries. When I run insert or update queries with non-Latin characters I get question marks on a web page.
select * from ...
