Re: Convert Access to Oracle

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

Re: Inserting a Record into a Table

; 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

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

Re: Steve Adams's Removal

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

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

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

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

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

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

2 Databases Problem

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

Tuning Matter == Parameter PCT_USED in a Table

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

Re: imp

at 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 li

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 se

RE: Script to know the size of each table in a schema ?

? 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

Re: Can not open DB :(

' 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\

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 w

Script to know the size of each table in a schema ?

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

Re: .dmp and space used

, 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

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-

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

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

Re: How to drop a datase ??

: 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

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

Re: Installing Oracle on Windows Me

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

error after creating second database

; 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

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 i

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