Home » RDBMS Server » Backup & Recovery » transport_tablespace (Oracle 11gr2 standard edition, windows 2008)
transport_tablespace [message #637344] Fri, 15 May 2015 06:03 Go to next message
alimlim
Messages: 8
Registered: May 2015
Location: indonesia
Junior Member
hi,
I want to backup tablespace using "transport_tablespace"
and Oracle 11gR2 Standard edition

exp userid='system/password as sysdba' transport_tablespace=y tablespaces=test file=test.dmp log=test.log

and had error :
Connected to: Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
EXP-00017: feature "Export transportable tablespaces" is needed, but not present in database
ORA-00439: feature not enabled: Export transportable tablespaces
EXP-00000: Export terminated unsuccessfully


and when I am looking table v$option :
select * from v$option where parameter ='Export transportable tablespaces';


PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Export transportable tablespaces
FALSE


the result is : FALSE. May I change / update : TRUE using syntax :
update v$option value='TRUE' where parameter ='Export transportable tablespaces' ?

if no, how to solve this case ?
Re: transport_tablespace [message #637346 is a reply to message #637344] Fri, 15 May 2015 06:24 Go to previous messageGo to next message
John Watson
Messages: 7262
Registered: January 2010
Location: Global Village
Senior Member
You are trying to use the legacy exp utility. You need to use the Data Pump expdp utility.
Re: transport_tablespace [message #637347 is a reply to message #637346] Fri, 15 May 2015 06:27 Go to previous messageGo to next message
John Watson
Messages: 7262
Registered: January 2010
Location: Global Village
Senior Member
Sorry, I was wrong. Transportable tablespaces are an Enterprise Edition feature - so there is nothing you can do.
Re: transport_tablespace [message #637434 is a reply to message #637347] Sun, 17 May 2015 20:49 Go to previous messageGo to next message
alimlim
Messages: 8
Registered: May 2015
Location: indonesia
Junior Member
hi John,
thank you for your update, by the way, how I dump file for tablespace and size is : 900 gb. if I just use syntax :
exp userid='system/password as sysdba' tablespaces=test file=test.dmp log=test.log that is take a long time.

best regards,

alim
Re: transport_tablespace [message #637436 is a reply to message #637434] Sun, 17 May 2015 21:43 Go to previous messageGo to next message
BlackSwan
Messages: 25856
Registered: January 2009
Location: SoCal
Senior Member
Yes, exporting 900GB will take a while to complete
Re: transport_tablespace [message #637438 is a reply to message #637434] Mon, 18 May 2015 00:09 Go to previous message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Try to use data pump and parallel clause but anyway it will take hours.
And import will take days.

Previous Topic: RMAN-04004: error fro recovery catalog database
Next Topic: Online data backup solution?
Goto Forum:
  


Current Time: Wed Feb 21 09:06:55 CST 2018

Total time taken to generate the page: 0.01611 seconds