Finding tips
1) Find some files and execute other commands on them;find / -name scpfind ./ -atime +2 -exec rm '{}' ';'2)Find where is the original commandwhich sshwhich scp[@more@]
Imp/Exp-Basic rules
Always use the lower version to export.[@more@]Whenever you are moving data between different releases of the Oracle database, the following basic rules apply:* The Import utility and the database to which data is being imported (the target database) must be the same version.* The version of the Export utility must be equal to the earliest version of the source or target database.For example, to create an export file for an import into a later release database, use a version of the Export utilit
Clone a Database
1, generate txt control file;2,edit the txt control file with the new name;3,edit init.ora file with the new name;4,update env variable with the new name;5,update data dictionary,etc.[@more@]A database can be renamed by recreating the control files. You may want to rename a database after you have made a copy of a database from one system to another, for example, when refreshing a development database from production. Connect to Server Manager, i.e., "svrmgrl": CONNECT INTERNAL ALTER D
ORA-12705 - Solutions
1. ORA-12705 with incorrectly specified NLS_LANG2. ORA-12705 with incorrectly specified ORA_NLSx3. ORA-12705 due to Installation Issues4. ORA-12705 when using Special Charactersets5. ORA-12705 when connecting via SQL*Net6. ORA-12705 during Migration7. ORA-12705 when connecting with SVRMGRL and SQLPLUS8. ORA-12705 when connecting with Precompiler Aplications9. ORA-12705 during Export/Import[@more@]PURPOSE ------- This article is intended to give you an overview of common reasons for ORA-