| | Some useful resources for webmasters and marketers
Here's a list of some resources, websites / software that may be useful for webmasters and SEO marketers.
http://www.webmasterworld.com
Great resource for webmasters, technical and marketing forums.
http://www.copyscape.com
Allows to search the web for copies of your website.
http://home.snafu.de/tilman/xenulink.html
Xenu's Link Sleuth allows to check a website for broken links. Download and install the software on ... | | More...
11/28/05 | | | | | | | | |
|
| | mod_rewrite on Windows (overwrite URLs)
Can't get mod_rewrite (rewriting URLs) working on Windows? The solution is fairly simple. Make sure you have the following in your httpd.conf. Replace "C:/www" with the directory under your DocumentRoot where you placed .htaccess file. Once you've copied the lines below into Apache configuration file restart web server and URL ... | |  
More...
11/28/05 | | | | | | | | |
|
| | Oracle Virtual Indexes - How to
Virtual index is a feature of Oracle 10 and Oracle 9. The purpose of virtual indexes is simulate the existence of an index, without actually building it, so you can explain plan as if the index existed. It is important to drop the index after you're done with it.
To build ... | | More...
11/24/05 | | | | | | | | |
|
| | How to register database with RMAN recovery catalog
Replace username/password with the actuall username and password for recovery catalog; and MYDB with the name of the recovery catalog database
1. Change SID to the database you want to register
. oraenv
ORACLE_SID
2. Connect to RMAN catalog database
rman target / catalog username/password@MYDB
3. Register database
RMAN> register database;
| |
More...
11/23/05 | | | | | | | | |
|
|
| | Rebuilding index partitions / subpartitions with corrupted block
This procedure assumes you had this error (corrupted block in index partition):
ORA-01578: ORACLE data block corrupted (file # 459, block # 15)
ORA-01110: data file 459: '/path/to/datafile.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option
1. Find out which partition has corrupted block
select distinct partition_name, index_name
from dba_ind_subpartitions
where subpartition_name in
(
select partition_name
from dba_segments
where tablespace_name ... | |
More...
11/17/05 | | | | | | | | |
|
| | Find and replace line breaks with patern in vi
Sometimes you need to append something to the end of line in a text file or script. Use the following vi command (in this example append a semicolon ';' to the end of every line in the file).
:1,$s/$/;/g
| | 
More...
11/17/05 | | | | | | | | |
|
| | Database copy / restore - skipping tablespaces
Sometimes you want to copy (refresh) database without some tablespaces i.e. due to space restrictions. These are general guidlines for skipping tablespaces when copying a database (the same with RMAN restore, restore from cold backup or copy from a standby database).
1. Once the datafiles have been copied / restored
SQLPLUS> startup ... | |
More...
11/14/05 | | | | | | | | |
|
|
| | vi commands
Here are some vi commands.
:1,$s/old/new/g find old, replace with new
:set all show all settings
:set list display invisible characters
:set showmode display the mode
:3,8d delete lines 3-8
D delete to end of lines
J4 join 4 lines to current
:4,9m 12 move lines 4-9 to 12
:2,5t 13 copy lines 2-5 to 13
:5,9w file write lines 5-9 to file
ZZ write buffer and quit
% goto matching brace/paren
3G goto line 3
3w go ... | | More...
11/09/05 | | | | | | | | |
|
<< 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | Page 12 | 13 | 14 | 15 | 16 | 17 >>
|
