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
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
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...
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 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)...
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...
I use Exabyte autoloader and Netbackup server on Solaris 9 sparc station. When booting system, got following error information:
/pci@le, 60000/LSILogic, scsi@4/st@1,0(st31)
VXA-2 options value invalid bits set: 0x4000
ermesx tl8cd[322]: TL8(1)Mode_sense error
ermesx tl8cd[322]: TL8(1) Key 5h...
I got two problems of DTS:
1. When I use DTS to move all records from one database to another database, only some records are moved, others not. And there is no error in the log file of export package and run status is 4 for this step. But I test transformation using “transformation data task...
I use SQL server 2000 and build a table TB1. Using remote connect to access this table. When I print this table in ASP page, I can not get the record in TB1. But I can get other record which perhaps has been deleted. Who knows what happens? Thanks.
This is the old application, now I am updating it.
I use SQL server 2000 and build a table TB1. Using remote connect to access this table. When I print this table in ASP page, I can not get the data in TB1. But I can get other data which perhaps has been deleted. Who knows what happens? Thanks.
This is the old application, now I am updating it.
I use Netbackup sever 5.1 on Solaris 9. I can not configure device since it can not detect device. When testing devices using "Drive Diagnostics", it failed at "Basic Test", show error information "Could not find label on media".
In "Device Monitor", "Media Label" shows a dash (-). How can I...
I set session timeout to 120 minutes. But users always log out less than 60 minutes. Just like timeout is only 60 minute. I used session.timeout=120 in asp file. By the way, when I print out timeout using <% response.write session.timeout %>, I got 120. Thanks for any advice.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.