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

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

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

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

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]

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

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

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

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

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

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

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

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:

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

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

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:

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

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

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

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

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:

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

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: