Table import - question
oracle 8.1.7 advance server linux
I exported a single table from a schema. schema name - prontomsp
The export dump file was 838mb
server ip address - 192.168.1.155
i tried importing in to 192.168.1.109
schema name is same
The free space in the msp schema is 8.4 gb
but still when i started the import it says uable to create initial extent in tablespace prontomsp.
free space availabe in 109 server is in GBs.
default tablespace is prontomsp
temporary tablespace is temp
for both the schemas in 155 and 109 server.
my question is why it is not importing smoothly thiough it has 8.4 gb free space.
Is this tablespace a new tablespace or a tablespace which already has database objects in it.
If it already has objects, then your import may not be finding continous free space of size set in the initial extent in the export file.
U can take dump of only the DDL command from your export dump and change the storage paramters and run the script and after that run the export with ignore=y parameter.
it is not a new tablespace
It has objects and the same table, i dropped the table and want to import the table from the dump
After you have dropped all the objects in the tablespace issue
alter tablespace tablespace_name coalesce;
and try your import command.
Click Here to Expand Forum to Full Width