大家在應用ORACLE的時候
本文對ORACLE的高手來說是不用看的
CREATE TABLE TEST
INSERT INTO TEST
SELECT * FROM TEST
SELECT * FROM TEST
ALTER TABLE TEST
EXP USER/PASSWORD FILE=A
IMP USER/PASSWORD FILE=A
以上測試環境為ORACLE
SQL*Plus: Release
Copyright (c)
連線到:
Oracle
With the Partitioning
JServer Release
SQL> DROP TABLE TEST
DROP TABLE TEST
*
ERROR 在行
ORA
SQL> CREATE TABLE TEST
已建立表格
SQL> INSERT INTO TEST
已建立
SQL> SELECT * FROM TEST
AAA
CCBZZPCCBZZP
SQL> SELECT * FROM TEST
AAA
CCBZZPCCBZZP
SQL> ALTER TABLE TEST
已更改表格
SQL>
d:> exp test/test file=a
Export done in ZHT
About to export specified tables via Conventional Path
Export terminated successfully without warnings
SQL> drop table test
已刪除表格
d:> imp test/test file=a
import done in ZHT
Import terminated successfully without warnings
待續
From:http://tw.wingwit.com/Article/program/Oracle/201311/18521.html