| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | hi folks!
i've got the problem to maintain a oracle-text index wich is about 20gig
big. what kind of packages or tool should i use to reorganize...
Ludwig Maier
|
07-16-2003 02:46 AM
Ludwig Maier | 3 | 77 |
|  | I am designing a WEB BASED Accounting Software with ASP and SQL
Server. For this I need some help for the Database design. My design
is as...
Rushikesh
|
07-15-2003 06:05 PM
Erland Sommarskog | 3 | 74 |
|  | Have you known of a virus/worm designed to take
down an Oracle server (port 1521)?
On a very related note:
I captured and froze a virus/worm in my...
Ramon F Herrera
|
07-15-2003 04:34 PM
Karsten Farrell | 4 | 70 |
|  | Is there anyway of eliminating duplicate entries as the database loads data
using SQLLDR and/or .ctl (Control File)?
I use the following command...
gilgantic
|
07-15-2003 10:13 AM
tojo | 1 | 65 |
|  | Hi there,
I got problem when installing the Oracle 9iAS Infrastructure Release 2
(9.0.2.0.1) on a Windows 2000 server (SP4). The installation...
Eric Leung
|
07-15-2003 12:55 AM
Ashish Awasthi | 8 | 97 |
|  | Cannot find du_patch or dupatch on this system.
# /usr/sbin/sizer -v
Compaq Tru64 UNIX V5.1A (Rev. 1885); Wed Jan 9 13:46:01 GMT...
James Blackmore
|
07-11-2003 09:14 AM
andy thomas | 3 | 79 |
|  | "Herman Rollfs of Roelofs" <roelofs223 (AT) zonnet (DOT) nl> wrote
none
DJ
|
07-10-2003 09:36 PM
J Alex | 1 | 71 |
|  | "00374654" <member32966 (AT) dbforums (DOT) com> wrote
Try this:
select 6 * 7 from dual
Regards,
Paul
Paul Brewer
|
07-10-2003 08:19 PM
00374654 | 1 | 75 |
|  | Andy wrote:
http://otn.oracle.com/products/oracle9i/pdf/9idb_rel2_prod_fam.pdf
Hans Forbrich
|
07-10-2003 08:14 PM
Hans Forbrich | 0 | 59 |
|  | Hi,
I am curious if it is possible to create a temporary table (in Oracle
8.1.7) that would be visible to all sessions. Then its data would go
away...
Konstantin Kudin
|
07-10-2003 07:28 PM
Ryan | 3 | 68 |
|  | hello people,
i have a problem and i do not solved that.
my oracle database crashed irregular with following fault:
ORA-12500: TNS: Listener...
Sven Bauermann
|
07-10-2003 05:54 PM
Sven Bauermann | 2 | 90 |
|  | OS: Solaris 2.6
RDBMS: Oracle 8.1.7.0
CharSet: UTF8
CLOB Data: Chinese
We're experiencing a problem with a JDBC app that retrieves CLOBs from
a...
El Toro
|
07-10-2003 05:43 PM
El Toro | 2 | 95 |
|  | "Quarkman" <quarkman (AT) myrealbox (DOT) com> wrote
Except it don't necessarily work that way
SQL*Plus: Release 9.0.1.0.1 - Production on Thu...
dias
|
07-10-2003 05:36 PM
Niall Litchfield | 6 | 80 |
|  | i have written this query on test database works fine but when we
transfered both tables and the query to production we are getting two
different...
shankar72
|
07-10-2003 04:56 PM
shankar72 | 0 | 71 |
|  | Sybrand Bakker wrote:
Yes, that's it, random. So it seems that OAR is not my friend?!
Christoph Seidel
|
07-10-2003 04:48 PM
Christoph Seidel | 6 | 68 |
|  | Hi - we need to move a 9.2.0.3 database from one AIX server to
another. Both servers have similiar hardware and are at the same O/S
level...
Ian
|
07-10-2003 04:39 PM
Jeff W | 2 | 66 |
|  | "kiran" <kiran.news.invalid (AT) web2news (DOT) net> wrote:
Also OS, version, etc would be a nice touch..
TurkBear
|
07-10-2003 04:34 PM
Jeff W | 3 | 76 |
|  | I am trying to rewrite a generic data load procedure for large tables
to use the INDEX REBUILD statements instead of dropping and recreating
the...
aoshell2@yahoo.com
|
07-10-2003 04:06 PM
aoshell2@yahoo.com | 0 | 68 |
|  | HELP! Anyone SQL gurus out there please help me with a query update to
a table:
I need to update a column in a table sequentially base on the date...
Leigh
|
07-10-2003 04:03 PM
Leigh | 4 | 71 |
|  | I want to search for a string in the values of all the columns of all
the accessible Tables. How do you do that in SQL(sqlplus)?
qazmlp
|
07-10-2003 02:21 PM
Sybrand Bakker | 1 | 56 |
|  | We use a Windows2000-System with 3 processor. Most busy is one of this three
processors. What can I do, to share the resources more symmetrical. Is...
Georg Walk
|
07-10-2003 01:44 PM
Sybrand Bakker | 5 | 65 |
|  | Hello,
my application use jdbc thin driver to connect to my database. After
some time I got ORO-17401 Error with following description:
protocol...
Nowitzky
|
07-10-2003 01:42 PM
Sybrand Bakker | 1 | 523 |
|  | On Thu, 10 Jul 2003 09:35:09 -0700, Anne Nolan
<MUNGEanneDOTnolanNOSPAM (AT) rts-group (DOT) com> wrote:
Isolate the query and execute it...
Anne Nolan
|
07-10-2003 01:41 PM
Sybrand Bakker | 3 | 73 |
|  | On 10 Jul 2003 01:49:51 -0700, sameer_taiwade (AT) yahoo (DOT) com
(BadApple (AT) serpent (DOT) garden.edu) wrote:
As was to be expected of...
Sybrand Bakker
|
07-10-2003 01:39 PM
Sybrand Bakker | 0 | 62 |
|  | Oops
Oracle veriosn is 8174 on solaris, the largest table is 20GB but the
issue only started to happen when we introduce partition tables...
does...
Maria
|
07-10-2003 01:38 PM
Sybrand Bakker | 5 | 99 |
|  | Billy Verreynne <vslabs (AT) onwe (DOT) co.za> schreef in berichtnieuws
1a75df45.0307100151.9305c69 (AT) posting (DOT) google.com...
Really looks...
Anton Buijs
|
07-10-2003 12:46 PM
Anton Buijs | 0 | 74 |
|  | Hi gurus,
I'm facing this problem where I'm trying to backup using BAckup tool
in Oracle EM and it says file already exists. Can you please look...
Rukmini Madduluri
|
07-10-2003 12:20 PM
Anton Buijs | 2 | 88 |
|  | "apple" <applechu (AT) elifemall (DOT) com.tw> wrote
I've the same issue on Mandrake 9.1. I thought that the problem was due
to my distro.
How...
Kekko
|
07-10-2003 10:49 AM
Kekko | 0 | 114 |
|  | 8.1.7, linux
Situation: ran a relatively complex query using 6 bitmapped columns, on
a partitioned table, and with autotrace on. That's fine.
Prior...
Bricklen
|
07-10-2003 10:37 AM
Bricklen | 3 | 167 |
|  | This should be "connect / as sysdba" or "connect sys as sysdba".
This either means that Oracle is not running, or your environment is not
set up...
Brian Peasland
|
07-10-2003 08:50 AM
Brian Peasland | 0 | 59 |
|  | Hi all,
I have a "weird" question.
Do you have any experience how to encrypt the backup.
Let's say I have following backup method in use:
RMAN on...
Kalle
|
07-10-2003 08:48 AM
Brian Peasland | 1 | 59 |
|  | Oracle 8.1.7.3 on HPUX 11.0
In our third party developed app, I have noticed the response time
with packaged variables, or anything _not_ hardcoded,...
Steve Howard
|
07-10-2003 08:30 AM
Carlos | 3 | 69 |
|  | Hi, I know Fine-Grained Access Control permits adding a predicate to manage
access to objects.
The predicate is in the form of WHERE clause so you...
Bepy
|
07-10-2003 07:57 AM
Billy Verreynne | 4 | 65 |
|  | Hi,
We have a very dynamic database here that grows 400Gb per year. At
present we have a Compaq DL 380 with 2 Smart Array 5300 controllers
(each...
Andras Kovacs
|
07-10-2003 06:59 AM
Ralph | 1 | 63 |
|  | To help you You can use "Oracle Tool" on
http://membres.lycos.fr/pmscontact/
This tool tell you how tablespaces are used and to the tables/db
objects...
Rath.Yelandur
|
07-10-2003 04:58 AM
philippe | 2 | 77 |
|  | I have developed a VB application that uses Oracle 8i database for backend.
The database server is on the local network. From my development...
Alex
|
07-10-2003 04:49 AM
Billy Verreynne | 3 | 58 |
|  | Hi,
I hope my question is not *too* silly,
but I would like to know if there is any view inside the data dictionary
to see in real time which user...
Jan Gelbrich
|
07-10-2003 03:48 AM
Jan Gelbrich | 2 | 97 |
|  | Oracle8(TM) Server Concepts "
When a transaction runs out of space in the current extent and needs
to continue writing, Oracle finds an available...
michael ngong
|
07-10-2003 03:01 AM
Quarkman | 4 | 69 |
|  | Hi,
We're planning to consolidate a large amount of our production
database into one database. Our customers will be charged based on
their use of...
Hans de Git
|
07-09-2003 04:41 PM
dias | 5 | 74 |
|  | Hi gurus,
I have 3 tables and their fields as follows:
1) Buyers: BuyerID
2) Sellers: SellerID
3) BuyersSellers: BuyerID, SellerID,...
SPIDERMAN
|
07-09-2003 04:06 PM
SPIDERMAN | 0 | 73 |
|  | About undo blocks & read consistency
(to simplify assume everything happens in memory
-we're dealing with a well tuned DB-)
1/ OK let's say we have...
Spendius
|
07-09-2003 03:27 PM
Paul Brewer | 4 | 63 |
|  | In our shop one of the departments have a problem. Their current environment
stinks. Oracle 8i is running on obsolete machine with very slow pace....
Victor Slootsky
|
07-09-2003 02:49 PM
Paul Brewer | 2 | 74 |
|  | Does anyone know where can I find more info on the RS6000, or as a
matter of fact, does anyone knows where can I find classes regarding
this...
chilangomx
|
07-09-2003 01:52 PM
Sybrand Bakker | 3 | 81 |
|  | Andy wrote:
There is no single correct answer. You create an EUL that best fits the
needs of those doing the reports. If a single report crosses...
Daniel Morgan
|
07-09-2003 12:05 PM
Daniel Morgan | 0 | 69 |
|  | Hi:
when I try to connect to a computar I see this message error
"message file SP1<lang>.msb not found"
Ramon Mendiguren
|
07-09-2003 10:31 AM
Brian Peasland | 1 | 59 |
|  | Hi,
I'm getting the following errorwhen importing my database from one
server to another.
.. . importing table "WWW_POLL" ...
Dave Campbell
|
07-09-2003 09:53 AM
michael ngong | 3 | 288 |
|  | "Ryan Gaffuri" <rgaffuri (AT) cox (DOT) net> wrote
Hmm, well I have updated www.niall.litchfield.dial.pipex.com/index.htm (but
I only get the...
TurkBear
|
07-09-2003 09:14 AM
Niall Litchfield | 4 | 88 |
|  | I've been working for a while now to improve the import time of one of our
schemas. One table takes up most of the import time, and it has a...
Harry Boswell
|
07-09-2003 08:52 AM
Brian Peasland | 1 | 70 |
|  | Hello, can someone help me to solve this problem?
I've written a client Application.(just one file Client.java) Then I
created a .jar file for my...
Lucia
|
07-09-2003 08:15 AM
Lucia | 0 | 81 |
|  | Application is J2ee,
The searchstring is supplied in unicode.
Column is varchar and indexed.
The index is not used.
How to aliviate this ?
ben...
ben brugman
|
07-09-2003 07:10 AM
ben brugman | 4 | 63 |