Re: Convert Access to Oracle
I use Oracle805 EE , there is tool called Oracle Migration Assistant for Microsoft Access. which can migrate Access DB to Oracle . With this tool You can only migrate from Access 97 or lower to Oracle . if your Access DB made with Access2000 , you can convert it first to lower version with Tools Menu. there is trick to send Access data to Oracle. first , from Access , you export all table to MS Excel then you save as delimited text the excel file . second , you make empty table in Oracle with its structured like the Access table complete with all of its constraints.. third , you can use Oracle SQL*Loader to load the data . off course you have to use SQL*Loader control file and datafile with customized fashion from the excel delimited text file. hope this help , <> Bambang Setiawan <> >>> [EMAIL PROTECTED] 08/10/01 08:06 >>> Lisa, i thought there was one on the oracle(or maybe it was technet) website. joe > "Koivu, Lisa" wrote: > > Good morning all - > > Does anyone know of a free Access to Oracle conversion tool? I > suppose I could do CTAS but I'd like to avoid that type of monkeying > around if I can. > > Thanks > > Lisa Koivu > Oracle Database Administrator > Fairfield Resorts, Inc. > 954-935-4117 -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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).
Re: Inserting a Record into a Table
hi, try INSERT INTO yournewtable SELECT * FROM youroldtable; if you want to modify value for particular field you can use oracle functions in SELECT clause. in example below I use string function called SUBSTR : SQL> insert into newdept 2 select deptno,SUBSTR(dname,1,3) ,loc from olddept; SQL> select * from olddept; DEPTNO DNAME LOC - -- - 10ACCOUNTING NEW YORK 20RESEARCH DALLAS 30SALES CHICAGO 40OPERATIONS BOSTON SQL> select * from newdept; DEPTNO DNA LOC - -- - 10 ACC NEW YORK 20 RESDALLAS 30 SAL CHICAGO 40 OPEBOSTON hope this help : ) <> Bambang Setiawan <> >>> [EMAIL PROTECTED] 08/03/01 06:50 >>> Can you insert an entire record into a table without having to specify each individual field ?? I need to copy multiple rows in a table after I have modified its key. I do not want to have to specify each field. Is there a way just to select the record, modify the particular field, and then insert the record... WITHOUT having to list all the fields or each individual value ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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).
RE: Version of personal oracle that runs on Window ME
I use Personal Oracle7 on My WinMe , It works fine <> Bambang Setiawan <> >>> [EMAIL PROTECTED] 07/31/01 11:36 >>> As of Now, Oracle is not Avaialble on ME. I have also asked from Tom kyte (Oracle Corp. Technical Consultant). U can find lots of queries on asktom.oracle.com. BTW if u get any success pl. let me know. Thanks, Harsh -Original Message- Sent: Tuesday, July 31, 2001 6:31 PM To: Multiple recipients of list ORACLE-L Hi All, Does anyone know where I can get/download copy of Oracle that runs on Window ME I downloaded 8i for 98 but BSOD. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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: Harsh Agrawal 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).
Re: Steve Adams's Removal
I agree with you Venkat, I'm afraid that we lost tuning expert, <<< "C.S.Venkata Subramanian" <[EMAIL PROTECTED]> 5/28 1:15p >>> Hi, I was not able to get head or tail out of this posting. But from the subject I figured out that Steve Adams is removed from this list. If so, Still must reconsider the removal. Steve has guided us so many times with his expert advice and he has also shared his vast and past experiences. Regards Venkat Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).
Re: forget sys password ?
hi , just connect as Internal in svrmgr then alter user sys identified by newpassword still forget password Internal ? use Orapwd ... <> Bambang Setiawan <> >>> "Sinardy Xing" <[EMAIL PROTECTED]> 05/18/01 03:30PM >>> Hi all, What can I do, if I forget my testing server's sys account password ? I keep sys and system passwords together, and I lost that document. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
Re: Do you know any good concentrated short cut book for Orac
you can try 'Oracle8 bible ' not too theorytical , a lot materials straight to practice , but very poor in discussing tuning performance. HTH, bambang <> Bambang Setiawan <> >>> SuzyV <[EMAIL PROTECTED]> 05/11/01 04:17AM >>> I've always thought that buying any of the "dummies" books was self-hating :) "Boivin, Patrice J" wrote: > > "Oracle for Dummies" - my friends and I laughed pretty hard when we first > saw that at the computer store, we were studying for the DBA exam at the > time: > How could a dummy make Oracle run... > > : ) > > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 3:33 PM > To: Multiple recipients of list ORACLE-L > Subject:Re:Do you know any good concentrated short cut book > for Orac > > Waleed, > > Are you talking about something for a beginer? There is always > the Oracle > for Beginners, Oracle for Dummies, and Beginers guid to Oracle > books. They're > available from Barnes&Nobel, Borders, and Amazon.com. > > Dick Goulet > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Boivin, Patrice J > 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: SuzyV 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).
Re: list table in schema
Halo Jim,
use table DBA_TABLES :
in SQL plus just type :
break on owner skip 1
select owner , table_name from dba_tables ;
or you can use 'WHERE' clause to exclude user SYS and SYSTEM
select owner , table_name from dba_tables
where
owner not in ('SYS','SYSTEM') ;
hope this helps ,
=bambang=
<> Bambang Setiawan <>
>>> "Jimmy Lim" <[EMAIL PROTECTED]> 05/05/01 12:00PM >>>
hello
how can i list all table in a schema ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jimmy Lim
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).
how to install Oracle Developer2000 on Windows98 ?
dear listers, any body knows how to install Oracle Developer2000 on Windows98 ? I installed it on my machine but I can't even connect to my database thanks in advance , regards, bambang <> 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).
Re: Entity Relationship diagrams
Hi, You can try a software from embarcadero , perhaps www.embarcadero.com , ( if I'm not wrong spell it ) ... or go to www.platinum.com to download Erwin ... hth, bambang <> Bambang Setiawan <> >>> "Ranganath K" <[EMAIL PROTECTED]> 04/17/01 03:50PM >>> Dear DBA Gurus, I have around 30 tables for which the columns, datatypes, size of each datatype, referential integrity constraints is decided. I need to draw E-R diagram linking each table with one or many tables. I am looking for a tool which will draw the diagram for me if I provide the column names, its datatypes, referential integrity constraints etc. Is there any free tool which will do this for me? If not, how do I do this? Any URLs or links or documents will be very much helpful. Any help in this regard will be very much appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K 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).
testing RMAN == 2 databases in 1 Machine
Dear Listers , I want to try using RMAN in just 1 machine with 2 databases ( client and target ) . I have followed every single step in manual , but there's always error ... Do we must run RMAN in 2 machines ? Thank a lot in advance : ) =bambang= <> 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).
Re: Errors in Oracle
Hi , just download a help file from www.oraxcel.com the file named SQL*Code. they have make it easy to browse and to solve... HTH, bambang <> Bambang Setiawan <> >>> <[EMAIL PROTECTED]> 03/29/01 05:20 >>> Anyone who can give me a link to a website, where I can see the description of the Ora-errors I get in sql statements and pl/sql-code, so I understand what the error is about and how to fix it. Roland Sköldblom -- 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).
2 Databases Problem
Dear Listers , yesterday , I've created 2nd database for Test using Database Assistant on NT. and I also shutdown my Test Server later. this morning , when I tried to Startup both of My DB , I found ORA-01102 error :can not mount database exclusively. My 1st database is able to be started in OPEN mode , but I can not startup my 2nd database . please help me , how to solve it... Thanks a lot in advance : ) =bambang= <> 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).
Re: imp
Hi Joseph , As far as I know when we import/export DB , there is something called "parameter conflict consideration" or something like that . parameter SHOW = Y will tell to Oracle that we want the List of syntax ONLY. the other parameter , FULL , will tell to Oracle that we want the records from Export File. so , issuing parameter SHOW and FULL cause a conflict. HTH, =bambang= <> Bambang Setiawan <> >>> "Leyden, Joseph" <[EMAIL PROTECTED]> 03/23/01 05:34 >>> I've exported the entire database and while using the interactive imp (import), would also like to get a listing. Is this possible? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph 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).
Tuning Matter ==> Parameter PCT_USED in a Table
Dear Listers, I've download a presentation talking about Calculating PCT_USED . the formula is quite simple : PCT_USED + PCT_FREE < 100 PCT_USED = PCT_FREE + 1 row size but I have no idea to calculate the size of 1 row in a table . is there anyone who knows to calculate it ? or any alternative formula to calculate PCT_USED ? Thanks a lot in advance : ) =bambang= <> 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).
Re: Script to know the size of each table in a schema ?
Thanks a lot Ruth , It works fine... : ) sincerely yours, =bambang= <> Bambang Setiawan <> >>> "Ruth Gramolini" <[EMAIL PROTECTED]> 03/16/01 08:00 >>> To get the number of bytes in each table in a schema you can use the following: select segment_name, sum(bytes) from dba_segments where segment_type='TABLE' and owner='SCHEMA_NAME' group by segment_name This gives bytes but you can get blocks, extents, or bytes from dba_segments. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 16, 2001 3:56 AM Ya , you're right : ) but I think I have to appreciate all the answers for my question ... one replied that DBA_SEGMENTS can be used to calculate the size of each table in a schema ( in MBytes ). It's big clue , I still found difficulty in its implementation... Do you have the script Tapas ? please let me know : ) HTH, =bambang= <> Bambang Setiawan <> >>> tapas dutta <[EMAIL PROTECTED]> 03/16/01 02:25 >>> HEY, THERE IS SOMETHING WRONG IN THE UNDERSTANDING. BY THE MENTIONED SCRIPT ONE CAN ONLY KNOW THE NO. OF ROWS PRESENT IN EACH TABLE FOR THAT PARTICULAR SCHEMA NOT THE SIZE. IS N'T IT. -Original Message- Sent: Friday, March 16, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Hi , Thanks a lot for your help , Ruth : ) sincerely yours, =bambang= <> Bambang Setiawan <> >>> "Ruth Gramolini" <[EMAIL PROTECTED]> 03/15/01 11:40 >>> You can spool the output of this SQL and run it. select 'select '''||table_name||''', count(*) from '||table_name||';' from dba_tables where owner='SCHEMA_OWNER'; To get the table name in the output you have to put 3 ' s before and after the first ||table_name||. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 14, 2001 9:25 PM Dear Listers, I just made script to know the size of datafile in a tablepace , but I still have no idea to make a script to know the size of each table in a schema ? is there anyone who has the script ? furthermore , I need some information about relationship diagram which describe the relation among tables/view to calculate storage of objects ( i.e tablespace , datafile , segment , extent ) . thanks in advance : ) =bambang= <> 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: Ruth Gramolini 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: tapas dutta 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: [
RE: Script to know the size of each table in a schema ?
Ya , you're right : ) but I think I have to appreciate all the answers for my question ... one replied that DBA_SEGMENTS can be used to calculate the size of each table in a schema ( in MBytes ). It's big clue , I still found difficulty in its implementation... Do you have the script Tapas ? please let me know : ) HTH, =bambang= <> Bambang Setiawan <> >>> tapas dutta <[EMAIL PROTECTED]> 03/16/01 02:25 >>> HEY, THERE IS SOMETHING WRONG IN THE UNDERSTANDING. BY THE MENTIONED SCRIPT ONE CAN ONLY KNOW THE NO. OF ROWS PRESENT IN EACH TABLE FOR THAT PARTICULAR SCHEMA NOT THE SIZE. IS N'T IT. -Original Message- From: Bambang Setiawan [SMTP:[EMAIL PROTECTED]] Sent: Friday, March 16, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Subject:Re: Script to know the size of each table in a schema ? Hi , Thanks a lot for your help , Ruth : ) sincerely yours, =bambang= <> Bambang Setiawan <> >>> "Ruth Gramolini" <[EMAIL PROTECTED]> 03/15/01 11:40 >>> You can spool the output of this SQL and run it. select 'select '''||table_name||''', count(*) from '||table_name||';' from dba_tables where owner='SCHEMA_OWNER'; To get the table name in the output you have to put 3 ' s before and after the first ||table_name||. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 14, 2001 9:25 PM Dear Listers, I just made script to know the size of datafile in a tablepace , but I still have no idea to make a script to know the size of each table in a schema ? is there anyone who has the script ? furthermore , I need some information about relationship diagram which describe the relation among tables/view to calculate storage of objects ( i.e tablespace , datafile , segment , extent ) . thanks in advance : ) =bambang= <> 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: Ruth Gramolini 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: tapas dutta 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 --
Re: Script to know the size of each table in a schema ?
Hi , Thanks a lot for your help , Ruth : ) sincerely yours, =bambang= <> Bambang Setiawan <> >>> "Ruth Gramolini" <[EMAIL PROTECTED]> 03/15/01 11:40 >>> You can spool the output of this SQL and run it. select 'select '''||table_name||''', count(*) from '||table_name||';' from dba_tables where owner='SCHEMA_OWNER'; To get the table name in the output you have to put 3 ' s before and after the first ||table_name||. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 14, 2001 9:25 PM Dear Listers, I just made script to know the size of datafile in a tablepace , but I still have no idea to make a script to know the size of each table in a schema ? is there anyone who has the script ? furthermore , I need some information about relationship diagram which describe the relation among tables/view to calculate storage of objects ( i.e tablespace , datafile , segment , extent ) . thanks in advance : ) =bambang= <> 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: Ruth Gramolini 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).
Re: Can not open DB :(
I think your data file is corrupt , you have to drop the data file it first before you open database . just MOUNT the database , then issue this command : SVRMGR> ALTER DATABASE yourDB DATAFILE 'D:\ORACLE\ORADATA\VTP2\RBS01.DBF' OFFLINE DROP then you can issue ' Alter Database Open ' the problem become easier if you have backup of that datafile . never forget to make backup : ) =bambang= <> Bambang Setiawan <> >>> "andrey" <[EMAIL PROTECTED]> 03/15/01 05:15 >>> Dear list ! please help : SVRMGR> alter database open ; alter database open * ORA-01110: data file 2: 'D:\ORACLE\ORADATA\VTP2\RBS01.DBF' ORA-01115: IO error reading block from file 2 (block # 1) ORA-27070: skgfdisp: async read/write failed OSD-04016: Error queuing an asynchronous I/O request. O/S-Error: (OS 23) Data error (cyclic redundancy check). SVRMGR> What do i do ? -- 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).
Script to know the size of each table in a schema ?
Dear Listers, I just made script to know the size of datafile in a tablepace , but I still have no idea to make a script to know the size of each table in a schema ? is there anyone who has the script ? furthermore , I need some information about relationship diagram which describe the relation among tables/view to calculate storage of objects ( i.e tablespace , datafile , segment , extent ) . thanks in advance : ) =bambang= <> 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).
new in Developer 2000
Dear Listers, I plan to install Oracle Developer 2000 on my NT which Oracle Database Server 8.0.5 Installed. I installed Oracle DB server in D:\orant which better directory I have to choose for Dev2000 installation ? thanks in advance : ) =bambang= <> 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).
Re: Major upgrade
Hi , you can try http://oradoc.photo.net , offcourse the comprehensive one is www.oracle.com HTH, =bambang= <> Bambang Setiawan <> >>> "Streeter, Lerone A LBX" <[EMAIL PROTECTED]> 03/13/01 11:05 >>> hello, we're in the process of upgrading an application, right now it's a 16-bit client application with the backend running on MS-SQL 6.0, windows NT 4 server. the company we're working with is willing to upgrade to 32-bit code oracle 8x, still running on NT; probably 2000. i'm looking for some starter information since i'll probably be the DBA. i've downloaded oracle 8i personal and a couple of PDFs, i'm wondering if you can point me to some starter information? is there a "first read" or something similar? === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED] === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Streeter, Lerone A LBX 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).
Re: .dmp and space used
Hi ,
from Oracle8 Bible , chapter Backup and Recovery , sub chapter Export ,
I found that we can estimate the maximum space that Export file needed :
select sum(BYTES)
from User_segments
WHERE SEGMENT_TYPE in ('TABLE' , 'INDEX' , 'LOBINDEX','LOBSEGMENT')
SUM(BYTES)
40126464
So , you can estimate how many space Your import file will take in your DB just before
you export the tables
HTH ,
=bambang=
<> Bambang Setiawan <>
>>> <[EMAIL PROTECTED]> 03/13/01 11:05 >>>
Does anyone know how to calculate the space needed when I import a dump
file when I know the dump file size ?
Thanx
L.A.
--
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).
Who are they ?
Lists, In Oracle Security Manager I found 3 users other than SYS and SYSTEM . what is task of these users ? <> DBSNMP <> MDSYS <> ORDSYS TIA, =bambang= <> 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).
RE: How to drop a datase ??
Sorry , If you accidentally drop it without having backup , there's no other way to recover it... an exprienced DBA just write 3 lines in his summary presentation : 1.BACKUP BACKUP BACKUP 2.PRACTICE , PRACTICE , PRACTICE 3. Dont Panic HTH , =bambang= <> Bambang Setiawan <> >>> <[EMAIL PROTECTED]> 03/12/01 10:10 >>> 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). -- 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).
Re: How to drop a datase ??
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).
Re: Installing Oracle on Windows Me
Hi Krishna You can't install Oracle Database Server on Windows Me , Oracle db server can only be installed on Windows NT/Workstation/2000. Windows Me is new generation of Windows 95/98 , and not designed to work as a server. Win Me just act as client side of Windows NT server or Windows 2000. you can install Personal Oracle 7 or Personal Oracle 8 on your Win Me . Although , It's just a miniature of Oracle Database Server , you still can learn many things such as make your own script in SQL*Plus. Personal Oracle8 can be downloaded from Oracle site. HTH : ) Bambang <> Bambang Setiawan <> >>> "Krishna Rao Kakatur" <[EMAIL PROTECTED]> 03/10/01 10:35 >>> I have downloaded the File oracle816nt.zip for Installing "Oracle8i EE Release 2 (8.1.6) for Windows 2000/NT", from Oracle Web Site. But, I couldn't install it on my Windows Me. Please suggest me if I can download and Install Oracle Server on Windows Me. If so, from which site? TIA, Krishna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Krishna Rao Kakatur 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).
RE: Forgot password for "internal" , any ideeas what I can do?
Hi Eddy , I assume you use db server v 8.X and NT , The steps to recover Internal lost password , First , try to find password file named PWD.ora for example PWDORCL.ora in your %ORAHOME%\database directory Make sure that you enable to show all files from your Explorer ==> View ==> Option second , just delete the PWD.ora if you worry about it , just move it from its original location. third , go to command prompt or DOS prompt. or you can call the application called ORAPWD80 just type C:\ orapwd80 file=d:\orant\database\PWD.ora password=this_is_my_new_password entries = integer for example : C:\ orapwd80 file=d:\orant\database\PWDORCL.ora password=isawherstandingthere entries = 5 Ok , just remember your new password : ) HTH , =bambang= <> Bambang Setiawan <> >>> "William Beilstein" <[EMAIL PROTECTED]> 03/10/01 04:46 >>> Internal is NOT a user, it is the SYS user opened in a special mode. To connect as internal you must have set the Oracle password file to the SYS password and be logged onto the server as the Oracle administrative user. On a Unix system this is normally the "oracle" user with belongs to the "dba" group. >>> Eddy Confer <[EMAIL PROTECTED]> 03/09/01 04:10PM >>> Pankaj You say that you can change the internal password by connecting as SYS. Connecting from where as SYS? SysMgr. After I connect do I just issues the alter user command to change the internal password. Thanks -Original Message- Sent: Friday, March 09, 2001 1:40 PM To: Multiple recipients of list ORACLE-L Hi Alex, the default is "oracle" if you have not changed that...in case you do...you can change that to whatever you want toby connecting through SYS account.. eNjoy life Technically ;-) Pankaj - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 09, 2001 11:05 PM > > Hi all, > > I just forgot the password for internal user, do you have any ideea how I > can connect as 'SYSDBA'? > Or how I can recover the password. > > Thx, alex. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Berindei Alex > 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: Pankaj 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: William Beilstein 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).
Re: Connected users ??
this script may help you : === rem this script used to observe connected users select S.SID ,S.username ,S.OSuser ,initcap(S.status) Status ,S.terminal ,decode(S.lockwait,NULL,'No','Yes') Lockwait ,initcap(A.Name) Command ,S.process ,P.SPID "NT_ID" fromv$SESSION S ,v$PROCESS P ,sys.AUDIT_ACTIONS A where S.username is not null and A.action = S.command and P.ADDR = S.PADDR ====== <> Bambang Setiawan <> >>> <[EMAIL PROTECTED]> 03/07/01 11:40 >>> 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) 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).
Re: error after creating second database
I've tried it... it works.. but my primary question not only how to fix it but why this thing happened ? <> Bambang Setiawan <> >>> "Joseph S. Testa" <[EMAIL PROTECTED]> 03/07/01 11:35 >>> READ the screen it tell you what to do: HINT: > You may need to run PUPBLD.SQL as SYSTEM Does it get more easier than that? if you dont understand, break out the documentation and start reading. joe Bambang Setiawan wrote: > > Wahai Guys, > > I created second database using Database Assistant on NT. > There's no error when I create this 2nd DB. > Then I make a host-string name 'dblokal2' for my second database. > > I can connect to my second db , but there's an error : > the message written below : > > SQL> conn beng/bambang@dblokal2; > Error accessing PRODUCT_USER_PROFILE > Warning: Product user profile information not loaded! > You may need to run PUPBLD.SQL as SYSTEM > Connected. > > why ? for there's no error when I create 2nd DB. > please help me to fix it ... > > <> Bambang Setiawan <> > -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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).
error after creating second database
Wahai Guys, I created second database using Database Assistant on NT. There's no error when I create this 2nd DB. Then I make a host-string name 'dblokal2' for my second database. I can connect to my second db , but there's an error : the message written below : SQL> conn beng/bambang@dblokal2; Error accessing PRODUCT_USER_PROFILE Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEM Connected. why ? for there's no error when I create 2nd DB. please help me to fix it ... <> 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).
can not mount database Exclusively
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).
