transport_tablespace [message #637344] |
Fri, 15 May 2015 06:03 |
|
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 ?
|
|
|
|
|
|
|
|