Yep, only DML statements can be rolled back. For DDL (Data Definition Language) statements Oracle issues an implicit COMMIT after the statement. The CREATE TABLE statement you issued to create table is a DDL so the table wont be erased.
You can find detailed explanation on transaction management in most of the database or Oracle books. Or you can refer to oracle manuals at the following site, once you sign up for OTN membership, which is free.
http://otn.oracle.com/docs/products/oracle9i/content.html Go to "Concepts" link, under "Books for the New Application Developer" on the following site, which contains a chapter on Transactions (Chapter 16):
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/nav/getting_started.htm Cheers,
Shaha