Oracle Questions
how to delete or reduce the size of the log.xml on a 11g …
Comments: 8
Hi, We are running 11g (11.1) databases on UNIX platform. The XML.log that are being generated are quite large and it creates quite a few. This is taking up precious space and causing a f...
How can I query the list of all users in my oracle database?
Comments: 5
Hi, I used the CREATE USER command to create several users in my database, but is there a way to actually query the list of all users in this database? Thanks.
How can I import data dumps (*.dmp) into Oracle datab…
Comments: 14
Hi, I have several dmp files which I suppose are data dump files. Now I want to import those data into my oracle database. I have a new installed oracle database. What should I do? ...
ORA-12560: TNS:protocol adapter error
Comments: 6
Oracle version 11i New installation, all successful, used to run ok I created a new database once and deleted afterwards, the original orcl database no longer works When I us...
SQL Query for highest value
Comments: 11
I am trying to run a query for the highest column value in a table. Needless to say it isn't working Can someone explain where I am going wrong? Thanks
Display of calculated field value in same field using form per…
Comments: 10
Hi All, What could be the solution, if i want to have the formula on same display field. say..your entering value in grams and convert into ml in the same field of (:Q_RES.DISPLAY5)...
any information on migrating Oracle application R12.1 da…
Comments: 3
We are planning to use an Exadata V2 machine to house an R12.1.1 database. I think we will need to perform the base install,upgrade the database in place to 11.2 and then migrate the db to ...
Oracle default database
Comments: 2
Running Oracle 11.2 on a Windows 2008 server. For testing purposes we installed several oracle SIDS. They all work fine. To login using sqlplus or RMAN using---- sqlplus "...
Download Software for installing Oracle 11g RAC
Comments: 1
Hello, In order to install Oracle RAC 11gR2 on a Windows Server 2003 64bits, what software do I have to download and install: http://www.oracle.com/technetwork/d...
Cannit install Oracle Database 11g - Release 2
Comments: 1
Oracle 11g 64 bit version will not install on windows 7. Another user with win 7 was able to install it (per the user having the issue, tho I have not confirmed this). Either clicking on the .exe ...
values in active session history ( db file sequential read w…
Comments: 3
whats the meaning of all the values in active session history ( db file sequential read wait for SID of 16, file# 12, block# 1245, obj# 67, and time: 20000us.
Oracle And Recursive Queries...
Comments: 2
Hi, I'm not overly skilled in recursive queries so I'd like to ask for some advice on a pretty simple use of it. In a nutshell, I would like to gather the direct reports of a people manager along with their...
- Contents of Active Session History - For example, db f…
Comments: 4
whats the meaning of all the values in active session history ( db file sequential read wait for SID of 16, file# 12, block# 1245, obj# 67, and time: 20000us.
copy data from one schma to another - only selective tables
Comments: 3
Hi I have a requirement to copy data from one schme to another some list of tables ( want to maintain a list so that I can add whenever needed) the table structure on both schema is same - I do...
new question for _1C view
Comments: 122
Ok, now view collect data from EURUSD_RT table and put in VIEW_EURUSD_1C exactly 61 rows and all other views collect they data from VIEW_EURUSD_1C, but we have another two problem...
view statement not work
Comments: 20
The view statement: CREATE OR REPLACE FORCE VIEW "LIONFX"."VIEW_EURUSD_RT" ("ID", "SYMBOL", "BIDPX", "ASKPX", "TIMEST") AS SELECT "ID", ...
Select Year query
Comments: 3
I have two fields: fiscalyear 2010 lastDate 10/20/2010 I want to do a query on the table to find the records where the lastDate year is NOT the fiscal year select * f...
Update of Partial Field
Comments: 4
I have a field with values like so: P-60-01-04-3795-71 P-60-01-04-3795-72 P-60-01-04-3796-1 I want to update the first part of all of thes...
Dynamic SQL
Comments: 11
I have a procedure as the following and I am getting the error while executing as SQL command not properly ended. I believe I am getting error at the condition IF p_facilityname IS NO...
mounting
Comments: 3
while startup following error is show, sqlplus / nolog conn sys / as sysdba Enter password: Connected to an idle instance sql>startup ora-01261: Parameter db...
update statement in a procedure
Comments: 7
I have the following procedure. Please suggest if my update statement works in the following proc
install
Comments: 4
Is there any way to install oracle 10g in my windows xp os. Is that free. Same requirement if install oracle 11i. Thanks..
Need help with Space Management in Oracle Personal
Comments: 9
I am a student and have installed Oracle on my personal computer for learning purposes. I have been using the database for a while and the files TEMP01.DBF, SYSTEM01.DBF, USERS01.DBF...
Oracle Locks
Comments: 2
Can someone explain to me the different types of locks and how are they different? they are very simular.....I don't know how are they different after reading the slide and the material on the web...
Stay Connected
Featured Oracle Articles
- Free Oracle tips from Experts Exchange
- How Oracle Stores Passwords
- How to FTP with Oracle PL/SQL
- How to Send Email Attachments with Oracle
Free Oracle tips from Experts Exchange
How Oracle Stores Passwords
Many times a DBA may want to replicate a user from one system to another and migrate that same password,such as refreshing a production system ...
How to FTP with Oracle PL/SQL
Sometimes you need to get data from a server into your database or from your database into a remote server. Learn how to use FTP to ...
How to Send Email Attachments with Oracle
Oracle introduced the UTL_SMTP package with the release of 8i back in 1999, but up through the current version (11.2.0.1) available on OTN...
Oracle Around the Web
- The latest Oracle news, tips, and tricks
- Oracle Unveils Netra SPARC T3 Servers
- Oracle fixes 21 flaws in Java SE, Java for Business
- Obama’s Silicon Valley “Tech Supper”
The latest Oracle news, tips, and tricks
Oracle Unveils Netra SPARC T3 Servers
New Carrier-Grade Blade and Rackmount Servers Deliver Better Performance, Density and Power Efficiency for the Communications Industry ...
Oracle fixes 21 flaws in Java SE, Java for Business
Oracle is fixing 21 flaws in its Java SE and Java for Business products in its February critical patch update issued this week ...
Obama’s Silicon Valley “Tech Supper”
Why was he there? Who wasn’t invited and why? What did they talk about? Why was he really there? These are the questions being debated ...
Featured Oracle Experts
Testimonials
What users are saying about our experts
"The Oracle gurus provide answers, solutions and valuable workarounds"
User: schwertner
"Wow! Excellent, valuable explanation. Hats off to you"
User: aseshu70
"Solution worked fantastic and performs excellent! Thanks heaps"
User: klausbrandlhuber
Top Experts
-
slightwv
1,500
0 points yesterday
Profile