I have a hard disk with 120GB in size. And I did two partitions on it to make the first one as C: system drive and the second one as a Data drive. But later on I had a space issue on the C: due to too many programs installed. Then I tried to merge these two partitions in PowerQuest PartitionMagic 8.0, but failed with the following errors like:
Error 4 while executing Batch…. Error 4 Bad Argument/Parameter….
First, I guessed it was because my hard disk had some disk errors. So I did chkdsk DOS command to check and fix disk error on the hard disk I tried to merge. After that, I tried Merge again, but I still had the same error.
Continue reading ‘Problem with Partition Merge in PartitionMagic 8.0′
Related posts
Published on
January 16, 2009 in
Database.
This is a simple one SQL I used yesterday for the Oracle application development. I have two tables which have two common fields (let us say, table_id and col1). The col1 in table1 is empty since it is a newly created table, and the col1 in table2 has the data but I will not use table2 since it is a old table. What I need to do is to move all col1 data from table2 to table1. The challenge is Table1 and Table2 do not have the exact same data on table_id.
First I used the following SQL statement to update the col1 in the table1 from column value in table2:
update table1
set col1=(select col1 from table2 where table2.table_id=table1.table_id)
Continue reading ‘How to update one table from values in another table’
Related posts
Published on
January 10, 2009 in
Database.
I have a Oracle database table with some fields (columns) in numeric format. Now I need to update one column, namely store_id, to make it a primary column with unique number id. Since there were a lot of duplicate data in this column, the best way to do is to update this column with the sequence numbers.
To accomplish this, I need to create a sequence object in Oracle, and use Oracle cursor to loop and update the table column.
Here is the PL/SQL I used and worked.
DECLARE
Cursor store_id
IS
SELECT store_id FROM store_locations FOR UPDATE;
BEGIN
FOR c_store_id IN store_id LOOP
UPDATE cms_store_locations
SET store_id = store_seq.nextval
WHERE CURRENT OF store_id;
END LOOP;
commit;
END;
/
Related posts
Yesterday one user reported that when he tried to edit a Microsoft Project document that is stored in a document library of a Microsoft Windows SharePoint Services Web site, he received the following error messages with Office (Project) 2003 installed on his computer.
‘Edit Document’ requires a Windows SharePoint Services-compatible application and Microsoft Internet Explorer 6.0 or greater.
I found a Microsoft Knowledge base article and did what it told me to do by updating the SharePoint support, but could not be successful. Then I tried the method 3 to register the Owssupp.dll but get the following error.
DllUnregisterServer in Owssupp.dll failed….return Error code 0×80070716.
Continue reading ‘How to resolve “‘Edit Document’ requires a Windows SharePoint Services-compatible application and Microsoft Internet Explorer 6.0 or greater” error’
Related posts
Blog Comments