Arek Kasprzyk wrote:
sorry you misunderstood me :) of course it does not have to be in the
same schema. (it could be) but normally it ends up in a separate schema.
Hi Arek,
Ok, now it makes more sense. I noticed the queries use the
schema.tablename convention to allow you to query on a different schema.
however the SQL statements there which do the transform and being
executed ( eg "CREATE TABLE mart_shema.new_table as SELECT FROM
source_schema.table_a, source_schema.table_b ... etc")
assume this is run on the same platform
That's it, and because you're creating the new tables directly from a
select across schemas, it makes sense.
Now I don't understand why to create the temporary name TEMP0 if you're
renaming afterwards...
create table unimart.TEMP0 as select ... from RENATO1.CV_COMMENT_TOPICS;
alter table unimart.TEMP0 rename to C__CV_COMMENT_TOPICS__main;
Thanks,
--renato
--
Reclaim your digital rights, eliminate DRM, learn more at
http://www.defectivebydesign.org/what_is_drm
