Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> import with rows=N
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
![]() |
![]() |