Re: Newbie import export question

From: Chris Rodrigues <cr148_at_yahoo.com>
Date: 12 Sep 2001 16:54:07 -0700
Message-ID: <e1fa2ab9.0109121554.41dab9ef_at_posting.google.com>


"daniele stefanucci" <d.stefanucci_at_edisontel.it> wrote in message news:<nNEn7.2904$Wg4.12004191_at_news.edisontel.com>...
> Hi
> You can create the objects empty of the schema with the indexfile from
> import (change the tablespace parameter) , after
> you can import all objects's schema with ignore=y.
>
> Daniele Stefanucci
>
> "Arun" <arunbhat01_at_yahoo.com> ha scritto nel messaggio
> news:127e8357.0109110541.7c1569b7_at_posting.google.com...
> > I'm using Oracle 8i.
> > I want to export the schema of one tablespace into another tablespace
> > using the export-import utility.
> > Do you know how to do this?any websites?
> >
> > -Thanx
> > -arun

You can achive the same result by first changing the default tablespace of the concerned user and then importing the dump. If you only want the schema, then export the dump with rows=n. Received on Thu Sep 13 2001 - 01:54:07 CEST

Original text of this message