Tablespace export/Import

[Former Member]

Hello

We need to export/import the SAP tablespace for reorganization (with long raw)

Our target tablespace size is 160GB.

We donot have single directory which contains 160 GB to export the tablespace.

But We have two export data directory size as below. 
Dir A.100Gb
Dir B.80GB. 
Export dir size cannot be increased.

Is ther any way in Brtools to export the tablespace into two directorry?. or any other split method?.

If yes Could you please let us know how to enter the two export dump directory in BRTOOLS?

7 ~ Export dump directory (dumpdir) . []

(The same export data, to be imported after drop the tablespace)

Thanks

Elumalai

[JPReyes]

Lets start by saying when data is exported it takes a lot less space (avg 4 to 1), as you are doing a full tablespace reorg your should be able to drop the old tablespace as soon as the export is finished.

take a full backup off your system and give it a go.

Regards

Juan

[Former Member]

Hi Juan,

Thank you for your response..

Brtools gives error message as below..

1 - Use direct path (direct) ................ [yes]
 2 - Export buffer size in KB (buffer) ....... [10240]
 3 - Compress table extents/data (compress) .. [yes]
 4 - Consistent export (consistent) .......... [yes]
 5 # Parallel degree (parallel) .............. [1]
 6 - Max. size of dump file in MB (filesize) . [145408]
 7 - Force table export (force) .............. [no]
 8 - EXP/EXPDP command (command) ............. [/oracle/<XXX>/102_64/bin/exp parfile=/oracle/<XXX>/sapreorg/segvhdzb/parfile.exp]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
BR0280I BRSPACE time stamp: 2011-09-22 06.43.05
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR1162W Total used spaces in tables to be exported greater than free space in dump directory /nnt, missing at least 14605.315 MB - export may fail
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

7 ~ Export dump directory (dumpdir) . [nnt] file system has 145 GB.

In this case, please advise how should i proceed ?.

Thanks

Malai

[former_member204746]

What is your ORacle version?

have a look at SAP note 646681 for long2lob conversion. This can be done online. Just create a new tablespace and move this table into that new tablespace.