Oracle Corporations version 10 of its flagship RDBMS product.
2
votes
3answers
215 views
What is the simplest way of excluding the current row from the result of an analytic?
I want to do something like the following:
with w as ( select level as foo,
decode(level,8,1,mod(level,4))*100 as bar
from dual connect by level<9 )
select foo, ...
2
votes
2answers
606 views
Oracle 10g XE GUI
I've designed a database on Oracle 10g xe (Windows Platform) and I want to export the tables I created in a sql file. I've googled all night and didn't find anything. I also tried to install a Windows ...
2
votes
2answers
992 views
Generate sample data for an Oracle database [closed]
Good morning,
What free [or trial] software can I use to generate sample data for an Oracle database?
I've been trying with various tools, but none work.
Thanks for all suggestions,
Alec Taylor
2
votes
2answers
2k views
How to debug “IO Error: End of TNS data channel” errors?
I am seeing sporadic reports of an application failing certain queries with an "End of TNS data channel" error from the Oracle (10g) server. Are there any queries I can run (e.g., with SQL*Plus or ...
2
votes
2answers
22 views
Oracle error : Shutdown immediate error
echo $ORACLE_SID
YBRD
conn sys/hello as sysdba
SQL>shutdown immediate
Then I was waiting for it to shutdown for a couple of minutes. It didn't, so I closed my window.
Then I again logged in and ...
2
votes
1answer
48 views
Oracle Database: View schema without access to data
In Oracle Database 10g, I need to create a user with these permissions:
user can access schema to be able to read table names and columns
user can not select (get) any data from any table
Is this ...
2
votes
1answer
911 views
How do we free up disk space from allocated namespace? / ORA-03297
We are running out of disk space.
The server has a 420 GB HDD, and runs a Microsoft SQL Server and an Oracle Server(10g).
The Oracle server uses up to 315 GB space. We have just loaded a 100GB ...
2
votes
1answer
133 views
Oracle function based index is not used in query
I cannot figure out why the following is not working as I expect it :
CREATE TABLE table1(table1_id INT NOT NULL PRIMARY KEY,
col1 INT NOT NULL,
val1 VARCHAR(50));
CREATE INDEX ...
2
votes
1answer
1k views
Oracle Create Materialized View Script - Takes 12 minutes in DEV Schema, 5+ days in QA Schema
I have a materialized view in my Oracle 10g database that I need to rebuild. So I'm doing something like this...
drop materialized view ViewName;
CREATE MATERIALIZED VIEW ViewName
NOCACHE
LOGGING
...
2
votes
2answers
455 views
Encountering exception ORA-01555
I was given a problem to solve , in which there is table called Scenarios in the Master Db which contains the details of all the Tablespace for which I have to find the size. The O/P should contain ...
2
votes
2answers
4k views
Execute PL/SQL script block in C#
I am trying to execute a PL/Sql block by using the OracleClientProvider in .Net . The language I am using is c#, the DB is oracle10g
What I am actually doing is the following :
//ConnectionSting ...
2
votes
1answer
215 views
Recompiling dependent objects in Oracle
I wonder what is the best practice to recompile Oracle 10g programmable objects that become invalid due to changes in one of them.
To be more specific, I have a few packages, that use schema level ...
2
votes
2answers
610 views
How does name resolution work in Oracle 10g?
In Oracle 10g (10.2.0), there are 4 types of names resolution:
Easy Connect(10g added this new method)
Local naming
Directory
External naming
It is said that if Easy connect is used by the ...
2
votes
1answer
555 views
Oracle imp crashes without error
I have Oracle 10g XE database locally. I export schema with something like
exp %USER%/%PASSWD%@XE statistics=NONE owner=%USER% file=dump.dmp
Exp is 10.2.0.1.0 version - so is the DB.
Than I take ...
2
votes
1answer
360 views
Oracle Database Block Size
One of our Production database has a rather peculiar block size of 16KB. This database was created about 2 years ago and at that time the size of the db was approx 1TB only.However over the past 2 ...
2
votes
2answers
830 views
Return many rows on a plsql Oracle10g
I'm doing a little project and I need to do a plsql to return many rows.
I have someting like:
Table(id, data1, data2, from)
And the user gives me the value of from and I have to return all that.
...
2
votes
1answer
4k views
SQL Developer cannot connect to Oracle database, yet sqlplus can!
I am having a problem connecting sql developer to my Oracle 10g database. sqlplus is able to connect fine, but when I try to open the connection in sql developer, I get 'ORA-12514 TNS does not know ...
2
votes
1answer
129 views
Is it possible to automate the configuration of dataguard broker?
We deploy a number of oracle databases every year and a good percentage of them require a dataguard configuration.
I've developed a script which is able to perform the database synchronization very ...
2
votes
1answer
11k views
oracle: No more data to read from socket
We are using Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 and we have an error on a query that gives us the error
Error: No more data to read from socket
SQLState: null
ErrorCode: ...
2
votes
2answers
220 views
Recreate indexes and constraint when redefining table with DBMS_REDEFINITON
I have a table A witht the following characteristics:
multiple indexes
constraints (null, unique, check, foreign key)
2 triggers (before update)
primary key
If I were to redefine the table with ...
2
votes
1answer
186 views
Oracle 10g using collection with sql
I have a stored procedure that takes collection of objects. (TABLE OF MyCustomType). Inside the procedure I'm trying to join this parameter with real tables.
For example, something like
create or ...
2
votes
1answer
117 views
Upgrading from 10.2g to 11g by incrementals
I know it's possible to generate a full rman backup in a 10.2g database, move it to another server containing 11g, restore it there and finally do an upgrade.
Since I have to do this to a large ...
2
votes
1answer
383 views
How to copy bytea from Postgres to Oracle
I have a db on Postgres 9.1. The db collected some binary data that are stored in bytea file.
I need to copy the data to Oracle 10g. How to do it?
The details
I have a table plines in Postgres9.1. ...
2
votes
1answer
2k views
Is it possible to do a datapump import with a different user than did the export?
I have one db dump below is the log file for that dump
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** ...
2
votes
1answer
238 views
Access Data that is stored in Primary FileGroup On SQL Server through DBLinks on Oracle
I am using dbLinks to fetch data from SQL Server 2008 to Oracle (10g)database. When I fire the command : select * from "test_table"@dbLink
Oracle throws error :
select * from "test_table"@dbLink
...
2
votes
1answer
64 views
Oracle 10g Administration
Redo log files are not multiplexed in our database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer ...
2
votes
1answer
2k views
In Oracle, if parallel_max_servers is set to be significantly less than the DOP can the explain plan be sub-optimal?
For tables that have DEGREE DEFAULT, the degree of parallelism (DOP) is calculated by Oracle using number of CPUs and number of threads per CPU amongst other things. As I understand it, when costing ...
2
votes
1answer
947 views
Tips for Optimizing Oracle Warehouse Builder 11.1 with Oracle DB 10.2
Are there any tips for improving performance of Control Center and Design Center in Oracle Warehouse Builder? At the client side it is very slow to open and refresh Design center and control center ...
2
votes
0answers
39 views
Oracle 10g weird behaviour
We have a thick client application using an Oracle 10g database. We recently upgraded the application and in the process migrated the database tables from a latin to unicode character set.
After the ...
2
votes
1answer
136 views
Database Link from Oracle 10g on Windows over to MySQL database
Didn't see any answers on this subject so hoping for a miracle! :-)
I've got an Oracle 10g database running on Windows Server 2003 and I'd like to create a database link to an external MySQL database ...
2
votes
0answers
131 views
What do I need to do to avoid ORA-32696 errors?
I have a SELECT query using several WITH blocks. Sometimes it runs successfully. Very often it fails with the error "Lookup Error - Oracle Database Error: ORA-32696: HTI: No free slot". I Googled the ...
2
votes
0answers
247 views
Isssue with Database Links converting OEM Job to DBMS_Scheduler Job
We had an OEM job that would run a PL/SQL block using a particular database users credentials. The credentials are the same for two different databases, so there was no problem for the block to use a ...
1
vote
2answers
411 views
Is it possible for me to be notified if an 'after insert or update trigger' stops working?
Last week, I found my after insert or update trigger wasn't working. After I disabled and enabled it, it started working again.
I do not yet know why it stopped working. Is there any way to deal with ...
1
vote
1answer
121 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
3k views
Why Oracle sessions are still alive after two weeks being Inactive
DB: Oracle 10g
O/S: Windows Server 2003 64 bits
I query list of Oracle sessions generated by web applications (filter by program=w3wp.exe)
select * from V$session
where UPPER(program) LIKE '%W3%'
...
1
vote
2answers
6k views
Clone / Copy Oracle 10g & 11g
Hi I am absolute begginer in Oracle domain. I would like to learn way how to clone copy oracle database to som backup, use this backup on another server.
Oracle is installed on Windows server 2003.
...
1
vote
1answer
2k views
ora-01410 invalid RowID sporadically in a select statement
I have a select that looks up some data by a join. The system runs Oracle 10.02g and the select looks like this
SELECT distinct t1.crit
FROM table_name1 t1
INNER JOIN table_name2 t2
ON t1.crit ...
1
vote
1answer
261 views
Are multiple dbf files better than one?
Is it better to distribute a large database over several dbf files than over a single one?
1
vote
1answer
353 views
ORA-00984: column not allowed here
I am running Oracle 10g. I am writing a script (a delta script over a created database) that will be executed in SQL*Plus. It is needed to fix a bug.
I need to know if a row exist in a table, and if ...
1
vote
2answers
138 views
Join on clustered tables shows greater cost than non-clustered tables?
I have created a cluster and have two tables emp and sep on the cluster.
When I do the simple query...
explain plan select * from emp_cluster join dep_cluster using (dno)
the cost is 26.
I ...
1
vote
2answers
237 views
Oracle Databases - need to export nightly for backup/DR purposes
I know nothing about Oracle databases, so if my question's path seems odd, feel free to tell me the right way to do things.
I have 2 ways I see currently that I can backup a server running 3 Oracle ...
1
vote
2answers
279 views
Analyzing an Oracle dump
I have a full Oracle dump, I know I have to imp the dump with the fromuser touser clause.
However, I don't know the names of the schemas included in the dump. How can I open the dump created with ...
1
vote
1answer
36 views
What type of files are C-9999-yyyymmdd-00 in Oracle
At my {ORACLE_HOME}\database I found like 3GB of this type of files:
I think they are not backup of controlfile because size of files changes over time.
1
vote
2answers
199 views
Would existing constraints and indexes applied to an old table, apply to a new table renamed like the old one after it's dropped?
everything is in the question.
I have a table named tableA on which we have indexes and foreign keys and constraints.
I have to modify content in a column called column1. This being a production ...
1
vote
1answer
603 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
1answer
255 views
How do I determine if FORCE LOGGING is on for the entire database?
How can I determine if force logging is on, at the database level. (Not asking about finding out if force logging is on for particular tablespaces.)
What rights are needed to perform the check of the ...
1
vote
2answers
860 views
oracle 10G forms connection with Oracle database 10G Enterprise Edition in windows 7
I am trying to connect Oracle Forms 10g version (9.0.4) to the Oracle 10G Enterprise Edition.
At first I tried to connect to the db without setting the "Local Net Service Name Configuration" in ...
1
vote
1answer
205 views
This refactoring from cursor on a dblink'ed Oracle table OK?
The data is being compared from the local version of the table to one in the contracts linked server. I'm not certain what the goal of this code is in the first place, but I'm trying to get a handle ...
1
vote
1answer
323 views
Enterprise Manager Database Control on host with an underscore in it's name
I know it sounds awkward, but Enterprise Manager is refusing to be set up because of an underscore in the server name:
C:\>emca -deconfig dbcontrol db -repos drop
STARTED EMCA um 30.05.2012 ...
1
vote
1answer
297 views
ORA-07445: An unexpected error: core dump
We use oracle 10g. We found the following error in a trace file:
*** 2012-05-07 11:50:56.421
ksedmp: internal or fatal error
ORA-07445: An unexpected error: core dump [ACCESS_VIOLATION] ...
