In C: / Receive an A.SQL file file content: Drop table yangbc2.aa; create table yangbc2.aa as select id from yangbc2.a1 where id = '001'; save file, execute @ in SQL * Plus Path: / filename, 即: @c: /a.sql; drop table yangbc2.aa * error is located in Chapter 1: ORA-00942: Table or view does not exist table created.
SQL> SELECT * from AA;
ID ---------- 001
SQL> Select * from yangbc2.aa;
ID ---------- 001
