Oracle

Rollback
Is it the size of a tablespace that limits the rollback segment? I am trying to delete a large amount of data in a table and get an error that the rollback segment could not be created. ... 3 Dec 2005 10:45

RMAN command from script
Hello, I am trying to run the RMAN backup from a script (unix). i wrote a small script (sh) with following commands: rman TARGET / RUN { backup database; } when i run it gives errors RUN, backup commands not found. Do i need to store this file under some specific dir? am i missing something? Thanks ... 29 Nov 2005 11:33

ORA-01654
I am not very knowledgeable with Oracle and I am getting this error mesage when trying to save data into our MRP database. The transactions are issued using a front end to Oracle called Obvious MRP. I am running Oracle 8i on a Netware 5.1 Server. I have verified that I have 15GB of free space on my Volume. ... 29 Nov 2005 17:51

9i SAVEPOINT question
Folks, I haven't used savepoints before. We have a large data migration job and what I would like to do is to set a savepoint every (say) 1000 records so that if we should run into some error such as tablespace or temp segment or rollback space probs then we only lose the last (say) 1000 transactions. Will... 25 Nov 2005 15:05

sqlplus: create database
hello, sorry for my english. I try to create manually a database in Oracle 9i. I don't understand this step: CREATE TABLESPACE rollback DATAFILE '....' .... /***************/ CREATE ROLLBACK SEGMENT t0; ALTER ROLLBACK SEGMENT t0 ONLINE; SET TRANSACTION USE ROLLBACK SEGMENT t0; CREATE ROLLBACK SEGMENT r0 T... 22 Nov 2005 04:07

9i to 10g migration
OK, Im having a bit of difficulty here and hoping that the knowledgeable folks here at cdos can help me out: We are upgrading a 9iR1 database to 10gR2. At the same time, we are upgrading the hardware. Both platforms are Win2K. Right now, I am attempting to transfer the 9i instances to the 10g server. I had th... 22 Nov 2005 09:20

Oracle 10g R2 - Installation Error
Hi All - I am trying to install Oracle 10g on Solaris 9 OS and getting following error message. "ERROR: Unable to convert from "UTF-8" to "646" for NLS! Bus Error - core dumped" any idea .... Thanks for your help OraUser ... 22 Nov 2005 13:32

Freelists and Freelist Groups
Hello everybody, I'm experiencing "db file sequential/scattered waits" problems on a 8.1.7 database on a Windows server. I'm pretty new to Oracle Administration (and to DB Administration too), however it seems altering the number of "freelists" on specific tables and indexes could help. I've come to understan... 21 Nov 2005 04:14

FRM-40815: Variable Global.using-Transactional-Triggers does not exist
Hi everyone, I have in the Data Block Trigger ON-SEQUENCE-NUMBER Begin IF :Global.Using_Transactional_Triggers = 'TRUE' THEN User_Exit('orderid seq=MEDORDER_ID'); ELSE Generate_Sequence_Number; END IF; END; and, in the Initial Value property of the item tha... 16 Nov 2005 12:39

FRM-40508: Oracle error: unable to insert record
Hi, When I try to insert data in the Forms, appears the error FRM-40508: Oracle error: unable to insert record and automatically return to the logon page. I have a security table with different users, all of then have the same problem. Desc Seguridad; Name ... 15 Nov 2005 15:18