RE: Password expiry bug 8.1.6
Hi all, I tried without word bear is not working too I tried password that contain numbers, special characters, not common english word the ORA-00988 still there :( Sinardy -Original Message- Sent: Wednesday, 9 May 2001 9:41 PM To: Multiple recipients of list ORACLE-L sinardy, I do not know the methodology that Oracle used is it's PASSWORD package. It is quite possable that the new password can not contain any portion of the login id. Try to use a password that does not use the word bear and post the results please. ROR mª¿ªm [EMAIL PROTECTED] 05/09/01 04:00AM Hi all, When I as DBA 1. create a profile with password expiry, ferification.. NULL 2. alter user with above profile 3. set date to force password expired as altered user 1. sqlplus teddy/bear 2. Changing password for teddy New password: newbear Retype new password: newbear ERROR-00988: missing or invalid password(2) I install patch bug1225 recomemded by oracle support, After follow the README.DOC sqlplus is updated and I shutdown and init 6 as DBA 1. drop profile test cacade; 2. @create profile 3. alter user teddy profile test; 4. set date to force password expired as altered user 1. sqlplus teddy/bear 2. Changing password for teddy New password: newbear Retype new password: newbear ERROR-00988: missing or invalid password(2) the error is still the same. Can someone help me please :( Thank you sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SORRY - I am a junk mail delete me
Out Look Rule wizard testing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: FK Constraints
Hi, I'm a beginner too, but without a table FK (relation) how you make a join statements ? Do you normalize your tables ? The relation model is concerned with logical maters only, not physical matters. It addresses three aspects of data, data stucture (object) data integrity, and data manipulation. The Object (Tables), Integrity portion has to do with PK and FK Data manipulation (SELECT, JOIN etc) In addition I think with the Normalized database you will have smaller database and easy to maintain (base on object). -Original Message- akhil Sent: Tuesday, 20 March 2001 2:05 AM To: Multiple recipients of list ORACLE-L Hi all: We have a situation where are no relationships are defined at the database level. i.e no foreign keys constraints have established at the Database. The application is still at the Development Stage. Everything is controlled at the application level. I as the DBA appose this design for Data security and also cannot reverse engineer from the tables into Designer. Can you please share you pros / Cons. Thanks __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ramani akhil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Install Oracle on Solaris SOS
Hi guys, This machine is use for my Oracle script testing and other small research. I have a Sun machine : - UltraSPARC -IIi 300 MHz - 128 Mb (Oracle recommend 256) - 4 Gig HDD I install Solaris 7 with : /- 1200 MB (small ??) /appl- 2??? MB (all of the available) swap - 512 MB (small ??) /export/home - 512 MB (I don't think this need to be change) - I choose "Entire Distribution plus OEM support" Solaris finally install corectly and run perfectly no error and quite fast CDE is OK, "bla bla bla I think everything should be ok now" Then I install Oracle 8.1.6 Enterprise Edition - without intermedia option (because I don't any multi media files to store) when I run dbassist to create my db - everything remain default (all those tablespace size and sga and all) - I save the output to script first insteat just create my db directly. I run that script 3 days ago and still running now ? Can some one help me please, because this is my second time install Oracle (same version) in this machine it's only took me 4 hours to run createDB script at the first try installation. Help me please, Thank you Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle installation
Hi, Anyone tried install Oracle8i in Solaris with 128 Mbyte of memory ? Is a stand alone server Oracle 8.1.6, not a production, is not hang but more than 1 day to finish create a database ??? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: wrong tablespace used
Hi Gunawan, unfortunetly I do shutdown normal, and when I try to SVRMGRL startup mount (startup only it give me error because can not found ts1.dbf) ALTER DATABASE CREATE DATAFILE '/appl/OraHome/oradata/MYDB/ts1.dbf' AS '/appl/OraHome/oradata/MYDB/ts1.dbf'; It gave me Statement processed and when I do ( RECOVER DATAFILE '/appl/OraHome/oradata/MYDB/ts1.dbf'; ORA-00279: change 199725 generated at 03/01/2001 15:24:10 needed for thread 1 ORA-00289: suggestion : /appl/OraHome/dbs/arch1_7472.dbf ORA-00280: change 199725 for thread 1 is in sequence #7472 Specify log: {RET=suggested | filename | AUTO | CANCEL} I just press enter for the RET It gave me ORA-00308: cannot open archived log '/appl/OraHome/dbs/arch1_7472.dbf' ORA-27037: unale to obtain file status SVR4 Error: 2: No such file or directory Additional informatoin: 3 Thank you for your help -Original Message- Sent: Friday, 9 March 2001 10:12 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; 'lzDBA' First of all, to recover the ts1 tablespace, do something like: ALTER DATABASE CREATE DATAFILE '/appl/OraHome/oradata/MYDB/ts1.dbf' AS '/appl/OraHome/oradata/MYDB/ts1.dbf'; RECOVER DATAFILE '/appl/OraHome/oradata/MYDB/ts1.dbf'; Now, on the other question, are you sure there's not another table called EMP owned by another USER like SCOTT? Query dba_segments view: SELECT owner, segment_name, tablespace_name FROM dba_segments WHERE segment_name = 'EMP'; My $0.02. HTP. Gunawan Yuwono Oracle DBA Kansas City, USA --- [EMAIL PROTECTED] wrote: Hi guys, I have some understanding problem. 1. I create a new tablespace create tablespace ts1 datafile '/appl/OraHome/oradata/MYDB/ts1.dbf' size 15M autoextend on default storage initial 128K next 128K minextents 1 maxextents 8192 pctincrease 0 ); 2. I create a new user CREATE USER teddy IDENTIFIED BY bear DEFAULT TABLESPACE ts1 TEMPORARY TABLESPACE temp1 (created too) QUOTA UNLIMITED ON ts1 ; 3. teddy create a table: CREATE TABLE emp ( empno NUMBER(3)CONSTRAINT emp_pk PRIMARY KEY, fname VARCHAR2(20) CONSTRAINT emp_fname_nn NOT NULL, lname VARCHAR2(20) CONSTRAINT emp_lname_nn NOT NULL, bdate DATE CONSTRAINT emp_dbate_nn NOT NULL, CONSTRAINT check_empno CHECK (empno BETWEEN 0 AND 999) ); why this table is not store inside ts1 ? as teddy was created with the default tablespace = ts1 do I have to specify tablespace name in the create table emp script ? this table is store inside SYSTEM tablespace 3. Now I made a stupid move "rm .../MYDB/ts1.dbf my solaris 2.7 login profile don't have the trash can (undelete) so I can not undelete I try to recreate my tbs1 by using above script (step 1) but oracle said tbs1 is allready exists. what should I do now. can I recover my tbs1.dbf and move teddy object into tablespace tbs1 from system tablespace ? Thank You guys, sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to drop a datase ??
Hi guys, I deleted one of my datafile, and I can't recover it back because I have no backup. Can I drop my entire database without reinstalling my Oracle8i ?? Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to drop a datase ??
sorry guys I got the answer dbassist -Original Message- Sent: Monday, 12 March 2001 9:28 AM To: [EMAIL PROTECTED]; 'lzDBA' Hi guys, I deleted one of my datafile, and I can't recover it back because I have no backup. Can I drop my entire database without reinstalling my Oracle8i ?? Thank you Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to drop a datase ??
Yes those records are very important, how to save them without re-entering those data (oh man they are alot of data)? -Original Message- Setiawan Sent: Monday, 12 March 2001 10:30 AM To: Multiple recipients of list ORACLE-L Hi , is the datafile very very important to you and filled with many records ? if the datafile can be ignored, you dont have to drop your database. just tell to the database that the lost datafile is explicitly dropped. first , you have to STARTUP NOMOUNT database , then in SVRMGR type : ALTER DATABASE mytestDB DATAFILE '/oradata/mydatafile.dbf' OFFLINE DROP. and then , ALTER DATABASE OPEN. HTH, =bambang= Bambang Setiawan [EMAIL PROTECTED] 03/12/01 08:30 Hi guys, I deleted one of my datafile, and I can't recover it back because I have no backup. Can I drop my entire database without reinstalling my Oracle8i ?? Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambang Setiawan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
connect internal password ?
Hi, What can I do when connect internal ask for password ? can I disable this password ? Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
wrong tablespace used
Hi guys, I have some understanding problem. 1. I create a new tablespace create tablespace ts1 datafile '/appl/OraHome/oradata/MYDB/ts1.dbf' size 15M autoextend on default storage initial 128K next 128K minextents 1 maxextents 8192 pctincrease 0 ); 2. I create a new user CREATE USER teddy IDENTIFIED BY bear DEFAULT TABLESPACE ts1 TEMPORARY TABLESPACE temp1 (created too) QUOTA UNLIMITED ON ts1 ; 3. teddy create a table: CREATE TABLE emp ( empno NUMBER(3)CONSTRAINT emp_pk PRIMARY KEY, fname VARCHAR2(20) CONSTRAINT emp_fname_nn NOT NULL, lname VARCHAR2(20) CONSTRAINT emp_lname_nn NOT NULL, bdate DATE CONSTRAINT emp_dbate_nn NOT NULL, CONSTRAINT check_empno CHECK (empno BETWEEN 0 AND 999) ); why this table is not store inside ts1 ? as teddy was created with the default tablespace = ts1 do I have to specify tablespace name in the create table emp script ? this table is store inside SYSTEM tablespace 3. Now I made a stupid move "rm .../MYDB/ts1.dbf my solaris 2.7 login profile don't have the trash can (undelete) so I can not undelete I try to recreate my tbs1 by using above script (step 1) but oracle said tbs1 is allready exists. what should I do now. can I recover my tbs1.dbf and move teddy object into tablespace tbs1 from system tablespace ? Thank You guys, sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
table_privileges
Hi guys, Do you know what is the value "A" represented inside "coloum insert_priv" in "table_privileges"? Thank You -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: How to backup entire db?
Hi, Our company's librarian search for that CD now, It's that true we only can use RMAN with OEM, can I start learning to use RMAN without installing OEM ? Because I have to backup my company db Thank you in advance -Original Message- Sent: Wednesday, 7 March 2001 5:22 PM To: '[EMAIL PROTECTED]' Hi. No, its called Oracle Enterprise Manager, it normally comes in the box of cd's that the Oracle8i Enterprise Edition comes in. If not you will have to order it from Oracle, but it is worth having it. * Clinton S. Naud * Head systems administration * Tel: 011 685 4304 * Fax: 011 685 4303 * Cell: 082 377 1726 * E-mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 07, 2001 11:17 AM To: [EMAIL PROTECTED] Hi, Is the CD call Oracle8i Enterprise Edition ? -Original Message- Sent: Wednesday, 7 March 2001 5:06 PM To: '[EMAIL PROTECTED]' Hi. OEM is on seperate disks. Have you installed it before? The disks do normally come with Oracle database cd's. Check to see if you have the disks and then mail me if you do. Clint * Clinton S. Naud * Head systems administration * Tel: 011 685 4304 * Fax: 011 685 4303 * Cell: 082 377 1726 * E-mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 07, 2001 9:56 AM To: Multiple recipients of list ORACLE-L Dear Clinton and other Oracle Gurus, Can you lead me how to start OEM, do I need to reinstall my oracle because I was not choosing sever manager option in my first installation. Thank you -Original Message- Naude Sent: Wednesday, 7 March 2001 2:55 PM To: Multiple recipients of list ORACLE-L Use the OEm backup and recovery option. You can create backup databases for fall over. OEM also does exports as well as database backup (control files and archive logs etc). Clint * Clinton S. Naud * Head systems administration -Original Message- Sent: Wednesday, March 07, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Hi guys, Do you guys have any idea.. How can I backup my entire Oracle8i system so that it allow me to recover without reinstalling Oracle8i (reconfigure) after my hardisk crash? What kind of os files I need to backup and I plan using tape. or may be CD-R Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Clinton Naude INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Script for heaven
Hi guys, I'm new in Oracle8i for Solaris 2.7, I'm not familiar with those data dictionary view, do you have any scripts to share such as to display redologs, tablespaces, earlier potential problems ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Script from heaven
Hi guys, I'm new in Oracle8i for Solaris 2.7, I'm not familiar with those data dictionary view, do you have any scripts to share such as to display redologs, tablespaces, earlier potential problems detection? Thank you so much.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Script for oracle8i on solaris 2.7
Hi Mandar and other Oracle gurus, As DBA, I don't have the table called "dict_comments" do you guys have any ideas how to create one and populate with the correct information the tables? or may be I have to run an oracle's script to get that table ? -Original Message- Ghosalkar Sent: Thursday, 8 March 2001 10:45 AM To: Multiple recipients of list ORACLE-L select * from dict_comments -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 8:26 PM To: Multiple recipients of list ORACLE-L Subject: Script for heaven Hi guys, I'm new in Oracle8i for Solaris 2.7, I'm not familiar with those data dictionary view, do you have any scripts to share such as to display redologs, tablespaces, earlier potential problems ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Script to display user infromation
Hi guys, Do you have any scripts to display all created users with those roles granted and the roles information. currently I am using table_privileges role_tab_privs Thank you, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: can not mount database Exclusively
try connect internal first -Original Message- Setiawan Sent: Tuesday, 6 March 2001 1:25 PM To: Multiple recipients of list ORACLE-L Hi guys, I'm a beginner in Oracle. When I try to startup database via SVRMGR , there's error : "can not mount database Exclusively" Anybody knows why this thing happen ? How you fix it ? Thanks in Advance :) Bambang Setiawan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambang Setiawan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: No record in import help me please :..(
Hi guys, Thank You Durinda.Jones Don.Jerman Dave Weber Gillies Garry Raghu Kota Ruth Gramolini Mohan, Ross And to all readers.. What I am doing now is to try write my own backup script and test it in my stand alone Sun Ultra 10 with Solaris 2.7 and Oracle 8.1.6 Thank you guys, for giving me solution, "SHOW = N" and "DESTROY=N" it is work 7 records was imported into the table. Now I try to import my previous myemp.dmp after teddy "drop table emp" my import parameters as at point 8. 1. In my Oracle I have accounts : - teddy/bear (normal user can create) - sun/solaris (granted DBA role) 2. I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct) 3. TEDDY created a table EMP with 7 records 4. I am using Sun account to export teddy table: inside my params.dat : FILE=/export/home/dba/myemp.dmp TABLES=(teddy.emp) ROWS=Y GRANTS=Y COMPRESS=Y I export with this params.dat : exp sun/solaris parfile=/export/home/dba/myemp.dmp I've got messsges : . . exporting table EMP 7 rows exported 5. I check the file is exist and with -rw-rw-rw 1 dbadmin 3072 Mar (time) myemp.dmp 6. I chmod a+x myemp.dmp 7. teddy delete emp table : delete emp 7 rows deleted 8. when as sun I try to import : inside my imp_params.dat : FILE=/export/home/dba/myemp.dmp FROMUSER=TEDDY TOUSER=TEDDY TABLES=(emp) IGNORE=Y - because the table is not exists ?? GRANTS=Y ROWS=Y COMMIT=Y I import imp sun/solaris parfile=imp_params.dat 9. the messeges that I got : . import TEDDY's Object . . importing table "EMP" IMP-00019: row rejected due to ORACLE error 1 IMP-3: ORACLE error 1 encountered ORA-1: unique constraint (TEDDY.EMP_PK) violated Column 1 11 Column 2 Don Column 3 McIntyre Column 4 03-Jun-1972:00:00:00 IMP-00019: row rejected due to ORACLE error 1 IMP-3: ORACLE error 1 encountered ORA-1: unique constraint (TEDDY.EMP_PK) violated Column 1 12 Column 2 Micheal Column 3 Jackson Column 4 25-Jun-1988:00:00:00 Import terminated successfully with warnings. 10. When teddy select * from emp; ERROR at line 1 ORA-00942: table or view does not exist Can someone help me please... please ??? :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Durinda.Jones INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
No record in import help me please :..(
Hi guys, 1. In my Oracle I have accounts : - teddy/bear (normal user can create) - sun/solaris (granted DBA role) 2. I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct) 3. TEDDY created a table EMP with 7 records 4. I am using Sun account to export teddy table: inside my params.dat : FILE=/export/home/dba/myemp.dmp TABLES=(teddy.emp) ROWS=Y GRANTS=Y COMPRESS=Y I export with this params.dat : exp sun/solaris parfile=/export/home/dba/myemp.dmp I've got messsges : . . exporting table EMP 7 rows exported 5. I check the file is exist and with -rw-rw-rw 1 dbadmin 3072 Mar (time) myemp.dmp 6. I chmod a+x myemp.dmp 7. teddy delete emp table : delete emp 7 rows deleted 8. when as sun I try to import : inside my imp_params.dat : FILE=/export/home/dba/myemp.dmp SHOW=Y IGNORE=N GRANTS=Y ROWS=Y DESTROY=Y COMMIT=Y I import imp sun/solaris parfile=imp_params.dat 9. the messeges that I got : ... ... .skipping table "EMP" ... ... ... ... Import terminated successfully without warnings. 10. When teddy select * from emp; 0 rows selected Can someone help me please... please ??? :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Error message Ora-01921
Hi guys, I am using sys account to run catexp.sql there is an error : ERROR at line 1: ORA-01921: role name 'IMP_FULL_DATABASE' conflicts with another user or role name when I try to run it with my dba account it cause more error Thank You -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
svrmgrl vs sys account
Hi, I am a beginner DBA could you tell me what is the diffrent: create user /tablespace or else using svrmgrl and sys account oh ya.. I'm using Oracle8i Thank you very much -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Rollback segment
Hi, Anyone have idea, how Oracle8i make used of multiple rollback segments to reduce system contention? I am currently using 4 rollback segments what will happen if 3 of them are offline? :( Thanxs, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).