BYTES in DBA_DATA_FILES shows NULL
Hi all, Can somebody explain how you can have NULL value for BYTES field in DBA_DATA_FILES? However, V$DATAFILE view shows the correct size under BYTES field. Query the SYS.X$KTFBHC, ktfbhccval field is equal to 1 for the offending datafiles. Tempting to bounce this production database later if that will fix the problem. How this happened... 1) ran script to add datafiles to existing tablespace: ALTER tablespace DATA_HISTORY add datafile '/u09/bilp/data_history_05.dbf' SIZE 1966088K, '/u06/bilp/data_history_06.dbf' SIZE 1966088K; 2) broke out of session 3) files were created on mount points /u09 and /u06 4) I saw that the files were created on UNIX, but Oracle still saw them a 0 bytes 5) I tried to resize the datafile's (received error - ORA-0600) --- alter database datafile '/u06/bilp/data_history_06.dbf' resize 100M 6) Took datafiles off-line 7) Tried to take them online, got a message that recovery is needed. Recovered datafiles 8) datafiles online, but still show 0 bytes 9) I was able to select and insert records into a table that uses this tablespace. Any idea will be greatly appreciated. Thanks, Gunawan Yuwono Oracle DBA Kansas City = Gunawan Yuwono Oracle DBA Kansas City, USA __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gunawan Yuwono INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 compile these object in oracle 8i
From Metalink: Problem Description: While querying "user_objects", under the "OBJECT_TYPE" column, you see a value of "UNDEFINED" on some of the objects. What does this signify? The "dba_objects" view shows LOB object type as UNDEFINED ; but "user_objects" view shows it correctly as LOB. If you run the query: select object_type from user_objects; you see some rows showing a value "UNDEFINED". What is the object type, when "user_objects" view shows object type as UNDEFINED? Solution Description: = Using the "object_id" column of "user_objects" for the UNDEFINED object, query obj$: select type# from sys.obj$ where obj#=object_id If type# returned is 42, then it is an object type that was previously called a SUMMARY object. This object is created when one runs: create materialized view ... command. [Or equivalently "create snapshot..." command. ] Explanation: The object is most likely a SUMMARY object associated with materialized views. References: === [BUG:1188948] SNAPSHOT IS SHOWING AS UNDEFINED IN DBA_OBJECTS IN RDBMS 8.1.6 IN SOLARIS 2.6 --- mala singh [EMAIL PROTECTED] wrote: Hi gurus I found that one of objects has status INVALID. The following are the output. OWNEROBJECT_NAMEOBJECT_TYPESTATUS -- -- --- SCOTTEMP_SNAPUNDEFINED INVALID How to correct this object. Please advice me. Thanks. -Mala _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mala singh 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). = Gunawan Yuwono Oracle DBA Kansas City, USA __ 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: Gunawan Yuwono 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: Error message Ora-01921
Just ignore this error message. It just means that the script's trying to create a role that already exists. You'll get some like this when you re-run your catalog.sql, etc. HTP. Gunawan Yuwono --- [EMAIL PROTECTED] wrote: 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). __ 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: Gunawan Yuwono 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 :..(
Try using FROMUSER/TOUSER when importing. HTP. Gunawan Yuwono --- [EMAIL PROTECTED] wrote: 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). __ 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: Gunawan Yuwono 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: DBMS_JOB -- urgent !!!
My $.02: There are two ways (that I know of): 1. The long way: create different jobs for each day like: INTERVAL = 'NEXT_DAY(TRUNC(SYSDATE),''MONDAY'') + 22/24' INTERVAL = 'NEXT_DAY(TRUNC(SYSDATE),''TUESDAY'') + 22/24' 2. Create another stored procedure and submit it as a job (Note I didn't test the following stored procedure, but you should get the idea): CREATE OR REPLACE PROCEDURE RUN_JOB AS v_day VARCHAR2(10); BEGIN SELECT TO_CHAR(SYSDATE, 'DAY') INTO v_day FROM dual; IF v_day != 'SUNDAY' THEN EXECUTE YOUR STORED PROCEDURE; END IF; EXCEPTION WHEN OTHERS THEN DO SOMETHING; RAISE; END; / And submit this stored procedure as a job everyday at 10 PM: INTERVAL = 'TRUNC(SYSDATE + 1) + 22/24' Does this make sense? HTP. Gunawan Yuwono Oracle DBA Kansas City, USA --- Pablo ksksksk [EMAIL PROTECTED] wrote: Hi list, I need to cron a job every day at 10pm except sundays, how do I acomplish this ? I need the INTERVAL field. I also need to cron another job every day except sundays an saturdays too, can you please help me with this? thanks in advance. ___ Do You Yahoo!? EnvĂa mensajes instantáneos y recibe alertas de correo con Yahoo! Messenger - http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20ksksksk?= 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). __ 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: Gunawan Yuwono 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: Package Vs Procedure
Use Package to store related objects together. Also, Package can have not only stored procedures, but also functions as well. HTH. Gunawan Yuwono --- Rajeshwari [EMAIL PROTECTED] wrote: What is the main difference between Package and procedure ? When a package should be created. Should related procedures be only grouped as a package or otherwise also it can be creaetd. TIA, Raji --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.226 / Virus Database: 108 - Release Date: 1/5/01 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajeshwari 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). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gunawan Yuwono 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).