Re: Copy schema without data

Sorry for the sender name, just set up my news account...

"news.magnet.ch >" <Raoul Minder<raoul_at_nospam.minder.name> schrieb im Newsbeitrag news:53b41$48b47eaf$d5bd8e11$20531_at_news.cyberlink.ch...
> Hi all
>
> Probably an easy question for an oracle dba or even power user:
>
> I would like to copy the data warehouse schema on my laptop for testing
> and developing our application.
> - Unfortunately I have a 80GB HD and the DWH contains a few 'tera'.
> - Fortunately, I don't need the data (ok perhaps a few master data). I
> need only the schema to avoid 'table not found' errors and so on.
>
> How can I copy all the tables (mat. views to be correct) without the data
> from our dwh? But please don't tell me to dump the whole thing and delete
> the data. DWH and networking team would kill me.
>
> Good news: no indices, no constraints, just 1 to 1 raw data dumped out of
> our business solution environment. But I only have access to mat. views
> and not to the tables directly.
>
> I tried a create table from select... that did the job more or less but I
> guess I can't trust it (do mat views identify their underlaying schema
> correctly?)
>
> Forgive a spoiled ms developer and thank you in advance
>
> Raoul
>
Received on Wed Aug 27 2008 - 00:11:14 CEST