歷史文章::JohnChen

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

2016-08-19 12:56

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory 要在 LD_LIBRARY_PATH 裡面設定 libsqlplus.so 的所在路徑 export LD_LIBRARY_PATH=/opt/oracle/product/11.2.0/dbhome_1

建立/修改 User 語法

2016-08-11 12:20

create user chen identified by xxxx default tablespace chen temporary tablespace chen_temp quota 100M on chen ; alter user chen identified by xxxx default tablespace chen temporary tablespace chen_temp quota 100M on chen ; grant connect, resource, create view, alter session, create...

救回已經刪除的 table ( Recover Manager )

2016-08-10 13:57

RMAN> list backup of database; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 56 ...

救回已經刪除的 table ( FlashBack )

2016-08-10 12:08

SQL> select * from tab; 查現在有的...

匯出匯入特定 user 的所有資料表和資料 (Datapump)

2016-08-08 17:07

expdp system/xxxx SCHEMAS=john DIRECTORY=test_expdp DUMPFILE=expjohn.dmp job_name=john_expdp parallel=4 impdp system/xxxx SCHEMAS=john DIRECTORY=test_expdp DUMPFILE=expjohn.dmp;

匯出匯入特定 user 的所有資料表和資料 (export import)

2016-08-08 17:03

exp system/xxxx file=export_john.dmp owner=john

查詢以前下過的 SQL statment 和執行的時間

2016-08-02 17:04

SQL> select sql_text, First_LOAD_TIME from v$sqlarea where sql_text like 'select open_mode%'; SQL_TEXT ...

查詢 table 的 schema 和 tablespace 的方法

2016-07-29 15:37

SQL> select OWNER, TABLE_NAME, TABLESPACE_NAME from dba_tables where table_name='BOOK'; OWNER ...

perl install module

2014-03-05 11:41

rpm -Uvh https://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-7.noarch.rpm yum install gcc perl-CPAN perl-Archive-Zip perl-Class-MethodMaker perl-SOAP-Lite perl-XML-SAX yum install perl-XML-NamespaceSupport perl-XML-LibXML perl-Data-Dump uuid-perl libuuid-devel uuid-devel wget...

新增 vlan 步驟

2014-02-17 14:46

1.先把欲新增的 vlan 加入 spanning tree priority 中 2.allow 新 vlan 到 trunk port 上 3.指定那些 port 要使用新 vlan

歷史文章列表