Tagged Questions
-1
votes
0answers
23 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?
-1
votes
1answer
48 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
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 ...
0
votes
1answer
61 views
Database creation on Linux with dbca: “command not found”
I have installed an Oracle on my machine. When I open a session with VNCServer and type dbca, either as root or as oracle, I get these errors:
-bash : -dbca : Command Not found
Xlib: connection to ...
0
votes
1answer
43 views
trying to execute SQL query on an oracle 10g database using java but getting ORA-00911 error [closed]
I am trying to execute a simple CREATE TABLE query on an oracle10g database using java. This is what I am doing:
Connection conn = //create connection
//open connection. No errors/warnings are ...
2
votes
1answer
50 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 ...
0
votes
1answer
87 views
Oracle trigger to update columns daily
I'm trying to create a trigger that would run twice daily and do updates based on a specific condition.
To be run on Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
We have Table A ...
1
vote
0answers
30 views
How can I count the total number of document indexed by my oracle.text index?
I know I can use ctx_query.count_hits to count the number of document matching a query,
and similarly, I can use
count(*) where CONTAINS(...)
But these are only options if I actually have a query. ...
1
vote
1answer
71 views
Materialized view log not updating
Under what conditions would a materialized view log not update?
I must be missing something. I've got a 10gR2 database. I can create the following MV logs:
CREATE MATERIALIZED VIEW LOG ON linked_t1
...
1
vote
1answer
59 views
Finding why an Oracle listener got automatically restarted
I got the following message in the <listnername>.log file. I want to find out the reason why it got automatically shutdown and restarted again with different PID.
03-MAR-2013 03:00:57 * ...
0
votes
0answers
55 views
TimesTen performance as compared to 10g
I am new here, so please be nice...
I have a question regarding TimesTen & Oracle. I have attempted an experiment with both pieces of software, and realize that the query speed on a table is ...
0
votes
1answer
132 views
Creating new database and insert values in Oracle 10g xe hr account?
I am new to Oracle 10g xe. When I log into hr account, how do I start creating new database and insert values? My case study is a five aside football league, where the organizer wants to know ...
0
votes
0answers
178 views
12154 error when using PL/SQL Developer
I have installed a few versions of Oracle on my machine. I have tried 64 bit and 32 bit versions. I have installed 11G. I need Oracle 10G 32 bit.
Using the following guide I removed all versions of ...
4
votes
2answers
180 views
Oracle View Ignoring External WHERE Clause
Good day,
This one has me stumped. I have a rather nasty developer query that I would like to store in a non-materialized Oracle view. The text for the view itself is a bit long to list here, but ...
0
votes
1answer
285 views
Difference between full and level 0 rman backups?
Suppose we take a full backup, and after that we take a level 0 backup, both using RMAN and Oracle 10g.
I'm confused in the use of the level 0 backup and full backup. I found that the difference ...
1
vote
1answer
77 views
Deleting folders after Oracle upgrade
I upgraded from Oracle 10g to Oracle 11g in Windows Server 2003.
New Oracle home : C:\app\oracle\product\11.2.0\db_1
Old Oracle 10g was installed on: C:\oracle\product\10.2.0\
Questions
Is the ...
1
vote
1answer
111 views
What's the maximum number of listeners an Oracle database can have?
Can an Oracle database have more than one listener? If so, what's the maximum number of listeners a database can have?
0
votes
1answer
52 views
Problems with generating Audit SQL
Im currently working on a project that uses Oracle 10g where every action from the user is recorded in a auditlog table. The current table holds the following values:
AuditID
AuditDate
Username
Page ...
9
votes
1answer
382 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
322 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 ...
1
vote
0answers
165 views
Which oracle (10g) template files (DBCA) can be be copied to different server for cloning?
I am trying to clone a schema from one Oracle 10g server to a different Oracle 10g server.
I have created a database template (DBCA) from an existing database (structure and data).
I have copied ...
0
votes
0answers
73 views
How can I move my database from linux server to SAN? [closed]
Please anyone4 can tell me How can i move my oracle 10.2.0.4 database which is on linux server to SAN(Storage Area Network).?
5
votes
2answers
563 views
How to install Oracle 10g Express and 11g Enterprise on same machine
I have to continue maintaining an Oracle 8i database that receives information (about 20 Inserts and Updates a day) from a 9i database. I am upgrading the 9i database to 11g which does not support ...
1
vote
2answers
203 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 ...
2
votes
2answers
623 views
Oracle - abort within a “before insert” trigger without throwing an exception
I know that this is an awful thing to do for many reasons, but I am in Get Things Done mode and we have a piece of software, which we can't modify, that writes records to a table. Some of these ...
2
votes
1answer
920 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 ...
5
votes
1answer
135 views
how do I configure a new Oracle 11g instance to match the configuration of the old Oracle 10g server
How can I compare two Oracle database servers which are on two different machines?
We need to ensure that the new server is setup correctly.
For example, one machine is running Oracle 10g on ...
1
vote
1answer
122 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%'
...
0
votes
1answer
396 views
impdp import fails with object already exists in oracle 10g?
I exported the dump using EXPDP command. After exporting I dropped the user and the associated tablespaces by logging is as / AS SYSDBA.
Then I re-created the User and the Tablespaces. Then I ...
2
votes
1answer
390 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
3answers
263 views
How can I delete duplicates records in a table efficiently
I know there are several options to delete duplicate rows, eg:
ROWID
Analytical fn's like Rank(), row_number()
What would be the most efficient way?
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 ...
0
votes
0answers
63 views
Oracle form 10 g “RUN” Error
I have built a form from the employees table and trying to run it.But nothing is showing except for some text in the web browser with address being my local documents location instead of
...
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
...
0
votes
1answer
1k views
Why does dbms_scheduler max_run_duration not raise event JOB_OVER_MAX_DUR?
Starting from this question and this example I've tried to create an event based dbms_scheduler job, which waits for event JOB_OVER_MAX_DUR raised from jobs, which exceeded their max_run_duration.
...
3
votes
1answer
1k views
Is there a timeout for a query over database link?
Edit/Preface:
This question has been migrated from SO as I am particularly interested on the question on timeouts on DB link queries. The provided workaround from SO is somewhat OK, but I'm really ...
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/******** ...
0
votes
1answer
192 views
Unable to restore database in Oracle 10g
I created a database backup using the expdp command in Oracle 10g. The backup appears to be created successfully. However, while restoring using impdp command I get the following error message.
...
1
vote
1answer
264 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?
0
votes
1answer
3k views
How to take oracle 10g backup? [duplicate]
Possible Duplicate:
How to take oracle 10g backup?
I followed this http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php link to create a db backup. I used this command to create ...
1
vote
1answer
266 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 ...
4
votes
1answer
670 views
Oracle subquery column aliasing syntax?
I have something like:
SELECT a, b
INTO v_a, v_b
FROM (
SELECT x, y
FROM whatever
UNION
SELECT z, w
FROM something
) AS subquery (a, b)
Which of course doesn't work in Oracle ...
0
votes
0answers
237 views
Problem in exporting users from oracle database. (Oracle 10g express edition)
I am trying to export the user from database, but its showing
export done in we8mswin1252 character set and al16utf16 nchar character set
But if i am trying to export entire database then its ...
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 ...
1
vote
1answer
207 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 ...
4
votes
2answers
117 views
What are the risks of the parameter PRESERVE_COMMIT_ORDER of Oracle's DBMS_LOGSTDBY?
We have the following setting, with Oracle 10g:
One primary database
One logical standby database with setup with data guard. The logical standby is only used for generating reports and alike.
...
1
vote
1answer
324 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 ...
9
votes
1answer
175 views
SQL substitution feature in Oracle 10g
Three or four years ago I read in an Oracle blog somewhere that a DBA had used for an emergency incident resolution an Oracle 10g feature of real time SQL substitution. Basically, he configured Oracle ...
