fengyonghui@javaEye

Problem:[oracle@l360cn31 ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 15 10:21:54 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR:ORA-01...

Here's the steps for backupa db schema, which just applies to oracle database. Suppose the osl schema is osl/welcome1, and the ORACLE_SID=orcl, then:Export Schema (backup)First,create...

Report table columns and comments:select tc.table_name, tc.column_name, tc. data_type, tc.nullable, nullif(cc.comments, '')from all_tab_columns tc, all_col_comments ccwhere tc.owner = cc.owner...

If oracle DB instance installed, there is registration in the file: /etc/oratab.if you happed to remove the instance and re-install it. then it will promt: The SID you have specified already exists...

If you run recursive sql in the oracle db 11.1.x, you probably meet issue like this:Internal Exception: java.sql.SQLException: Closed Connection, it is a bug in this DB version. you have 2 optio...

If you are always prompted the DB is still in use ... alter system enable restricted session; select sid,serial# from v$session where username = 'XXX'; alter system kill sess...