Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL*Plus: RELEASE 11.1.0.7.0 - Production ON Fri Aug 7 22:09:14 2015
- Copyright (c) 1982, 2008, Oracle. ALL rights reserved.
- Connected.
- SQL>
- SQL> @ cr.TABLE.feedback.SQL
- SQL> DROP TABLE feedback;
- TABLE dropped.
- Elapsed: 00:00:01.17
- SQL> CREATE TABLE feedback
- 2 (
- 3 n NUMBER
- 4 );
- TABLE created.
- Elapsed: 00:00:00.06
- SQL>
- SQL>
- SQL> INSERT /*+ append */ INTO feedback
- 2 SELECT n
- 3 FROM feedbackstage;
- 1 ROW created.
- Elapsed: 00:49:28.54
- SQL> COMMIT;
- COMMIT complete.
- Elapsed: 00:00:00.30
- SQL> SELECT COUNT(*) FROM feedback;
- COUNT(*)
- ----------
- 4294967297
- Elapsed: 00:01:05.54
Advertisement
Add Comment
Please, Sign In to add comment