Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Commit with DDL statements - Data Definition Language

Status
Not open for further replies.
JulieG

JulieG

Programmer
Nov 6, 2000
1
US
We wrote a migration application for our current Oracle 8 database. This migration has multiple DDL statements, eg. CREATE TABLE, etc. Is there any way to do ROLLBACK when needed, since COMMIT is done implicitly with any DDL statements?

Please help!
 
Sort by date Sort by votes
No.
The closest thing to a ROLLBACK command w/ DDL is "DROP ....".
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
588
carp
carp
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
634
SkipVought
S
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
717
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
219
TheLazyPig
TheLazyPig
TheLazyPig
  • Locked
  • Question
Change format name with comma 1
Replies
3
Views
157
TheLazyPig
TheLazyPig

Part and Inventory Search

Sponsor

Back
Top