Originally posted by stecal
You could also do "drop user username cascade;" and re-run your data load script or whatever you used to create the schema.
This is the way I'd choose. It's the "tidiest". If you are going to move the tables manually, remember to rebuilt associated indexes in appropriate tablespaces to.


Cheers,