Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: import with rows=N
On Sep 13, 10:20 am, Sidhu <amardeepsi..._at_gmail.com> wrote:
> Hi All
>
> I have full export of a database [Oracle 7] taken with rows=N option.
> Now I want to create the same database (structure only, as it doesnt
> contain the data) on some other machine [Oracle 10gR2]. For that I
> created a new database, then created tablespaces, of 150 MB each with
> auto extend on. Then ran the import with rows=N. I think as it carries
> all the extent information so it consumed the same space as original
> database [Actually that much space was not there on the machine, the
> tablespaces kept on growing till available space and then when the
> disk was full, import got terminated]. I want to import the structure
> only. Is there a workaround for the same.
>
> Thanks in advance
> Sidhu
After a bit of search I got a link to a disucssion on the very same
topic
http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/7f12020d4f15082c/b458731093e37339?lnk=gst&q=import+rows%3DN&rnum=1#b458731093e37339
There seems to be no direct workaround for the same thing :(
Thanks Everybody
Sidhu
Received on Thu Sep 13 2007 - 01:24:33 CDT