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,

Password expiry bug 8.1.6

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-009

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 manipulati

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

Solaris tape problem ?

Hi guys, Can someone tell me how to create a directory in a tape (DDS3) ? because I have multiple directory to backup. 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) 5

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: Off Topic?

Petrol Kiosk ;) -Original Message- Sent: Tuesday, 13 March 2001 5:13 AM To: Multiple recipients of list ORACLE-L Can anyone tell me about the job options in United Arab Emerates? Please email me privately. Thanks! __ Do You Yahoo!? Yahoo

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

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 wi

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 O

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 Ser

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 Sta

RE: Corrupted dbf files ?

The Solaris 7 System includes - SunOS 5.7 operating system - ONC+ (open network computing) - CDE New version of Solaris after 2.5 is 2.6 and then 7 (official versioning is 7 but by de facto they called it 2.7) That's all I know -Original Message- Sent: Friday,

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 minexten

Corrupted dbf files ?

Hi guys, I exported my database 8.1.6 on Solaris 2.7 with full = y, can import my full.dmp if dbf file corrupted ? This is not emergency just for testing how usefull my exported file.. Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET:

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

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 N

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: Thu

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 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 PROT

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: '[EMAI

RE: How to backup entire db?

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 ORAC

How to backup entire db?

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 o

Connected users ??

Hi guys, It is possible to list all user that currently connected to my Oracle8i ? and what is the command or script or source of information ? Thank you, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858

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 sol

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

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 us

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:/

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: [EMAI

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