| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I am using oracle XE and have a folder at c:\oraclexe\oradata\XE\ with 6 DBF
files. I want to move them to d:\ to make more room on the c-drive.
Can...
Uffe Kousgaard
|
08-11-2011 09:13 AM
Mark D Powell  | 2 | 3 |
| | | Hi,
I have a table with 3 nested tables in it, and of course x number of
records in each nested table.
I'm looking to include with my query output...
The Magnet
|
08-01-2011 11:13 AM
Michel Cadot | 1 | 2 |
| | | Database Administrator Articles
http://dba.fyicenter.com/article/
Are you a DBA? Need to update your database administration knowledge?
We have...
java
|
07-31-2011 09:28 PM
java | 0 | 1 |
| | | We are replicating a few tables from Oracle Database 11gR2 to Oracle
11gR1 using Streams Replication (Downstream Capture). The archived log
files...
Ora_DBA
|
07-20-2011 01:48 PM
ddf | 2 | 3 |
| | | Hi,
I need to make a FK constraint, but it is against a table where the
column is not a PK, can this be done?
Table1:
Customer ID \ Composite...
The Magnet
|
07-15-2011 01:57 PM
joel garry | 1 | 2 |
| | | I'm sure this is a syntactical issue, but I'm still searching the web:
CREATE OR REPLACE TYPE estimate_date_type AS OBJECT (
qr1_end_date ...
The Magnet
|
06-27-2011 06:04 PM
Tim X | 6 | 7 |
| | | Hi,
I'm taking another shot at this. I'm trying to create a nested table,
then use a BULK COLLECT & FORALL insert. Here is my code, but no
matter...
The Magnet
|
06-22-2011 09:48 AM
The Magnet | 4 | 5 |
| | | Andreas Mosmann wrote:
Before you can extend a collection you have to create it
(with the table type constructor).
It looks like you want to...
Andreas Mosmann
|
06-22-2011 09:18 AM
Andreas Mosmann | 13 | 14 |
| | | Trying this example to give me a start on creating my table with the
error below:
CREATE TYPE Worker AS OBJECT (name VARCHAR2(25), dept...
The Magnet
|
06-17-2011 04:51 PM
The Magnet | 3 | 4 |
| | | There is no real documentation that I can find on this, so here goes
the question. Can I combine a FORALL ... INSERT with a nested table?
Say I...
The Magnet
|
06-16-2011 03:04 PM
The Magnet | 2 | 3 |
| | | Hello,
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
I have a table that will contain around 300 million rows so...
Luke
|
06-15-2011 02:27 PM
joel garry | 9 | 10 |
| | | PSD to XHTML Conversion, PSD to HTML CSS, Joomla, Wordpress, Drupal,
CMS, VBULLETIN, PHPBB
and includes convert to XHTML like PSD to XHTML, web...
PSD to XHTML Conversion Services and PSD to HTML CSS Conversion Services, PSD to Joomla, Drupal, Wor
|
06-08-2011 04:50 AM
PSD to XHTML Conversion Services and PSD to HTML C | 0 | 1 |
| | | HR round interview questions and answers
http://dba.fyicenter.com//Interview-Questions/HR-Round/
your first round of interviews would be with HR...
java
|
05-27-2011 11:59 AM
joel garry | 1 | 2 |
| | | Hi,
I have a real messed up query. It generates a number of numeric
columns. I need to generate a grand total row at the bottom.
I have been...
The Magnet
|
05-21-2011 10:44 AM
Robert Klemme | 4 | 5 |
| | | I maintain a PHP-driven web app that's been deployed for several
customers that have a variety of Oracle environments. One of them has
reported that...
Álvaro G. Vicario
|
05-20-2011 05:00 AM
Carlos | 10 | 11 |
| | | I have a problem SQL statement that our DBA's, Orace support nor
myselfI cannot fix. Believe me, I've tried everything. It takes 3
hours to run and...
Steven Holland
|
05-10-2011 01:45 PM
Gerard H. Pille | 10 | 11 |
| | | Hi,
Can I do a complete refresh of a materialized view if the view exists
on a remote database? I tried doing it via the db link but the...
The Magnet
|
05-05-2011 04:05 PM
The Magnet | 0 | 1 |
| | | Hi,
This is a weird one. I have a procedure where I use BULK COLLECT:
OPEN mf_detail;
FETCH mf_detail BULK COLLECT INTO v_mf_record;
CLOSE...
The Magnet
|
04-19-2011 01:49 PM
The Magnet | 0 | 1 |
| | | Hey, thanks to those who helped me with that convoluted query before.
Here is another weird thing. I need to create a Materialized View
based on a...
The Magnet
|
04-18-2011 12:11 PM
The Magnet | 2 | 3 |
| | | Hi,
I posted something similar to this elsewhere, but maybe a simpler
example will help.
Why is this failing? In this query, the top query does...
The Magnet
|
04-14-2011 09:40 AM
The Magnet | 9 | 10 |
| | | Hi,
I am using PL-SQL code to find out the number of rows in the tables in
the user XYZ.
set serveroutput on;
DECLARE
sqlstr VARCHAR2(1000);
cnt...
Joydeep Chakrabarty
|
04-02-2011 02:08 PM
Joydeep Chakrabarty | 5 | 6 |
| | | Hi,
I'm trying to use DBMS_METADATA to get the DDL:
SELECT TO_CHAR(DBMS_METADATA.GET_DDL('TABLE',
o.name,'DATA_HOLDER')) ddl_string
FROM ...
The Magnet
|
04-01-2011 10:51 PM
onedbguru | 2 | 3 |
| | | Hi,
I'm just having trouble understanding this. What are the real
differences between the ASHRPT, ADDMRPT and AWR? I am not finding...
The Magnet
|
03-14-2011 01:47 PM
joel garry | 1 | 2 |
| | | Hi,
We have a requirement to get data from two tables in our database. The
data from 2 tables looks as below:
Table 1
Emp No. Start Date 1 ...
Sandy80
|
03-08-2011 08:38 AM
Sandy80 | 0 | 1 |
| | | VTD-XML 2.10 is now released in Java, C#, C and C++. It can be
downloaded...
dontcare
|
03-04-2011 11:41 PM
dontcare | 0 | 1 |
| | | Hi,
I have this query (below), it is supposed to return 2 columns from
different tables using subqueries. So, each query is a column. If
data is...
The Magnet
|
03-04-2011 02:57 AM
Maxim Demenko | 1 | 2 |
| | | Hi,
I have Oracle 11g r1 and applications running on remote machines using
InstantClient. These applications read the same table repeatedly as
part...
Martin
|
03-01-2011 04:01 AM
Martin | 2 | 3 |
| | | Hi,
I am using this query. It returns information on existing orders the
customer has, and ranks them based on the status.
We have 25 products...
The Magnet
|
02-16-2011 09:40 AM
Mark D Powell | 1 | 2 |
| | | Hi,
Been trying for a couple of hours to do this. Here is my query:
SELECT data..........
FROM customer c, customer_account ca, customer_address...
The Magnet
|
02-15-2011 09:27 AM
news.cyf-kr.edu.pl | 2 | 3 |
| | | Hi, there is a view like
ID SORT FK
01 -5 N
01 -4 N
01 -3 Y
01 -2 Y
01 -1 N
01 0 Y
Andreas Mosmann
|
02-11-2011 04:21 AM
Andreas Mosmann | 7 | 8 |
| | | Hi all,
here are the requirements that I'm messing with:
- Oracle 10g
- Table like this
CREATE TABLE TMP_TABLE
(
PKID INTEGER NOT NULL ENABLE, --...
Mau C
|
02-09-2011 06:28 PM
joel garry | 9 | 10 |
| | | Hi,
maybe the question was asked many times, but I could not find any
answer. Can anybody give me a link or an explaination to all columns...
Andreas Mosmann
|
01-28-2011 04:34 AM
Andreas Mosmann | 2 | 3 |
| | | Hi,
I work on Oracle 11 and sometimes there are queries, that need hours to
be performed.
is there a way to find out the progress of a special query...
Andreas Mosmann
|
01-27-2011 06:06 AM
Andreas Mosmann | 3 | 4 |
| | | Hi,
I need to create a very strange query. I'm sure it can be done, maybe
with analytical functions or something, but I need help. We are on
10g...
The Magnet
|
01-24-2011 02:41 PM
The Magnet | 2 | 3 |
| | | Ok, I'm lost. I was trying to calculate the query execution time for
queries in the shared pool. I used this type of sql.
Now, when I look at a...
amerar@zacks.com
|
01-13-2011 04:03 AM
Gerard H. Pille | 1 | 2 |
| | | I want to learn Siebel.
I presume it is complicated task to install Siebel for free on my computer -
Is it?
Also, is there any Virtual Machine that I...
Mr. X.
|
01-06-2011 01:40 AM
Mr. X. | 0 | 1 |
| | | If it is to double your income next year then explore working on Part
Time, Freelance, Virtual ERP Assignments,Work in Surplus Time and Earn
upto...
ERP Expert
|
01-03-2011 05:48 PM
joel garry | 1 | 2 |
| | | Chartered Technofunctional Institute invites all ERP Professionals
worldwide to take benefit of unique ERP Virtual Consulting Model and
start working...
ERP Expert
|
01-03-2011 01:25 PM
ERP Expert | 0 | 1 |
| | | I've just installed Oracle XE (Oracle Database 10g Express Edition
Universal). I've changed nothing so it's the using the character sets
specified in...
Álvaro G. Vicario
|
12-27-2010 10:58 AM
Álvaro G. Vicario | 2 | 3 |
| | | Hi!
I have developed free Data Visualization
application that allows user to create reports
from Oracle data base.
If somebody is interested it can...
Adam Witkowski
|
12-15-2010 02:15 PM
Adam Witkowski | 0 | 1 |
| | | I am a Solaris Admin interested in installing Oracle database 10g on
Sun Cluster 3.3 I need help with the database aspects of the
installation....
Rick Smith
|
12-11-2010 10:21 AM
Rick Smith | 0 | 1 |
| | | I am trying to create materialized views based on a few tables in a
logical standby database.
The target database (11g R2) where the MVs will be...
Ora_DBA
|
12-10-2010 02:29 PM
joel garry | 2 | 3 |
| | | Hi all
I have tried this, but it fails. I need to call a procedure (it works
we do it all the time) with parameters.
The Oracle code works in an SQL...
jodleren
|
12-09-2010 03:22 PM
Robert Klemme | 1 | 2 |
| | | I'm not sure if this is the correct forum, but I'll give it a shot.
I'm using the Oracle built-in XML functions to format a result set into an
XML...
John Peterson
|
12-02-2010 03:06 PM
Gerard H. Pille | 5 | 6 |
| | | Hi
I posted some time ago about this, Mark D Powell answered, and I got a
bit brighter, then other works, and I am back.
I have the procedure to...
jodleren
|
12-02-2010 10:15 AM
Mark D Powell | 3 | 4 |
| | | Imho, use patch, 11.2.0.2 or better.
"Markus Donath" <ma_donath (AT) t-online (DOT) de> wrote
Jack
|
12-01-2010 05:51 AM
Jack | 0 | 1 |
| | | Dear Everyone,
as you know the price of the Oil is more and more increasing, while
the oil supply is decreasing. Moreover Oil
is causing wars,...
........
|
11-21-2010 04:56 PM
........ | 0 | 1 |
| | | Hi all
I need to send data to this thing - and I guess that the
"selite" (explanation) is an array or something.
Just how do I do that?
I...
jodleren
|
11-11-2010 08:42 AM
Mark D Powell | 1 | 2 |
| | | Hi,
I would like to make certain columns in an Oracle table read only to
prevent anyone from updating the values in these columns. I can think
of...
Ninja Li
|
11-10-2010 12:07 AM
Ninja Li | 8 | 9 |
| | | ERP Functional Consultant:
Functional Consultants are the experts having understanding of the
business processes and data flow on one hand and has...
ERP Expert
|
11-08-2010 01:15 PM
ERP Expert | 0 | 1 |
