@wBob Similar but not too much, IMHO. I agree that the basic idea is the same, but the implementation is different enough to warrant a separate answer (again, IMHO), specifically the IDENTITY vs SEQUENCE bit.
@AndriyM Sure, I started to write the reset code, but it didn't look great. The sequence is quite a nice way of doing it, although I've heard they can be unreliable : )
By the way, there's another mistake in that answer. The sequence's start value is outside the minvalue..maxvalue range.
Since I never worked with sequences before, I wasn't sure if that would cause a compilation error, but I've since checked with the manual and now verified that it indeed won't compile.
But that's probably more in the nitpicking area. The OP has accepted the solution, so I guess the compilation error wasn't a problem for them to fix.
@AndriyM Yes. That needed fixing. I also added a date column. Seems a reasonable enough change since the author wrote "something like..." and that's likely to be more generally useful.
It is hard to give a definitive answer on this question until you actually find a difference. I have found none but that does not mean there is no difference only that I have not seen one in the tests I have made.
The easy test is for performance. Either getting the next value in a loop or using...
also, when you say "a ton of data" (a metric tonne?) how much exactly are we talking about? ie. number of rows, and average row size? Use the edit button to put these details into your question, please! — Max Vernon1 min ago
When copying database using SQL Developer it complaints that the source tablespace does not exist on destination database.
How can I copy schema and data from Database A tablespace t1 into Database B tablespace t2?
Note: I do not wish to use impdp.
When copying database using SQL Developer it complaints that the source tablespace does not exist on destination database.
How can I copy schema and data from Database A tablespace t1 into Database B tablespace t2?
Note: I do not wish to use impdp.
