Table import - question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Table import - question

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

    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.

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi,
    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.

    regards
    anandkl
    anandkl

  3. #3
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    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

  4. #4
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    After you have dropped all the objects in the tablespace issue
    alter tablespace tablespace_name coalesce;

    and try your import command.

    regards
    anandkl
    anandkl

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width