Recent content by JenniferCheng

We have three databases in Oracle server. I need some summary tables developed for these databases that show me the information of tablespaces, schemas, storage amounts, etc. It is building data dictionary. I know there is build-in data dictionary. May I create my own data dictionary or just...

I replaced older DLL file myfile.dll with new one, but with the same name. I got error message when run a related asp page when using this new dll file. Here is error message: Server object error 'ASP 0177 : 8007007e' Server.CreateObject Failed But when I change back to the older myfile.dll...

Hi, When run select select * from core_info_table where core_id = '0' ; Get message : "No rows selected". Actually there are more than 1000 records with core_id=0 in table core_info_table. Thanks. Jennifer

Mufasa, Thanks. It works. Jen

Hi, I want to replace field "Customer_id" beginning with "MD" to beginning with "FH", and there are around 5000 records. If using update script, I need write 5000 scripts. Is there any good method or Oracle function? Thanks in advance. Jennifer

Thanks. But it still doesn't work. Here is script: UPDATE Customer_Inforamtion SET Customer_id = 'FH' & Mid([Customer_id], 4) WHERE Customer_id Like 'MD*' ; There are totally 6 digits of field Customer_id. After run this script, get message "Enter value for mid:". After enter 0190, get...

Hi, I have a frontend access 2002 connecting to Oracle server through odbc. I need to update many record value in linked table T1. I want to replace field "Customer_id" beginning with "MD" to beginning with "FH", and there are around 5000 records. Then I need use "find and replace" function...

Thanks very much. By this way, do I need make S_code non-primary-key in the source tables? Thanks. Jennifer

I use 5 DTS packages to combine 5 tables (T1, T2, …, T5) of 5 databases to one table Sam. All these 5 tables have same primary key S_code and value of S_code is from 1 to 200. I use DTS to transport record in 5 tables to Table Sam. Since there is duplicate S_code, after run first DTS to...

I want to back up Oracle server. Do I need install NetBackup for Oracle software? Curren backup version: NetBackup server 5.1 on Solaris 9. Thanks

Yes, you are right. The tape was in NetBackup pool. Now I deassigned the media and moved this media to DataStore pool. When backup /bin using policy Test_bin manually, get following error message: 11/29/2005 11:04:17 - started process bpbrm (pid=8503) 11/29/2005 11:04:17 - connecting...

I met a problem when backup files. I set up policy test to backup /dev directory on backup server. When performing manual backup, got two jobs under Activity Moniter. Following is information about two jobs: Job 55, detailed status: 11/28/2005 14:48:13 – started process bpbrm (pid=3182)...

I updated mapping file again. Everything looks fine. Thanks very much. Jennifer

I found out there is some problem with device mapping file. The device changer is "EXABYTE VXA 1x10 1U" but I can not find it in device_mapping file. After updating device mapping file, robot can not be detected. Looks like I need find a suitable device mapping file.

When I add ag dirver by running /usr/openv/volmgr/bin/driver/sg.link, I got following error: ________ Copies files to /kernel/drv and to /kernel/drv/sparcv9. Doing add_drv of the sg driver devfsadm: driver failed to attach: sg warning: Driver (sg) successfully added to system but failed to...