Re: export/import to a smaller database

I think there is one way to to that.

But this method doesn't satisfy you, because you should make a script by yourself.

Anyway, the way is to use "create as select" command.

1. If you will import data into a difference database instance, then you have to create dabase link between databases. And you do command "create as select" as below.

create table small_size_table_name
as select * from large_size_table_name_at_db_link_name tablespace tablespace_name
storage (initial xxx next xxx);

If tow databases are in different server, it will take a long time to do a job becuase of N/W traffic.

2. If you will import data to a same database instance,then you do command "create as select" as below.

create table samll_size_table_name
as select * from large_size_table_name
tablespace tablespace_name
storage (initial xxx next xxx);

This method just import data except index.

I want that the above way helps you.

Bye.

S.R Lee Received on Thu Jan 07 1999 - 03:21:32 CST