Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> import with rows=N

import with rows=N

From: Sidhu <amardeepsidhu_at_gmail.com>
Date: Wed, 12 Sep 2007 22:20:38 -0700
Message-ID: <1189660838.992959.304380@19g2000hsx.googlegroups.com>


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 Received on Thu Sep 13 2007 - 00:20:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US