Re: Export/import table(s) from one DB to another

You have to create first table structure on destination DB before importing data.
You can reach this with a create script, that is generated by a tool or a DB-export from source DB without data. This script you can edit, change the tablespaces and run it on destination-DB. Last step is to import data finally.
I hope this helps.
Reinhard

Vaclav Pavelka schrieb:
>
> Hello,
> i'm novic in Oracle server and i have the problem with exoporting table
> from one db to another:
> In the first DB is table in tablespace system and owner is i.e. test1 (
> its default tablespace is system).
> In the second DB i want to import table to the user test2, which
> default tablespace is user.
> The problem is: exporting table ( but it's the same for more tables) has
> sql command create table xxx (.......) in tablespace system and that
> failed, because in the second DB user test2 has no permissins to write
> to the system tablespace.
> In export procedure i can't say to export it without saying what
> tablespace it was.
> In administrators guide is written:
> ******************************************************
> If a user’s quotas allow it, the user’s tables are imported into the
> same
> tablespace from which they were exported. However, if the tablespace
> no longer exists or the user does not have the necessary quota, the
> system uses the default tablespace for that user.
> ******************************************************
> But it doesn't work, it alaways wants to me to load it to the system
> tablespace.
> Is there any straight solution?
> Thanx
> Vaclav

-- 
MfG R.Wahl (ZV-807)
----------------------------------------------------
E-Mail_at_work: mailto:wahl_at_zv.fhg.de
E-Mail_at_home: mailto:ReinhardWahl_at_online.de
----------------------------------------------------
Website http://www.online.de/homepages/ReinhardWahl
----------------------------------------------------
    Hiermit widerspreche ich der Nutzung oder 
   Uebermittlung meiner Daten fuer Werbezwecke 
   oder fuer die Markt- oder Meinungsforschung 
  gemaess Par. 28 Abs. 3 Bundesdatenschutzgesetz.
----------------------------------------------------
Please do not use my E-Mail address for advertising!
----------------------------------------------------