Re: External tables - referencing for information warehouse



On Jan 30, 8:53 am, "Zachi" <zklop...@xxxxxxxxx> wrote:
if you would create another database on the same instance (let's call
it "images"), you can move the table there, either via unload/load or
direct insert:

insert into images:images_rec select * from images_rec

Then you can create a synonym to this table in the current database
via something like:

create synonym images_rec for images:images_rec;

and your software will not be affected. Backups via ontape will backup
all the data (including the images) since they are in the same
instance, while onload will only backup the database you want for
transfer to the reporting department.

Thanks Zachi - that is way more help than I was hoping for!

Appreciate it. I will review the CREATE SYNONYM options and test it
out in my training database.

.