Re: recreating table structure

If you have a database link to the central database you can use the following while connected to the local one:

Create table LocalTable as Select * from CentralTable_at_linkname where 1=2;

This will create the structure of the table without data since 1 never equals 2....

If you want to 'clone' the table, data and all, just eliminate the where clause...

"jAnO!" <j.j.groot_at_kpn.com> wrote:

>
>Chris Dyer <cjd1_at_duke.edu> wrote in message
>news:Pine.SOL.3.91.1000705112812.3295A-100000_at_teer9.acpub.duke.edu...
>> dear group,
>>
>> I need help! I need to recreate the structure of certain tables in a
>> central oracle database in a local oracle database. How can I retrieve
>> type information from oracle? I need to ask how wide a varchar2 field is
>> or how many digits a number has.
>>
>> Any help would be hugely appreciated!
>>
>> Chris
>
>describe table_name;
>
>should help you a bit
>
>greetz jan
>
Received on Thu Jul 06 2000 - 00:00:00 CDT