| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | Hi,
This database is only 60GB, and is taking 9 hours for RMAN to back
up?? Though the disk where the backup files are put is mounted NFS,
that...
ExecMan
|
01-26-2012 10:08 AM
ExecMan | 0 | 5 |
|  | Hi,
I am a Staffing Specialist for USTech Solutions, a global company
specializing in staffing both Consulting and Full Time positions.
At some...
SAI
|
01-16-2012 03:55 PM
joel garry | 1 | 2 |
|  | I require the ability to add a new clob field to a database table
object on Oracle 10g SQL server.
Can I just do an
alter table MyTable add column...
jack_gold2@yahoo.com
|
01-13-2012 12:41 PM
Mark D Powell | 5 | 6 |
|  | I wonder what are the requirements for the minimally sized redhat-like
distribution (or centos, or fedora) which allow oracle to run without
issues?...
geos
|
01-12-2012 04:43 PM
geos | 0 | 1 |
|  | Hello,
My asp.net web app uses ODP.NET 10.1.0.400 to connect to an Oracle 11g
or Oracle 10g database.
I got error with dates for both databases....
Big George
|
01-09-2012 05:15 PM
joel garry | 1 | 2 |
|  | Hi everyone,
I am working on the following question. I would appreciate if someone
could help me with it.
You are running a DBMS on a computer...
elodie
|
01-09-2012 05:07 PM
joel garry | 5 | 6 |
|  | susmitha wrote:
Do you do house training?
Gerard H. Pille
|
12-19-2011 04:10 PM
Gerard H. Pille | 0 | 1 |
|  | TECH JOB FAIR – Detroit Area
Experienced Information Technology Professionals Invited!
Thursday, December 15, 2011, 3:00-7:00pm
Marriott Courtyard...
Karen Schmitz
|
12-16-2011 01:59 PM
joel garry | 5 | 6 |
|  | Hi,
I am pleased to announce the release of ODB 1.7.0.
ODB is an open-source object-relational mapping (ORM) system for C++. It
allows you to...
Boris Kolpackov
|
12-08-2011 12:33 AM
Boris Kolpackov | 0 | 1 |
|  | I have table and i dont know how to write trigger to this table
Table:
CREATE TABLE TAB1
(
ID NUMBER(9),
ID2 VARCHAR2(20)
)
Valuses:
KonradWo
|
12-01-2011 04:17 PM
Gerard H. Pille | 5 | 6 |
|  | Hi, I'm trying to get the following scenario to work. Maybe someone
can help?
We have the following small setup:
DATABASE: DB1
USERS: TOM & BILL,...
ExecMan
|
11-21-2011 05:47 PM
joel garry | 7 | 8 |
|  | I don't where should I post this, but VirtualBox is an Oracle product,
though not a database, so I'll post it here. When trying to use VBox with
the...
Mladen Gogala
|
11-18-2011 09:05 PM
Mladen Gogala | 0 | 1 |
|  | I have a sessions table like the following:
SID UserID TimeIn TimeOut
1 10 Aug-10-2011 11:30:45 ...
hilljm1974@gmail.com
|
11-16-2011 10:09 AM
Mark D Powell | 2 | 3 |
|  | Hi all,
Using: 11.2.0.1 on RHEL5 64bit RAC cluster ...
I'm a novice in using the RANK analytical function, struggling with the
basic syntax of it...
Geoff Muldoon
|
11-15-2011 05:49 PM
Geoff Muldoon | 3 | 4 |
|  | there is a big text file with dirty data. a company wants it to be
clean. there are some known patterns expressed as like or regexp. I
first thought...
geos
|
11-14-2011 12:43 PM
joel garry | 10 | 11 |
|  | Suppose I have a table like:
ITEM DESCRIPTION LOCATION BIN
1234 RED LAMP WAREHOUSE CL32
1234 RED LAMP STOREROOM ...
cbursell@geusnet.com
|
11-13-2011 04:04 PM
Kaj Julius | 8 | 9 |
|  | Hi,
I just wanted to understand something about the SQL / PLSQL
environments. Often we store things into a PL/SQL table and then
using CAST we can...
ExecMan
|
11-08-2011 03:27 PM
ddf | 1 | 2 |
|  | hello, I am thinking about oracle certification. my interest focus on
administration and sql/plsql development. there is quite a list of
available...
geos
|
11-04-2011 01:28 PM
Mark D Powell | 1 | 2 |
|  | Hi,
Our application has a complex query. The query retrieves data from a
table, which contains some nested tables. I'm being asked if the
results...
ExecMan
|
11-02-2011 03:01 PM
ExecMan | 2 | 3 |
|  | Moncler Men’s Down Jackets make you more confident and handsome
because of its fashionable silhouette,it also insulates you from the
coldest...
Anna John
|
11-02-2011 01:07 AM
Anna John | 0 | 1 |
|  | Wearing the Moncler in winter,which is the most thing in winter,bring
you not only warm but light convenient,also bring fashion.
Please clik here to...
Anna John
|
11-02-2011 01:03 AM
Anna John | 0 | 1 |
|  | I prepare a table as follows:
create table empm as select * from emp where deptno = 10;
then I merge more data this way:
merge into empm m
using...
geos
|
10-26-2011 02:48 AM
geos | 5 | 6 |
|  | I wonder if you could you share some thoughts and experience about doing
(small) ETL in sql/plsql? I mean what general approach would you take?
what...
geos
|
10-21-2011 02:13 PM
Mladen Gogala | 2 | 3 |
|  | there is a query which executes with two different plans when run on
different accounts. this is generally understandable to me. but is there
a...
geos
|
10-21-2011 11:54 AM
geos | 5 | 6 |
|  | Hi. I'm trying to use a varchar as the first part of a for loop but
can't find a way to make it work.
listCursor varchar2(100);
if x is not...
jimmy
|
10-21-2011 08:35 AM
jimmy | 2 | 3 |
|  | I got a very strange problem. If the first character in a string is
a single quote I get a syntax error, but that only happens in a
compare and...
Joachim Verhagen
|
10-19-2011 11:05 PM
joel garry | 5 | 6 |
|  | In-Memory Databases or Big Data? Engineered or DIY Systems? Appliances or machines? What do the Oracle Database announcements from OpenWorld mean to...
Oracle India Events
|
10-17-2011 05:49 AM
Oracle India Events | 0 | 1 |
|  | Dear everybody
I have problem to set configurations of OESSO(Oracle Enterprise Single
Singn-on) .I have searched about a month on the internet to...
Ghassem Koolivand
|
10-13-2011 07:34 AM
Ghassem Koolivand | 2 | 3 |
|  | reservastrancoso (AT) gmail (DOT) com
reservastrancoso @ gmail.com
(reservastrancoso (AT) gmail (DOT) com)
Pousadas em Trancoso, agencia virtual em...
pousadas trancoso reservas bahia
|
10-13-2011 01:38 AM
pousadas trancoso reservas bahia | 0 | 1 |
|  | https://www.dbainspace.com/
(Thanks, /.)
jg
--
@home.com is bogus.
http://www.informationweek.com/news/software/enterprise_apps/231900679
joel garry
|
10-12-2011 07:47 PM
joel garry | 0 | 1 |
|  | put_line places data into buffer. this data is displayed as soon as
pl/sql code is finished and control returns to invoking environment...
geos
|
10-10-2011 03:29 PM
Kay Kanekowski | 14 | 15 |
|  | I can define user variable in sqlplus using DEFINE keyword. it gets lost
from memory with UNDEFINE keyword.
is there a way to do the same, ie. free...
geos
|
10-05-2011 02:43 PM
geos | 4 | 5 |
|  | I have a table entry which contains a column called recalc (value 0 or
1). Sometimes code sets the recalc column to 1 indicating to a job
which runs...
Martin
|
09-29-2011 01:11 PM
Martin | 6 | 7 |
|  | Attending Oracle OpenWorld is the most cost-effective and efficient way to stay ahead of the technology curve—and this year's event incorporates...
Oracle India Events
|
09-29-2011 05:32 AM
Oracle India Events | 0 | 1 |
|  | Hello,
i'm following tutorial on how to send email in Oracle 10g. When I try to
grant access to package UTL_MAIL, I get an error of "package not...
Pif 34
|
09-27-2011 06:44 PM
ddf | 3 | 4 |
|  | File this under "you can't make this shit up:"
http://www.hp.com/hpinfo/newsroom/press/2011/110922xb.html
jg
--
@home.com is bogus.
Well, Pa's in...
joel garry
|
09-22-2011 06:24 PM
joel garry | 0 | 1 |
|  | Hi,
I need to get a unique column but I also need to return multiple rows.
Using the following doesn't work to get the unique last name since...
test@m.com
|
09-22-2011 04:45 PM
Robert Klemme | 8 | 9 |
|  | Hi,
I have a table which I load through the sql loader using the following
command:
${ORACLE_HOME}/bin/sqlldr...
Sandy80
|
09-21-2011 12:21 PM
joel garry | 2 | 3 |
|  | Is there a patch available to protect Oracle's version of Apache against this vulnerability?
Gerard H. Pille
|
09-05-2011 03:47 PM
Gerard H. Pille | 0 | 1 |
|  | Hi,
I am having problems granting access to all tables to a role. I have
tried the following I found in the internet ....
begin
for i in (select...
test@m.com
|
08-30-2011 10:42 AM
Mark D Powell | 4 | 5 |
|  | hi,
i need to extract user creation, profiles and roles from a oracle 8
database. does anyone have any SQL code which can help me achieve the
same....
vask
|
08-25-2011 08:03 PM
John Hurley | 3 | 4 |
|  | hello, in pl/sql code I have defined a variable:
x varchar2(100) := 'do not :1';
is it possible to change the value of x to 'do not eat' with...
geos
|
08-25-2011 04:34 PM
geos | 3 | 4 |
|  | Hi,
I have a problem with privileges.
I can *select* rows from a user
select BlaBla, BlaBlub
from OtherUser.Table
I can *not* *create* *a*...
Andreas Mosmann
|
08-21-2011 07:45 AM
Andreas Mosmann | 5 | 6 |
|  | We're in the midst of converting a system from Sybase to Oracle. This
involves converting Sybase stored procedures to Oracle procedures...
Tim Slattery
|
08-19-2011 04:50 PM
ddf | 3 | 4 |
|  | Tried using the data pump expdb from the command line on my 11g
database server and got the response that there is no command with
that name. ...
bontemps
|
08-19-2011 12:47 PM
joel garry | 1 | 2 |
|  | hi all,
i'm trying (with no success ) to build an oracle query , db is oracle
10, os windows 2008 64 bit
in a table called "location" i have...
Paolo Fossati
|
08-18-2011 05:06 PM
Andreas Mosmann | 14 | 15 |
|  | Hi,
in the SDO_UTIL - package of version 9.2 there is no way to convert from
geometry to well known text and back.
How can I do this?
My main prob...
Andreas Mosmann
|
08-16-2011 07:58 AM
Andreas Mosmann | 0 | 1 |
|  | I'm getting a PLS-00382 error and cannot decrypt the message.
I'm invoking a synonym of a function from a java program. This
database has recently...
Tim Slattery
|
08-13-2011 05:56 AM
Robert Klemme | 3 | 4 |
|  | PSD to XHTML Conversion - xhtmlchamps - provides psd to html, psd to
joomla, wordpress, drupal, cms, vbulletin, phpbb conversion, psd to
xhtml css...
xhtml champs
|
08-11-2011 11:49 AM
joel garry | 1 | 2 |
|  | 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 |