Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have uploaded a polyline data (50 million rows) to oracle spatial 10g as sdo_geometry through arccatalog and arcsde in my TEST database.

Now, I need to move this table to QA database, this table is not having any relationships with other table.

It took nearly 1 day to upload the data to TEST through arcsde. I want to do it using Oracle tools, which is the best method to copy/move this huge data with all informations like index, metadata etc., thanks, vadivelan. P

share|improve this question
    
Do you have access to FME? or Datapump will work as unicoletti mentions. –  Mapperz Apr 3 '12 at 13:26
add comment

1 Answer

up vote 0 down vote accepted

Oracle 10 introduced datapump which is a more flexible way of moving data in and out of an oracle database than its predecessor imp/exp.

Datapump supports spatial data, so you can use it and will move metadata, grants, indexes, etc.

To ensure that the move is as smooth as possible make sure that you have the same tablespaces in both databases and that the user doing the import has access to them or you will have to manually relocating them (as shown here) which is slow and error prone.

As for speed: I am afraid that one table with 50m rows will be slow and there is not much you can do about it, except maybe importing it without indexes and recreating them at the end.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.