SQL*Plusのプロンプトでスクリプトファイルを実行したところ、エラーが出る。

Question

下記の記事を参考にmac OS でOracle Databaseを使えるように進めました。
https://qiita.com/shinbones/items/07d474a049c454100363
オラクルブロンズ白本付属のサンプル表をOracle Databaseに登録しようとSQLPlusのプロンプトに@cretab.sqlと入力して、スクリプトファイルを実行したところ下記のエラーが出ました。
SQL> @cretab.sql
SP2-0734: unknown command beginning "?@ / ???K..." - rest of line ignored.
SP2-0734: unknown command beginning "?@/* SYSTE..." - rest of line ignored.
"Clean Up ..."
"??????s???̓G???[?????????܂?????肠??܂???B"
User dropped.
"ora01" User Creating...
User created
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
"ora01" 's DATA Creating...
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Warning: You are no longer connected to ORACLE.
SP2-0640: Not connectedが以下119行続きます。

SPOOL setup.log
PROMPT
PROMPT "Clean Up ..."
PROMPT "初回実行時はエラーが発生しますが問題ありません。"
DROP USER ora01 CASCADE;
PROMPT
PROMPT "ora01" User Creating...
CREATE USER ora01
IDENTIFIED BY oracle;
GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO ora01;
GRANT CREATE SYNONYM TO ora01;
GRANT CREATE ROLE TO ora01;
GRANT CREATE VIEW TO ora01;
PROMPT
PROMPT "ora01" 's DATA Creating...
CONNECT ora01/oracle
CREATE TABLE departments
       (deptno NUMBER(2) CONSTRAINT pk_dept PRIMARY KEY,
	dname VARCHAR2(14) ,
	loc VARCHAR2(10) ) ;
CREATE TABLE employees
       (empno NUMBER(4) CONSTRAINT pk_emp PRIMARY KEY,
	ename VARCHAR2(10),
	yomi VARCHAR2(20),
	job VARCHAR2(8),
	mgr NUMBER(4),
	hiredate DATE,
	sal NUMBER(7),
	comm NUMBER(7),
	deptno NUMBER(2) CONSTRAINT fk_deptno REFERENCES departments(deptno));
INSERT INTO departments VALUES
	(10,'管理','大手町');
INSERT INTO departments VALUES 
	(20,'研究開発','横浜');
INSERT INTO departments VALUES
	(30,'営業','品川');
INSERT INTO departments VALUES
	(40,'財務','東京');
INSERT INTO employees VALUES
	(1001,'佐藤','sato','社長',NULL,to_date('2001-02-25','yyyy-mm-dd'),500000,NULL,10);
INSERT INTO employees VALUES
	(1002,'鈴木','suzuki','事務',1013,to_date('2000-03-26','yyyy-mm-dd'),200000,NULL,20);
INSERT INTO employees VALUES
	(1003,'高橋','takahashi','営業',1007,to_date('2000-05-30 ','yyyy-mm-dd'),300000,30000,30);
INSERT INTO employees VALUES
	(1004,'田中','tanaka','営業',1007,to_date('2002-06-02','yyyy-mm-dd'),355000,50000,30);
INSERT INTO employees VALUES
	(1005,'渡辺','watanabe','部長',1001,to_date('2002-07-11','yyyy-mm-dd'),280000,NULL,20);
CREATE TABLE salgrades
      ( grade CHAR(1) CONSTRAINT pk_grade PRIMARY KEY,
	losal NUMBER(7),
	hisal  NUMBER(7));
INSERT INTO salgrades VALUES ('A',100000,190000);
INSERT INTO salgrades VALUES ('B',190001,280000);
INSERT INTO salgrades VALUES ('C',280001,370000);
INSERT INTO salgrades VALUES ('D',370001,460000);
INSERT INTO salgrades VALUES ('E',460001,999999);
CREATE TABLE customers
	(custno 	NUMBER(5) CONSTRAINT cust_pk PRIMARY KEY,
 	 cname 		VARCHAR2(20),
	 address	VARCHAR2(30),
	 phone		VARCHAR2(12),
	 credit_rating	VARCHAR2(6));
INSERT INTO customers VALUES (1000,'品川商事','東京都港区１－ｘ－ｘ','03-1234-xxxx','優良');
INSERT INTO customers VALUES (1001,'横浜商店','横浜市磯子区２－ｘ－ｘ','045-753-xxxx','要注意');
INSERT INTO customers VALUES (1002,'川口や','川口市本町１－ｘ－ｘｘ','048-336-xxxx','要注意');
INSERT INTO customers VALUES (1003,'○×商店','横浜市鶴見区２－ｘｘ','045-505-xxxx','良');
INSERT INTO customers VALUES (1004,'川崎ストア','川崎市川崎区１０－ｘｘ','044-567-xxxx','優良');
CREATE TABLE products
	(PRODNO		CHAR(3) CONSTRAINT PROD_PK PRIMARY KEY,
	 PNAME		VARCHAR2(30),
	 PRICE		NUMBER(6));
INSERT INTO products VALUES ('A01','100円ボールペン',100);
INSERT INTO products VALUES ('A02','芯強シャープペンシル',100);
INSERT INTO products VALUES ('A03','10色ボールペン',300);
INSERT INTO products VALUES ('A04','最高級万年筆',1000);
INSERT INTO products VALUES ('A05','なないろ鉛筆',30);
REATE TABLE orders
	(ordno	NUMBER(8) CONSTRAINT ORD_PK PRIMARY KEY,
	 custno NUMBER(5) CONSTRAINT ORD_CUST_FK REFERENCES customers(CUSTNO),
	 date_ordered	DATE,
	 date_shipped	DATE,
	 salesman_no	NUMBER(4) CONSTRAINT ord_emp_fk REFERENCES employees(empno),
	 payment_type	VARCHAR2(10));
INSERT INTO orders VALUES (1,1001,'2009-12-20','2009-12-27',1003,'クレジット');
INSERT INTO orders VALUES (2,1001,'2009-12-21','2009-12-27',1003,'クレジット');
INSERT INTO orders VALUES (3,1001,'2010-01-10','2010-01-17',1003,'クレジット');
INSERT INTO orders VALUES (4,1002,'2010-01-11','2010-01-18',1010,'クレジット');
INSERT INTO orders VALUES (5,1008,'2010-01-15','2010-01-22',1003,'クレジット');
CREATE TABLE ord_details
	(ordno		NUMBER(8)   CONSTRAINT ord_det_ord_fk REFERENCES orders(ordno),
	 prodno		CHAR(3)	CONSTRAINT ord_det_prod_fk REFERENCES products(prodno),
	 quantity	NUMBER(5),
         CONSTRAINT ord_det_pk PRIMARY KEY(ordno,prodno));
INSERT INTO ord_details VALUES (1,'A02',30);
INSERT INTO ord_details VALUES (1,'C01',20);
INSERT INTO ord_details VALUES (2,'B01',5);
INSERT INTO ord_details VALUES (2,'B06',10);
INSERT INTO ord_details VALUES (2,'B02',10);
SPOOL off

文字化けしているのをediterで開きUTF-8からShift JISへエンコードを変更しました。

Comments

[Orlofsky]

質問に cretab.sql の内容をそのまま https://teratail.com/help/question-tips#questionTips3-7 の [コード] で追記してください。

[Orlofsky]

エラーメッセージはキャプチャではなく、表示された文字をそのまま質問にコピペしてください。https://teratail.com/help/question-tips#questionTips3-4-2 キャプチャは削除してください。

[Orlofsky]

関係ないけど、
今どき、Oracle Master BronzeやSilverをありがたがってくれる会社は、まずないです。Gold を持っていても恥ずかしいから履歴書に書かない人が多いくらいです。

[nao085]

```sql
@ /* ŽÀK—pƒf[ƒ^ì¬ƒXƒNƒŠƒvƒg @ @ @ */
@/* SYSTEMƒ†[ƒU[(ŠÇ—ŽÒƒ†[ƒU[)‚ÅŽÀs‚µ‚Ä‚­‚¾‚³‚¢ @ */
/* •]‰¿”Å‚ðƒCƒ“ƒXƒg[ƒ‹‚µ‚½ƒeƒXƒgŠÂ‹«‚È‚Ç‚ÅŽg—p‚µ‚Ä‚­‚¾‚³‚¢B */
/* (–{”Ԋ‹«‚Å‚ÍŽg—p‚µ‚È‚¢‚Å‚­‚¾‚³‚¢B) */
/* ŽŸ‚̃Rƒ}ƒ“ƒh‚ðSYSTEMƒ†[ƒU[‚ÅŽÀs‚·‚é‚ÆŽÀKŠÂ‹«‚ðíœ‚Å‚«‚Ü‚·B*/
/* DROP USER ora01 CASCADE; */

SPOOL setup.log
PROMPT
PROMPT "Clean Up ..."
PROMPT "‰‰ñŽÀsŽž‚̓Gƒ‰[‚ª”­¶‚µ‚Ü‚·‚ª–â‘è‚ ‚è‚Ü‚¹‚ñB"
DROP USER ora01 CASCADE;

PROMPT
PROMPT "ora01" User Creating...
CREATE USER ora01
IDENTIFIED BY oracle;
GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO ora01;
GRANT CREATE SYNONYM TO ora01;
GRANT CREATE ROLE TO ora01;
GRANT CREATE VIEW TO ora01;

PROMPT
PROMPT "ora01" 's DATA Creating...
CONNECT ora01/oracle

/* Create Table for ŽÀK */

CREATE TABLE departments
(deptno NUMBER(2) CONSTRAINT pk_dept PRIMARY KEY,
dname VARCHAR2(14) ,
loc VARCHAR2(10) ) ;

CREATE TABLE employees
(empno NUMBER(4) CONSTRAINT pk_emp PRIMARY KEY,
ename VARCHAR2(10),
yomi VARCHAR2(20),
job VARCHAR2(8),
mgr NUMBER(4),
hiredate DATE,
sal NUMBER(7),
comm NUMBER(7),
deptno NUMBER(2) CONSTRAINT fk_deptno REFERENCES departments(deptno));

INSERT INTO departments VALUES
(10,'ŠÇ—','‘åŽè’¬');
INSERT INTO departments VALUES
(20,'Œ¤‹†ŠJ”­','‰¡•l');
INSERT INTO departments VALUES
(30,'‰c‹Æ','•iì');
INSERT INTO departments VALUES
(40,'à–±','“Œ‹ž');

INSERT INTO employees VALUES
(1001,'²“¡','sato','ŽÐ’·',NULL,to_date('2001-02-25','yyyy-mm-dd'),500000,NULL,10);
INSERT INTO employees VALUES
(1002,'—é–Ø','suzuki','Ž––±',1013,to_date('2000-03-26','yyyy-mm-dd'),200000,NULL,20);
INSERT INTO employees VALUES
(1003,'‚‹´','takahashi','‰c‹Æ',1007,to_date('2000-05-30 ','yyyy-mm-dd'),300000,30000,30);
INSERT INTO employees VALUES
(1004,'“c’†','tanaka','‰c‹Æ',1007,to_date('2002-06-02','yyyy-mm-dd'),355000,50000,30);
INSERT INTO employees VALUES
(1005,'“n•Ó','watanabe','•”’·',1001,to_date('2002-07-11','yyyy-mm-dd'),280000,NULL,20);
INSERT INTO employees VALUES
(1006,'ˆÉ“¡','ito','‰c‹Æ',1007,to_date('2008-01-06','yyyy-mm-dd'),300000,140000,30);
INSERT INTO employees VALUES
(1007,'ŽR–{','yamamoto','•”’·',1001,to_date('2000-08-09','yyyy-mm-dd'),285000,NULL,30);
INSERT INTO employees VALUES
(1008,'’†‘º','nakamura','•”’·',1001,to_date('2000-09-17','yyyy-mm-dd'),245000,NULL,10);
INSERT INTO employees VALUES
(1009,'¬—Ñ','kobayashi','Žå”C',1005,to_date('2006-10-21','yyyy-mm-dd'),300000,NULL,20);
INSERT INTO employees VALUES
(1010,'Ä“¡','saito','‰c‹Æ',1007,to_date('2001-12-17','yyyy-mm-dd'),150000,0,30);
INSERT INTO employees VALUES
(1011,'‰Á“¡','kato','Ž––±',1009,to_date('2006-10-21','yyyy-mm-dd'),110000,NULL,20);
INSERT INTO employees VALUES
(1012,'‹g“c','yoshida','Ž––±',1007,to_date('2009-03-13','yyyy-mm-dd'),295000,NULL,30);
INSERT INTO employees VALUES
(1013,'ŽR“c','yamada','Žå”C',1005,to_date('2001-03-13','yyyy-mm-dd'),280000,NULL,20);
INSERT INTO employees VALUES
(1014,'²X–Ø','sasaki','Ž––±',1008,to_date('2004-05-02','yyyy-mm-dd'),230000,NULL,10);

CREATE TABLE salgrades
( grade CHAR(1) CONSTRAINT pk_grade PRIMARY KEY,
losal NUMBER(7),
hisal NUMBER(7));

INSERT INTO salgrades VALUES ('A',100000,190000);
INSERT INTO salgrades VALUES ('B',190001,280000);
INSERT INTO salgrades VALUES ('C',280001,370000);
INSERT INTO salgrades VALUES ('D',370001,460000);
INSERT INTO salgrades VALUES ('E',460001,999999);

CREATE TABLE customers
(custno NUMBER(5) CONSTRAINT cust_pk PRIMARY KEY,
cname VARCHAR2(20),
address VARCHAR2(30),
phone VARCHAR2(12),
credit_rating VARCHAR2(6));

INSERT INTO customers VALUES (1000,'•iì¤Ž–','“Œ‹ž“s`‹æ‚P|‚˜|‚˜','03-1234-xxxx','—D—Ç');
INSERT INTO customers VALUES (1001,'‰¡•l¤“X','‰¡•lŽsˆéŽq‹æ‚Q|‚˜|‚˜','045-753-xxxx','—v’ˆÓ');
INSERT INTO customers VALUES (1002,'ìŒû‚â','ìŒûŽs–{’¬‚P|‚˜|‚˜‚˜','048-336-xxxx','—v’ˆÓ');
INSERT INTO customers VALUES (1003,'›~¤“X','‰¡•lŽs’ߌ©‹æ‚Q|‚˜‚˜','045-505-xxxx','—Ç');
INSERT INTO customers VALUES (1004,'ìèƒXƒgƒA','ìèŽsìè‹æ‚P‚O|‚˜‚˜','044-567-xxxx','—D—Ç');
INSERT INTO customers VALUES (1005,'‚c‚aƒ}[ƒg','“Œ‹ž“s”‹´‹æ‚X|‚˜‚˜','03-3334-xxxx','—D—Ç');
INSERT INTO customers VALUES (1006,'‘åŽè’¬•¶‹ï','“Œ‹ž“sç‘ã“c‹æ‚P|‚˜|‚˜','03-2236-xxxx','—Ç');
INSERT INTO customers VALUES (1007,'ƒoƒ‰ƒGƒeƒBƒOƒbƒY','‚³‚¢‚½‚ÜŽs’†‰›‹æ‚˜‚˜‚˜','048-556-xxxx','—Ç');
INSERT INTO customers VALUES (1008,'ƒ[ƒ‹ƒhƒXƒgƒA','‰¡•lŽs_“ސì‹æ‚˜‚˜|‚˜','045-654-xxxx','—v’ˆÓ');
INSERT INTO customers VALUES (1009,'‚c‚aƒXƒgƒA','“Œ‹ž“sa’J‹æ‚˜‚˜|‚˜‚˜','03-5789-xxxx','—v’ˆÓ');

CREATE TABLE products
(PRODNO CHAR(3) CONSTRAINT PROD_PK PRIMARY KEY,
PNAME VARCHAR2(30),
PRICE NUMBER(6));

INSERT INTO products VALUES ('A01','100‰~ƒ{[ƒ‹ƒyƒ“',100);
INSERT INTO products VALUES ('A02','c‹­ƒVƒƒ[ƒvƒyƒ“ƒVƒ‹',100);
INSERT INTO products VALUES ('A03','10Fƒ{[ƒ‹ƒyƒ“',300);
INSERT INTO products VALUES ('A04','Å‚‹‰–œ”N•M',1000);
INSERT INTO products VALUES ('A05','‚È‚È‚¢‚뉔•M',30);
INSERT INTO products VALUES ('A06','Œ’Nƒ{[ƒ‹ƒyƒ“',500);

INSERT INTO products VALUES ('B01','–³’nA4ƒm[ƒg',160);
INSERT INTO products VALUES ('B02','ƒƒ‹ƒwƒ“A4ƒm[ƒg',160);
INSERT INTO products VALUES ('B03','‰¼–ʃ‰ƒCƒ_[ƒƒ‚’ ',150);
INSERT INTO products VALUES ('B04','ˆÃ‹LƒXƒ€[ƒYƒm[ƒg',200);
INSERT INTO products VALUES ('B05','–³’nB5ƒm[ƒg',160);
INSERT INTO products VALUES ('B06','ƒ|ƒPƒ‚ƒ“B5ƒm[ƒg',160);

INSERT INTO products VALUES ('C01','ƒLƒŒƒCˆóüA4—pŽ†',500);
INSERT INTO products VALUES ('C02','ƒLƒŒƒCˆóüB5—pŽ†',500);
INSERT INTO products VALUES ('C03','ƒLƒŒƒCˆóüA3—pŽ†',600);
INSERT INTO products VALUES ('C04','ƒ\ƒRƒ\ƒRƒLƒŒƒCA4—pŽ†',350);
INSERT INTO products VALUES ('C05','ƒ\ƒRƒ\ƒRƒLƒŒƒCB5—pŽ†',350);
INSERT INTO products VALUES ('C06','–Ú‚É—D‚µ‚¢A4—pŽ†',400);

INSERT INTO products VALUES ('D01','‚Ë‚è‚Ë‚èÁ‚µƒSƒ€',50);
INSERT INTO products VALUES ('D02','‚È‚ñ‚Å‚àÁ‹ŽÁ‚µƒSƒ€',100);
INSERT INTO products VALUES ('D03','ƒLƒGƒi[ƒCÁ‚µƒSƒ€',200);
INSERT INTO products VALUES ('D04','100%ƒ}ƒbƒVƒC³‰t',350);

INSERT INTO products VALUES ('D15','ƒJƒŒ[‚̍‚èÁ‚µƒSƒ€',80);
INSERT INTO products VALUES ('D16','‚¢‚¿‚²‚̍‚èÁ‚µƒSƒ€',80);

CREATE TABLE orders
(ordno NUMBER(8) CONSTRAINT ORD_PK PRIMARY KEY,
custno NUMBER(5) CONSTRAINT ORD_CUST_FK REFERENCES customers(CUSTNO),
date_ordered DATE,
date_shipped DATE,
salesman_no NUMBER(4) CONSTRAINT ord_emp_fk REFERENCES employees(empno),
payment_type VARCHAR2(10));

INSERT INTO orders VALUES (1,1001,'2009-12-20','2009-12-27',1003,'ƒNƒŒƒWƒbƒg');
INSERT INTO orders VALUES (2,1001,'2009-12-21','2009-12-27',1003,'ƒNƒŒƒWƒbƒg');
INSERT INTO orders VALUES (3,1001,'2010-01-10','2010-01-17',1003,'ƒNƒŒƒWƒbƒg');
INSERT INTO orders VALUES (4,1002,'2010-01-11','2010-01-18',1010,'ƒNƒŒƒWƒbƒg');
INSERT INTO orders VALUES (5,1008,'2010-01-15','2010-01-22',1003,'ƒNƒŒƒWƒbƒg');
INSERT INTO orders VALUES (6,1005,'2010-01-20','2010-01-27',1003,'ƒNƒŒƒWƒbƒg');
INSERT INTO orders VALUES (7,1007,'2010-01-22','2010-01-29',1006,'ƒNƒŒƒWƒbƒg');
INSERT INTO orders VALUES (8,1006,'2010-01-22','2010-01-29',1010,'Œ»‹à');
INSERT INTO orders VALUES (9,1007,'2010-01-25','2010-02-03',1006,'ƒNƒŒƒWƒbƒg');
INSERT INTO orders VALUES (10,1003,'2010-02-15','2010-02-22',1003,'ƒNƒŒƒWƒbƒg');
INSERT INTO orders VALUES (11,1007,'2010-02-20','2010-02-27',1006,'ƒNƒŒƒWƒbƒg');
INSERT INTO orders VALUES (12,1006,'2010-03-16',null,1010,'Œ»‹à');
INSERT INTO orders VALUES (13,1009,'2010-04-02',null,1006,'Œ»‹à');

CREATE TABLE ord_details
(ordno NUMBER(8) CONSTRAINT ord_det_ord_fk REFERENCES orders(ordno),
prodno CHAR(3) CONSTRAINT ord_det_prod_fk REFERENCES products(prodno),
quantity NUMBER(5),
CONSTRAINT ord_det_pk PRIMARY KEY(ordno,prodno));

INSERT INTO ord_details VALUES (1,'A02',30);
INSERT INTO ord_details VALUES (1,'C01',20);
INSERT INTO ord_details VALUES (2,'B01',5);
INSERT INTO ord_details VALUES (2,'B06',10);
INSERT INTO ord_details VALUES (2,'B02',10);
INSERT INTO ord_details VALUES (2,'A01',5);
INSERT INTO ord_details VALUES (3,'C01',10);
INSERT INTO ord_details VALUES (3,'C02',10);
INSERT INTO ord_details VALUES (3,'A04',10);
INSERT INTO ord_details VALUES (3,'B01',20);
INSERT INTO ord_details VALUES (4,'A01',10);
INSERT INTO ord_details VALUES (4,'B01',5);
INSERT INTO ord_details VALUES (4,'A02',10);
INSERT INTO ord_details VALUES (5,'B06',15);
INSERT INTO ord_details VALUES (5,'B01',15);
INSERT INTO ord_details VALUES (6,'A01',30);
INSERT INTO ord_details VALUES (6,'B06',20);
INSERT INTO ord_details VALUES (6,'A04',20);
INSERT INTO ord_details VALUES (6,'A02',50);
INSERT INTO ord_details VALUES (6,'B01',20);
INSERT INTO ord_details VALUES (7,'A01',10);
INSERT INTO ord_details VALUES (7,'A02',5);
INSERT INTO ord_details VALUES (7,'B01',8);
INSERT INTO ord_details VALUES (8,'B06',5);
INSERT INTO ord_details VALUES (8,'B02',5);
INSERT INTO ord_details VALUES (9,'A01',10);
INSERT INTO ord_details VALUES (9,'D01',30);
INSERT INTO ord_details VALUES (9,'D15',30);
INSERT INTO ord_details VALUES (10,'B06',30);
INSERT INTO ord_details VALUES (10,'C02',50);
INSERT INTO ord_details VALUES (10,'A01',10);
INSERT INTO ord_details VALUES (11,'A02',50);
INSERT INTO ord_details VALUES (11,'B01',20);
INSERT INTO ord_details VALUES (11,'D01',10);
INSERT INTO ord_details VALUES (11,'B02',5);
INSERT INTO ord_details VALUES (12,'C02',10);
INSERT INTO ord_details VALUES (12,'A05',10);
INSERT INTO ord_details VALUES (12,'D16',20);
INSERT INTO ord_details VALUES (12,'D04',10);
INSERT INTO ord_details VALUES (12,'B02',15);
INSERT INTO ord_details VALUES (13,'A01',20);
INSERT INTO ord_details VALUES (13,'A02',25);

SPOOL off
```

[nao085]

申し訳ございません、cretab,sqlの内容を含めると1万字以内に収めることができませんでした。

[nao085]

それは勉強する意味もないと言うことでしょうか、、、？

[Orlofsky]

勉強する意味はありますが、資格としての価値はないから受験料は無駄だと思った方が良いです。資格テストも収益の一部ですからOracle社はBronzeなどの資格を作っただけです。

激しく文字化けしているので、エディタでエンコードを変えてみては？
書籍の後ろの方に著者や出版元が書いてあるでしょうから、問い合わせた方が良いかも？

>CONNECT ora01/oracle
が失敗してそれ以下全部エラーになっています。

SP2-0640: Not connected を以下何行続くとでも変えて、各テーブルのINSERTも最初の5件とそれに外部キーでつながっている分だけにけずるなどしてなるべく質問にまとめては？

Answer 1

参考のURLにあるように以下の@マーク以降をつけてsqlplusを起動しているのでしょうか？

sqlplus system/'パスワード'@//localhost:1521/ORCLPDB1

以下の文で接続し直すときに、@マーク以降の指定がないために接続に失敗するのだと思います。

CONNECT ora01/oracle

Comments

[nao085]

文字コードをUTF-8からShift JISに変換し、下記の部分に接続先を指定して再度実行したところ、サンプルデーターの表を作成することができました。
```sql
CONNECT ora01/oracle
```

Answer 2

文字化けしているようですね。
cretab.sqlをテキストエディタで開いて文字コードを確認してみては。