Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create tablespace of big size in a faster way

user12263161Jan 7 2013 — edited Jan 7 2013

Hi All,

I am trying to import the dump file taken from eport of 10g database.

I have an empty 11gr2 database right now. And to import the 10g expdp file, I need to have the similar tablespaces in the new database.

The problem I am facing here is that the tablespace size in the 10g database were very big eg. 50G +. To create this on the 11gr2 is taking lot of time.

Is there any other faster way of creating tablespaces? I am using the following command currently

create tablespace XXCS datafile '/database/main_db_dir/testdb/XXCS.dbf' size 40000M autoextend on;

Please suggest.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 4 2013

Added on Jan 7 2013

#general-database-discussions

7 comments

787 views