Thanks Shriyan,
I can't create a regular table because my group doesn't have the permissions. I will have to use a temp table and leave my session open while the testing completes. I could just unload the table to a file...
I discovered the lack of priveleges yesterday, however I was...
I need to create a temp table that has the same structure and some of the same values that are in another table (I'm going to do an update of the production table and want a copy of the original data).
I tried something like this, but it bombed
create temp table work_area as
select * from...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.