AnySQL.net English
Personal software, life, research and professional Oracle recovery service
Home
Chinese
Weblog
AUL/MyDUL
Tools
Archive
About
Archives
2007.08.12:
Hint USE_CONCAT does not work sometime on 10g database
2007.08.07:
How to access Oracle kernel table quickly?
2007.08.07:
How to get the current session id in Oracle?
2007.07.28:
I have two questions, any suggestion?
2007.07.28:
Learning from MySQL, make AnySQL more powerful.
2007.06.28:
Delete from DBA_TABLESPACES where tablespace_name = ...
2007.06.20:
Test Oracle 11g data file recovery with AUL utility
2007.06.20:
aul4b is not beta version, The "B" means LOB support
2007.06.19:
The speed of LOB recovery with AUL utility, fast or slow?
2007.06.19:
How much files can be stored in one directory?
2007.06.14:
Don't abuse the resetlogs option when open database
2007.06.14:
Create a SQL file to create the table for faster recovery
2007.06.06:
Filter table? Filter index? The OR where clause.
2007.06.04:
Don't use 128 for multiple block read count
2007.06.04:
An Offline Oracle Log Miner, 8i/9i Version.
2007.06.02:
Use MyLOG to fasten the recovery of drop operation
2007.05.30:
An Offline Oracle Log Miner, 10g Version.
2007.05.22:
Some turkey people are not trustful!
2007.05.22:
Using wild char for table list when comparing columns
2007.05.21:
Compare column for multiple tables in different databases
2007.05.17:
Compare column for multiple tables in same database
2007.05.17:
Compare column on multiple hosts for the same table
2007.05.17:
There are 4 type of compare column methods
2007.05.16:
Compare column and index between different databases
2007.05.16:
A performance test case of single table hash cluster.
2007.05.16:
Compute statistics will analyze table in Oracle 9i
2007.05.14:
Got license after payment, no exception for you.
2007.05.11:
The return or exit code of ociuldr utility.
2007.05.11:
New option of ociuldr utility -- LOG
2007.04.27:
Oracle should add an index based on HASH method.
2007.04.26:
How to choose the SIZE and HASHKEYS of hash cluster table?
2007.04.25:
Create Normal B*Tree index on the hash cluster key column.
2007.04.25:
Get a simple work done with one more complex way.
2007.04.08:
MyLOG, Search through the Oracle log file by object id.
2007.03.23:
New API interface suggested for Perl DBI call.
2007.03.15:
Data replication from MySQL or others to Oracle database?
2007.03.14:
A Demo Configuration of refresh_mysql.pl script
2007.03.14:
Replicate data from Oracle to MySQL with Perl scripts
2007.03.13:
Performance between enable/eisable storage in row LOBs?
2007.03.09:
A Special Case of Library Cache Lock Wait Event.
2007.03.09:
AUL V3 got retired, AUL V4 start working.
2007.03.05:
Resolve relink Oracle 9207 error on Solaris.
2007.02.27:
Some system level dynamic parameters since Oracle 10g.
2007.02.09:
The USING INDEX option of primary key/unique constraints.
2007.02.07:
How to handle resource busy (ORA-00054) error?
2007.02.06:
Is INDEX_COL a documented hint in Oracle 11g?
2007.02.06:
RMAN Copy + Rsync, is it implemented in Oracle 11g?
2007.01.31:
Assign HEX value to RDBA optionn in AUL.
2007.01.25:
How to modify the storage properties of XMLTYPE type?
2007.01.25:
The query option of Oracle exp utility.
2007.01.24:
My first Movable Type plugin -- RandomImage
2007.01.09:
How to recovery IOT table with AUL?
2007.01.09:
How AUL 4 support the partition table's LOB recovery?
2006.12.19:
How AUL 4 support different LOB chunk size?
2006.12.19:
Recover data from truncated tables, you can do it by yourself.
2006.12.18:
Trying LOB data recovery in DMP format on 10g (Windows platform)
2006.12.18:
Trying BLOB data recovery on 10g (Windows platform)
2006.12.18:
Trying CLOB data recovery of 10g (Windows platform)
2006.12.17:
Few options of AUL version 4 to support LOB data type
2006.12.15:
Very happy to announce AUL/MyDUL 4.0.0 Beta release.
2006.12.10:
AUL Dictionary -- Column
2006.12.10:
AUL Dictionary -- Segments
2006.12.09:
AUL Dictionary -- Objects
2006.12.06:
AUL Dictionary -- Users
2006.12.06:
New ociuldr command line option -- batch
2006.12.05:
How to compile perl DBD-Oracle module for 8i/9i/10g?
2006.12.05:
Connect to Oracle database without tnsnames.ora configuration?
2006.12.04:
How to load UNICODE data into NCHAR/NVARCHAR2 columns?
2006.11.20:
Run script file in AUL/MyDUL for faster recovery
2006.11.20:
ociuldr's new command line option -- table
2006.11.13:
New utility -- get some basic information of archived log
2006.11.13:
Get started with AnySQL utility -- chapter 6 (LONG and LOBs)
2006.11.07:
How to perform DML on mview to manually refresh the data?
2006.11.07:
Very happy to be a dad, some pictures ...
2006.11.01:
Start selling of AUL/MyDUL licence now ...
2006.10.18:
Change of the AUL licence count logic, remove IP limit.
2006.10.10:
Steps of asking for AUL/MyDUL full licence and start recovery
2006.10.10:
Get full AUL/MyDUL licence online, just here...
2006.10.10:
A small mistake in the SQL*Loader control file generated by AUL/MyDUL.
2006.10.08:
Get started with AnySQL utility -- chapter 5
2006.10.08:
Get started with AnySQL utility -- chapter 4
2006.10.08:
Get started with AnySQL utility -- chapter 3
2006.10.05:
Get started with AnySQL utility -- chapter 2
2006.09.22:
How AUL/MyDUL recover the rows truncated by mistake?
2006.09.18:
How to deploy AnySQL in Unix/Linux host?
2006.09.18:
Fasten tags based search by caching the result in Movable Type 3.3x
2006.09.12:
Incorrect display of RSS items on Lilina 0.9 and fixed it.
2006.09.07:
A JavaScript problem on IE7 Beta2
2006.09.06:
More changes to the SCode plugins of Movable Type
2006.09.06:
Inprove the performance of SCode plugins of Movable Type
2006.08.23:
What did "SET UNUSED COLUMN" do in Oracle? Just a Guess.
2006.08.21:
Definitely OLTP system need to avoid unnecessary sort operation
2006.08.18:
Will bind variables affect whether Oracle do sort or not?
2006.08.16:
Made some change to mt-scode.cgi, just for fun!
2006.08.15:
How to uninstall Oracle Context manually?
2006.08.15:
How to install Oracle Context manually?
2006.08.15:
Reinstall the notebook today
2006.08.14:
Get started with AnySQL utility -- chapter 1
2006.08.14:
How I compile my OCI based utilities on Linux/Unix?
2006.08.12:
How to handle dead block in AUL/MyDUL?
2006.08.12:
How to recover data without system tablespace?
2006.08.12:
The limition of AUL/MyDUL dmp format
2006.08.12:
AUL/MyDUL Update, Version 3.2.1
2006.08.10:
Linux raw devices deprecated for Oracle 10.2.0.2
2006.08.10:
AUL/MyDUL Update, Version 3.2.0
2006.08.10:
Oracle Compressed Block Structure (1)
2006.08.10:
Oracle Bug : exp-00003 for LOB tables
2006.08.10:
Is GUI tool suitable for a DBA ?
2006.08.09:
My Oracle, 32Bits or 64Bits?
2006.08.09:
Tools Update -- Control long size in ociuldr
2006.08.08:
AnySQL.net hacked and new IamDBA.com
Search By Tags
32Bits
64Bits
Analyze
AnySQL
Archived Log
Array
AUL
Baby
Bind Variable
Bind Variables
Blog
Bug
Busy
Cache
CLOB
Cluster
Column
Compare
Compile
Compress
Connection
Context
Copy
Crash
CSV
Data Warehouse
DBA
DBD
DBI
Delete
Drop
DUL
Dynamic
Excel
Exp
Export
Fetch
Format
Hacker
Hash
Hashkeys
Hint
IE7
Index
IOT
JavaScript
JDBC
Kernel
libsrvm
Life
Lilina
Linux
LOB
Lock
Log
Log Miner
LONG
Movable
Move
MT
MVIEW
MyDUL
MyLOG
MySQL
Object
OCI
ociuldr
OEM
OLAP
Oracle
Oracle10g
Oracle11g
Oracle9i
OS
Parallel
Parameter
Partition
Perl
Pin
Plugin
Query
Raw
RDBA
Recovery
Refresh
Reinstall
Relink
Replication
Resetlogs
RMAN
Rsync
SCN
SCode
Search
Session
Set
Solaris
Sort
Spam
SQL
SQL*Plus
sqlldr
SQLLDR
Standby
System
Table
Text
Tnsname
Toad
Tools
Translate
Truncate
Tuning
Type
Unicode
Unload
Unused
Where
XML
Categories
AUL/MYDUL
(31)
AnySQL
(8)
DBA
(8)
Developer
(3)
Life
(4)
Oracle
(29)
Tools
(20)
Weblog
(8)
Archives
August 2007
(3)
July 2007
(2)
June 2007
(11)
May 2007
(13)
April 2007
(5)
March 2007
(8)
February 2007
(5)
January 2007
(6)
December 2006
(15)
November 2006
(7)
October 2006
(8)
September 2006
(7)
August 2006
(21)
This weblog is licensed under a
Creative Commons License
.
Powered by
Movable Type 3.36