Some folks think that DBAs and application developers inhabit different universes. At times this may seem to be the case, but the successful DBA must understand application development and the issues ...
If you want to take a copy of one table and make a copy of it in another schema (under another username), you can use the SQL*Plus COPY command, or a simple <code>"create table foo as select * from ...