Oracle Questions

Sort by:

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...

Author: melzqueen asked 2 years 58 days ago

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.

Author: pisceswzh2010Tags: Oracle, User asked 2 years 198 days ago

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? ...

Author: pisceswzh2010Tags: Data Dump, DMP, Oracle asked 2 years 198 days ago

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...

Author: pisceswzh2010Tags: Oracle asked 2 years 199 days ago

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

Author: g_currierTags: Oracle, SQL, PL/SQL asked 2 years 203 days ago

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)...

Author: amutallibkhanTags: Form Personal..., Oracle Applic... asked 2 years 210 days ago

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 ...

Author: Jeffjdn01 asked 2 years 211 days ago

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 "...

Author: dakota5Tags: oracle, default database, default sid asked 2 years 216 days ago

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...

Author: miyahira asked 2 years 217 days ago

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 ...

Author: Mangi05Tags: Oracle asked 2 years 222 days ago

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.

Author: nirvairghumanTags: active session... asked 2 years 224 days ago

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...

Author: MedtronicVascSRTags: Oracle, SQL asked 2 years 225 days ago

- 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.

Author: nirvairghumanTags: For example, db file sequen..., file# 12 asked 2 years 225 days ago

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...

Author: mahjag asked 2 years 232 days ago

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...

Author: gbcbrTags: Oracle 11g, PL/SQL asked 2 years 233 days ago

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", ...

Author: gbcbrTags: Oracle 11g, PL/SQL asked 2 years 233 days ago

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...

Author: BobCSD asked 2 years 237 days ago

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...

Author: BobCSD asked 2 years 245 days ago

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...

Author: meera78 asked 2 years 245 days ago

Oracle Startup Force

Comments: 4

When should I use STARTUP FORCE?

Author: mawingho asked 2 years 245 days ago

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...

Author: nobleitTags: oracle-startup asked 2 years 245 days ago

update statement in a procedure

Comments: 7

I have the following procedure. Please suggest if my update statement works in the following proc

Author: meera78 asked 2 years 246 days ago

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..

Author: nobleitTags: oracle10g asked 2 years 247 days ago

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...

Author: gswitz asked 2 years 247 days ago

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...

Author: mawingho asked 2 years 247 days ago

Stay Connected

Oracle Around the Web

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 ...

read more

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 ...

read more

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 ...

read more

Featured Oracle Experts

slightwv

slightwv has answered more than 2,000 Oracle questions and oversees database management within the U.S. Government. Slightwv

sdstuber

A regular presenter at the Collaborate conference, Oracle developer sdstuber is a top expert in PL/SQL and Oracle 9, 10 and 11. sdstuber

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

  1. slightwv

    1,500

    0 points yesterday

    Profile

BrowseBecome an Expert