Title: RE: Need help with a dynamic query
Since the target schema is the one whose columns matter most, I would think that you should do an outer join to the columns in the original schema, to see if any not null columns in the target schema are missing from the original schema
SELECT
'CREATE TABLE TMP_'||table_name||' TABLESPACE tables AS '||chr(10)||
'SELECT * FROM '||table_name||';'
from sys.all_tables where owner = 'yourowner';
Or add a @dblink
bob
This probably isnt that hard, but Im having a brain dead moment.
My goal is to select data from a table