| | ssh without password
On the Client, run the ssh-keygen utility.
Change directory to .ssh directory.
Do not enter a passphrase.
Example:
/apps/oracle/.ssh> ssh-keygen -t rsa
Enter file in which to save the key(/apps/oracle/.ssh/id_rsa): [enter]
Generating public/private rsa key pair.
Enter passphrase(empty for no passphrase): [enter]
Enter same passphrase again: [enter]
Your identification has been saved in /apps/oracle/.ssh/id_rsa.
Your public key has been ... | | 
More...
02/27/07 | | | | | | | | |
|
| | Change PostgreSQL table column
In this example a column type is changed to varchar of size up to 10 characters:
ALTER TABLE [table name] ALTER COLUMN [column name] TYPE VARCHAR(10); | | More...
02/27/07 | | | | | | | | |
|
| | How to ANALYZE partitioned tables with VALIDATE STRUCTURE
If you got the error:
ORA-14508: specified VALIDATE INTO table not found
This may be because you are trying to analyze a partitioned table and INVALID_ROWS table is not found in the current schema.
To validate structure (checks objects for logical corruption) for partitioned tables you first need to ensure that you’ve got ... | | More...
01/24/07 | | | | | | | | |
|
| | WARNING: TEMP tablespace is not large enough for the upgrade
Apparently Oracle wants the default temporary tablespace to be locally managed when upgrading from 10.1 to 10.2. When running utlu102i.sql script it throughs this warning if your temp tablespace is dictionary managed:
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 347 MB
WARNING: --> TEMP tablespace is not large ... | | More...
01/23/07 | | | | | | | | |
|
| | How to add a column to PostgreSQL table
Below example adds a new column of type varchar and length 10 characters to a PostgreSQL database table:
psql> ALTER TABLE [table_name] ADD COLUMN [column_name] VARCHAR(10);
You can run it from psql, phpPgAdmin or any other admin tool
| | More...
01/19/07 | | | | | | | | |
|
| | Resize or add datafiles using brspace
This is a quick reference for SAP brspace utility.
To add a new file to tablespace (to keep the same size as the previous file and keep the same location) run:
brspace -c force -f tsextend -t [tablespace name]
The file properties such as size, autoextend, filesystem will default to the file that ... | |
More...
01/09/07 | | | | | | | | |
|
|
| | How to clean a dirty keyboard
Have you ever spilled coffee on your keyboard and some of the keys are getting stuck when you press them? Or have you been using it for a while, and a lot of dust and dirt got between the keys? It's very easy to clean your keyboard.
1. Shutdown your computer, ... | | More...
12/21/06 | | | | | | | | |
|
| | Change permissions only for directories
A quck tip on how to change permissions for directories under a directory tree without changing permissions for files.
In this example all sub directories under the current directory will have execute bit set for owner, group and everyone else:
find . -type d -exec chmod a+x {} \;
| |
More...
12/16/06 | | | | | | | | |
|
| | Registering .au (Australian) domain name
These are just some tips (from personal experience) on how to register Australian .com.au domain names.
1. Business name
Having an ABN (Australian Business Number) is sufficient to register .au domain name. The reason why I mention this is because I was under the impression you need to spend $70 (or whatever ... | |  
More...
12/01/06 | | | | | | | | |
|
<< 1 | 2 | 3 | Page 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 >>
|
