1 Reply Latest reply: Mar 20, 2007 3:23 PM by 3520 RSS

    copy tables

    567412
      How to copy set of tables from one database to another?Suppose I hv two databases one named scott and other named abha.How to migrate tables from scott database to abha?
        • 1. Re: copy tables
          3520
          export/import (or new brothers for 10g expdp/impdp) should work in most cases.
          Actually it seems you are speaking about schemas not databases, so if you have only some tables you can simply grant temporary privileges and issue create table as select * from. There should be problems with constraints and other schema objects though.
          But actually you'd better aks this question for example in database - general forum General Database Discussions because it has nothing to do with current forum.

          Gints Plivna
          http://www.gplivna.eu