10GR2里的可传输表空间的实现步骤

最新推荐文章于 2019-04-28 15:49:57 发布
最新推荐文章于 2019-04-28 15:49:57 发布
阅读量141 收藏
点赞数
文章标签： 数据库
本文阐述的是将AIX上的transp_ts表空间传输到windows2003上的步骤流程。

1、在源数据库(AIX53, ORACLE10202)上备份出要导出的表空间
show">MARKETING@retail>show user;
USER is "MARKETING"
select">MARKETING@retail>select file_name from dba_data_files where tablespace_name='MARKETING_TPLAN';

FILE_NAME
--------------------------------------------------------------------------------------------------------------------------------
/oradata/market/marketing_tplan01.dbf
/oradata/market/marketing_tplan02.dbf
/oradata/market/marketing_tplan03.dbf

create">MARKETING@retail>create tablespace transp_ts datafile '/oradata/market/transp_ts01.dbf' size 100m;

Tablespace created.

create">MARKETING@retail>create tablespace transp_ts_idx datafile '/oradata/market/transp_ts_idx01.dbf' size 50m;

Tablespace created.

create">MARKETING@retail>create table custcardall_test tablespace transp_ts as select * from custcardall;

Table created.

create">MARKETING@retail>create index pk_custcardall_test on custcardall_test(monthdate,custid) tablespace transp_ts_idx;

Index created.

2
AIX Version 5
(C) Copyrights by IBM and by others 1982, 2005.
login: oracle
oracle's Password:
*******************************************************************************
* *
* *
* Welcome to AIX Version 5.3! *
* *
* *
* Please see the README file in /usr/lpp/bos for information pertinent to *
* this release of the AIX Operating System. *
* *
* *
*******************************************************************************
Last unsuccessful login: 公元2006年08月24日 星期四 09时05分32秒 on /dev/pts/0 from 172.16.2.213
Last login: 公元2006年09月07日 星期四 09时50分59秒 on 172_16_1_169_0 from 172.16.1.169:0

[YOU HAVE NEW MAIL]
$ exp tablespaces=transp_ts transport_tablespace=y file=/oralog/transp_ts.dmp log=/oralog/transp_ts.log

Export: Release 10.2.0.2.0 - Production on Thu Sep 7 17:15:53 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Username: / as sysdba

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...
EXP-00008: ORACLE error 29335 encountered
ORA-29335: tablespace 'TRANSP_TS' is not read only
ORA-06512: at "SYS.DBMS_PLUGTS", line 507
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
$


3、
alter">MARKETING@retail>alter tablespace transp_ts read only;

Tablespace altered.

4、
$ exp tablespaces=transp_ts transport_tablespace=y file=/oralog/transp_ts.dmp log=/oralog/transp_s.log
Export: Release 10.2.0.2.0 - Production on Thu Sep 7 17:18:00 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Username: / as sysdba

EXP-00004: invalid username or password
Username: / as sysdba

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Note: table data (rows) will not be exported -- 这里提示数据并未导出，但实际上，数据被导出。
About to export transportable tablespace metadata...
For tablespace TRANSP_TS ...
. exporting cluster definitions
. exporting table definitions
. . exporting table CUSTCARDALL_TEST
. exporting referential integrity constraints
. exporting triggers
. end transportable tablespace metadata export
Export terminated successfully without warnings.
$

2、由于源数据库是AIX系统，而目标数据库是WINDOWS，他们的字节顺序不一样。

col">BI_DATA2@bi>col platform_name for a40
SELECT">BI_DATA2@bi>SELECT d.PLATFORM_NAME, ENDIAN_FORMAT
2 FROM V$TRANSPORTABLE_PLATFORM tp, V$DATABASE d
3 WHERE tp.PLATFORM_NAME = d.PLATFORM_NAME;

PLATFORM_NAME ENDIAN_FORMAT
---------------------------------------- --------------
Microsoft Windows 64-bit for AMD Little

connect">BI_DATA2@bi>connect marketing@retail
Enter password: *********
Connected.
col">MARKETING@retail>col platform_name for a40
SELECT">MARKETING@retail>SELECT d.PLATFORM_NAME, ENDIAN_FORMAT
2 FROM V$TRANSPORTABLE_PLATFORM tp, V$DATABASE d
3 WHERE tp.PLATFORM_NAME = d.PLATFORM_NAME;

PLATFORM_NAME ENDIAN_FORMAT
---------------------------------------- --------------
AIX-Based Systems (64-bit) Big


这样，要实现表空间传输，必须转换数据文件中的字节顺序:

rman target /
convert tablespace transp_ts to platform 'Microsoft Windows 64-bit for AMD' format='/oralog/transp_ts_%N_%f';

AIX Version 5
(C) Copyrights by IBM and by others 1982, 2005.
login: oracle
oracle's Password:
*******************************************************************************
* *
* *
* Welcome to AIX Version 5.3! *
* *
* *
* Please see the README file in /usr/lpp/bos for information pertinent to *
* this release of the AIX Operating System. *
* *
* *
*******************************************************************************
Last unsuccessful login: 公元2006年08月24日 星期四 09时05分32秒 on /dev/pts/0 from 172.16.2.213
Last login: 公元2006年09月07日 星期四 17时15分38秒 on /dev/pts/2 from 172.16.2.213

$ rman target /

Recovery Manager: Release 10.2.0.2.0 - Production on Thu Sep 7 18:03:51 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: MARKET (DBID=4073719654)

RMAN> convert tablespace transp_ts to platform 'Microsoft Windows 64-bit for AMD' format='/oralog/
transp_ts_%N_%f';

Starting backup at 2006-09-07 18:04:47
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=910 devtype=DISK
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00109 name=/oradata/market/transp_ts01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/07/2006 18:04:51
ORA-19504: failed to create file "/oralog/transp_ts_TRANSP_TS_109"
ORA-27038: created file already exists
Additional information: 1

RMAN> host;

$ ls -lt
总计 59928
-rw-r--r-- 1 oracle system 22322 9月04 11时13 smit.log
-rw------- 1 oracle system 50375 8月23 11时14 mbox
drwxr-xr-x 3 oracle oinstall 256 8月18 10时34 tmp
-rw-r--r-- 1 oracle oinstall 21347 8月07 09时37 psvg1
-rw-r--r-- 1 oracle oinstall 21980 8月07 09时18 psvg
-rw-r--r-- 1 oracle oinstall 0 8月01 17时41 ttt
drwxr-xr-x 2 oracle system 4096 8月01 14时01 rman
-rw-r--r-- 1 oracle oinstall 25120633 7月28 09时41 core
-rw-r--r-- 1 oracle oinstall 41090 7月28 09时34 vmstat.txt
-rw-r--r-- 1 oracle system 5033 7月12 08时58 smit.script
-rw-r--r-- 1 oracle system 5695 7月12 08时58 smit.transaction
-rw-r--r-- 1 oracle oinstall 2907 7月02 06时16 sqlnet.log
-rw-r--r-- 1 oracle oinstall 98 6月06 10时13 log2.log
-rw-r----- 1 oracle oinstall 5327060 6月06 10时10 55.sql
drwx--x--x 2 oracle system 256 5月28 12时47 Mail
drwxr-xr-x 3 oracle system 256 5月28 12时42 oradata
drwxr-x--- 3 oracle system 256 5月28 12时42 admin
drwxr-x--- 3 oracle system 256 5月28 12时42 product
drwxr-x--- 66 oracle system 4096 5月28 12时42 OraHome_1
drwxr-x--- 3 oracle system 256 5月28 12时42 oracle
drwxr-xr-x 7 oracle system 4096 5月28 12时39 oraInventory
drwxr-xr-x 2 oracle system 4096 5月28 12时39 TT_DB
-rwxr--r-- 1 oracle system 175 5月28 12时39 startdb
-rwxr--r-- 1 oracle system 115 5月28 12时39 stopdb
-rwx--x--x 1 oracle system 21 5月28 12时39 today.sh
-rw-r--r-- 1 oracle system 109 5月28 12时39 topas.error
-rw-r--r-- 1 oracle system 816 5月28 12时39 upgrade_to_10202_run_root.sh.log
drwxr-xr-x 2 oracle system 256 5月28 12时38 lost+found
$ cd /oralog
$ ls -lt
总计 411424
drwxr-xr-x 2 oracle oinstall 4096 9月07 17时34 rmanspctlback
-rw-r--r-- 1 oracle oinstall 619 9月07 17时19 transp_s.log
-rw-r--r-- 1 oracle oinstall 8192 9月07 17时19 transp_ts.dmp
-rw-r--r-- 1 oracle oinstall 659 9月07 17时18 transp_t.log
-rw-r--r-- 1 oracle oinstall 514 9月07 17时16 transp_ts.log
drwxr-xr-x 2 oracle oinstall 4096 9月07 06时50 currrmanback
drwxr-xr-x 2 oracle oinstall 20480 9月07 06时14 rmanbacktrace
-rw-r----- 1 oracle oinstall 209723392 9月06 17时17 transp_ts_TRANSP_TS_109
-rw-r--r-- 1 oracle oinstall 8192 9月06 17时05 exp_transp_ts.dmp
drwxr-xr-x 3 oracle oinstall 4096 8月14 10时06 expdp
drwxr-xr-x 2 oracle oinstall 256 6月30 06时36 prevrmanback
-rw-r--r-- 1 oracle oinstall 243834 6月26 14时11 rman_debug.log
drwxr-xr-x 6 oracle oinstall 4096 5月10 09时07 bak
-rw-r--r-- 1 oracle oinstall 610024 4月14 19时42 upgrade.log
drwxr-xr-x 3 oracle oinstall 256 3月06 2006 log
drwxrwxr-x 2 oracle oinstall 256 3月02 2006 lost+found
$ rm transp_ts_TRANSP_TS_109
$ ls -lt
总计 1808
drwxr-xr-x 2 oracle oinstall 4096 9月07 17时34 rmanspctlback
-rw-r--r-- 1 oracle oinstall 619 9月07 17时19 transp_s.log
-rw-r--r-- 1 oracle oinstall 8192 9月07 17时19 transp_ts.dmp
-rw-r--r-- 1 oracle oinstall 659 9月07 17时18 transp_t.log
-rw-r--r-- 1 oracle oinstall 514 9月07 17时16 transp_ts.log
drwxr-xr-x 2 oracle oinstall 4096 9月07 06时50 currrmanback
drwxr-xr-x 2 oracle oinstall 20480 9月07 06时14 rmanbacktrace
-rw-r--r-- 1 oracle oinstall 8192 9月06 17时05 exp_transp_ts.dmp
drwxr-xr-x 3 oracle oinstall 4096 8月14 10时06 expdp
drwxr-xr-x 2 oracle oinstall 256 6月30 06时36 prevrmanback
-rw-r--r-- 1 oracle oinstall 243834 6月26 14时11 rman_debug.log
drwxr-xr-x 6 oracle oinstall 4096 5月10 09时07 bak
-rw-r--r-- 1 oracle oinstall 610024 4月14 19时42 upgrade.log
drwxr-xr-x 3 oracle oinstall 256 3月06 2006 log
drwxrwxr-x 2 oracle oinstall 256 3月02 2006 lost+found
$ exit
host command complete

RMAN> convert tablespace transp_ts to platform 'Microsoft Windows 64-bit for AMD' format='/oralog/
transp_ts_%N_%f';

Starting backup at 2006-09-07 18:05:47
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00109 name=/oradata/market/transp_ts01.dbf
converted datafile=/oralog/transp_ts_TRANSP_TS_109
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:07
Finished backup at 2006-09-07 18:05:55

RMAN>

3、将exp出来的dmp文件，rman转换后生成的文件传输到目标数据库。

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:Oracleproduct10.2.0db_1BIN>cd D:rmanbackupexpdpdataexpdpbackup

C:Oracleproduct10.2.0db_1BIN>d:

D:rmanbackupexpdpdataexpdpbackup>ftp 172.16.100.29
Connected to 172.16.100.29.
220 IBM3 FTP server (Version 4.2 Thu Jul 21 05:28:02 CDT 2005) ready.
User (172.16.100.29:(none)): oracle
331 Password required for oracle.
Password:
230-Last unsuccessful login: 公元2006年08月24日 星期四 09时05分32秒 on /dev/pts/0 from 172.16.2.
213
230-Last login: 公元2006年09月07日 星期四 18时10分43秒 on ftp from ::ffff:172.16.0.52
230 User oracle logged in.
ftp> cd /oralog
250 CWD command successful.
ftp> ls -lt
200 PORT command successful.
150 Opening data connection for /bin/ls.
total 206624
-rw-r--r-- 1 oracle oinstall 619 9月07 18时09 transp_s.log
-rw-r--r-- 1 oracle oinstall 8192 9月07 18时09 transp_ts.dmp
-rw-r----- 1 oracle oinstall 104865792 9月07 18时05 transp_ts_TRANSP_TS_109
drwxr-xr-x 2 oracle oinstall 4096 9月07 17时34 rmanspctlback
-rw-r--r-- 1 oracle oinstall 659 9月07 17时18 transp_t.log
-rw-r--r-- 1 oracle oinstall 514 9月07 17时16 transp_ts.log
drwxr-xr-x 2 oracle oinstall 4096 9月07 06时50 currrmanback
drwxr-xr-x 2 oracle oinstall 20480 9月07 06时14 rmanbacktrace
-rw-r--r-- 1 oracle oinstall 8192 9月06 17时05 exp_transp_ts.dmp
drwxr-xr-x 3 oracle oinstall 4096 8月14 10时06 expdp
drwxr-xr-x 2 oracle oinstall 256 6月30 06时36 prevrmanback
-rw-r--r-- 1 oracle oinstall 243834 6月26 14时11 rman_debug.log
drwxr-xr-x 6 oracle oinstall 4096 5月10 09时07 bak
-rw-r--r-- 1 oracle oinstall 610024 4月14 19时42 upgrade.log
drwxr-xr-x 3 oracle oinstall 256 3月06 2006 log
drwxrwxr-x 2 oracle oinstall 256 3月02 2006 lost+found
226 Transfer complete.
ftp: 1160 bytes received in 0.08Seconds 14.87Kbytes/sec.
ftp> bin -- 记住使用二进制方式传送
200 Type set to I.
ftp> get transp_ts.dmp
200 PORT command successful.
150 Opening data connection for transp_ts.dmp (8192 bytes).
226 Transfer complete.
ftp: 8192 bytes received in 0.00Seconds 8192000.00Kbytes/sec.
ftp> get transp_ts.log
200 PORT command successful.
150 Opening data connection for transp_ts.log (514 bytes).
226 Transfer complete.
ftp: 514 bytes received in 0.03Seconds 16.58Kbytes/sec.
ftp>


C:Oracleproduct10.2.0db_1BIN>cd D:rmanbackupexpdpdataexpdpbackup

C:Oracleproduct10.2.0db_1BIN>d:

D:rmanbackupexpdpdataexpdpbackup>ftp 172.16.100.29
Connected to 172.16.100.29.
220 IBM3 FTP server (Version 4.2 Thu Jul 21 05:28:02 CDT 2005) ready.
User (172.16.100.29:(none)): oracle
331 Password required for oracle.
Password:
230-Last unsuccessful login: 公元2006年08月24日 星期四 09时05分32秒 on /dev/pts/0 from 172.16.2.
213
230-Last login: 公元2006年09月07日 星期四 18时18分31秒 on ftp from ::ffff:172.16.0.52
230 User oracle logged in.
ftp> cd /oralog
250 CWD command successful.
ftp> ls -lt
200 PORT command successful.
150 Opening data connection for /bin/ls.
total 206624
-rw-r--r-- 1 oracle oinstall 619 9月07 18时09 transp_s.log
-rw-r--r-- 1 oracle oinstall 8192 9月07 18时09 transp_ts.dmp
-rw-r----- 1 oracle oinstall 104865792 9月07 18时05 transp_ts_TRANSP_TS_109
drwxr-xr-x 2 oracle oinstall 4096 9月07 17时34 rmanspctlback
-rw-r--r-- 1 oracle oinstall 659 9月07 17时18 transp_t.log
-rw-r--r-- 1 oracle oinstall 514 9月07 17时16 transp_ts.log
drwxr-xr-x 2 oracle oinstall 4096 9月07 06时50 currrmanback
drwxr-xr-x 2 oracle oinstall 20480 9月07 06时14 rmanbacktrace
-rw-r--r-- 1 oracle oinstall 8192 9月06 17时05 exp_transp_ts.dmp
drwxr-xr-x 3 oracle oinstall 4096 8月14 10时06 expdp
drwxr-xr-x 2 oracle oinstall 256 6月30 06时36 prevrmanback
-rw-r--r-- 1 oracle oinstall 243834 6月26 14时11 rman_debug.log
drwxr-xr-x 6 oracle oinstall 4096 5月10 09时07 bak
-rw-r--r-- 1 oracle oinstall 610024 4月14 19时42 upgrade.log
drwxr-xr-x 3 oracle oinstall 256 3月06 2006 log
drwxrwxr-x 2 oracle oinstall 256 3月02 2006 lost+found
226 Transfer complete.
ftp: 1160 bytes received in 0.03Seconds 36.25Kbytes/sec.
ftp> bin
200 Type set to I.
ftp> get transp_ts_TRANSP_TS_109
200 PORT command successful.
150 Opening data connection for transp_ts_TRANSP_TS_109 (104865792 bytes).
226 Transfer complete.
ftp: 104865792 bytes received in 0.94Seconds 111797.22Kbytes/sec.
ftp> quit
221 Goodbye.

D:rmanbackupexpdpdataexpdpbackup>


4、在目标数据库上，转换表空间文件。

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.


C:Oracleproduct10.2.0db_1BIN>rman target /

Recovery Manager: Release 10.2.0.2.0 - Production on Thu Sep 7 18:23:13 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: NCBI (DBID=4003700673)

RMAN> convert datafile 'D:rmanbackupexpdpdataexpdpbackuptransp_ts_TRANSP_TS_109'
2> db_file_name_convert 'D:rmanbackupexpdpdataexpdpbackuptransp_ts_TRANSP_TS_109',
3> 'D:oradatancbitransp_ts01.dbf';

Starting backup at 2006-09-07 18:23:24
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=20 devtype=DISK
channel ORA_DISK_1: starting datafile conversion
input filename=D:RMANBACKUPEXPDPDATAEXPDPBACKUPTRANSP_TS_TRANSP_TS_109
converted datafile=D:ORADATANCBITRANSP_TS01.DBF
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:08
Finished backup at 2006-09-07 18:23:34

RMAN> exit


Recovery Manager complete.

5、导入表空间。
C:Oracleproduct10.2.0db_1BIN>imp tablespaces=transp_ts transport_tablespace=y file=D:rmanbac
kupexpdpdataexpdpbackuptransp_ts.dmp log=D:rmanbackupexpdpdataexpdpbackuptransp_ts.log data
files='D:oradatancbiTRANSP_TS01.DBF'

Import: Release 10.2.0.2.0 - Production on Thu Sep 7 18:25:07 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
About to import transportable tablespace(s) metadata...
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing SYS's objects into SYS
. importing SYS's objects into SYS
. importing MARKETING's objects into MARKETING
. . importing table "CUSTCARDALL_TEST"
. importing SYS's objects into SYS
Import terminated successfully without warnings.

C:Oracleproduct10.2.0db_1BIN>


到数据库里查，发现对象已经导入。
select">NCBI@NCBI>select owner from dba_tables where table_name='CUSTCARDALL_TEST';

OWNER
------------------------------
MARKETING

再测试
drop">NCBI@NCBI>drop user marketing cascade;

User dropped.

drop">NCBI@NCBI>drop tablespace transp_ts;

Tablespace dropped.

NCBI@NCBI>

C:Oracleproduct10.2.0db_1BIN>imp tablespaces=transp_ts transport_tablespace=y file=D:rmanbac
kupexpdpdataexpdpbackuptransp_ts.dmp log=D:rmanbackupexpdpdataexpdpbackuptransp_ts.log data
files='D:oradatancbiTRANSP_TS01.DBF'

Import: Release 10.2.0.2.0 - Production on Thu Sep 7 18:27:46 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
About to import transportable tablespace(s) metadata...
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing SYS's objects into SYS
. importing SYS's objects into SYS
IMP-00017: following statement failed with ORACLE error 29342:
"BEGIN sys.dbms_plugts.checkUser('MARKETING'); END;"
IMP-00003: ORACLE error 29342 encountered
ORA-29342: user MARKETING does not exist in the database
ORA-06512: at "SYS.DBMS_PLUGTS", line 1895
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully

create">NCBI@NCBI>create user marketing identified by "1";

User created.

C:Oracleproduct10.2.0db_1BIN>imp tablespaces=transp_ts transport_tablespace=y file=D:rmanbac
kupexpdpdataexpdpbackuptransp_ts.dmp log=D:rmanbackupexpdpdataexpdpbackuptransp_ts.log data
files='D:oradatancbiTRANSP_TS01.DBF'

Import: Release 10.2.0.2.0 - Production on Thu Sep 7 18:29:42 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
About to import transportable tablespace(s) metadata...
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing SYS's objects into SYS
. importing SYS's objects into SYS
. importing MARKETING's objects into MARKETING
. . importing table "CUSTCARDALL_TEST"
. importing SYS's objects into SYS
Import terminated successfully without warnings.

C:Oracleproduct10.2.0db_1BIN>


6、查看表空间上的对象。
select">NCBI@NCBI>select * from dba_ts_quotas where username='MARKETING';

no rows selected

select">NCBI@NCBI>select owner, segment_name from dba_segments where tablespace_name='TRANSP_TS';

OWNER SEGMENT_NAME
-------------------- ------------------------------------------------------------------
MARKETING CUSTCARDALL_TEST

select">NCBI@NCBI>select tablespace_name, plugged_in from dba_tablespaces where tablespace_name
2 in ('TRANSP_TS','USERS');

TABLESPACE_NAME PLU
------------------------------ ---
TRANSP_TS YES
USERS NO

alter">NCBI@bi>alter tablespace transp_ts read write;

Tablespace altered.

NCBI@bi>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/1112/viewspace-103723/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/1112/viewspace-103723/

cuiyefei0265
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle19504,ORA-19504: failed to create file "" 一则案例
weixin_42120563的博客
04-03 1469
今天检查自己测试库的时候，发现日志狂报ORA-19504: failed to create file ""Thread 1 advanced to log sequence 156 (LGWR switch)Current log# 3 seq# 156 mem# 0: +DATA/netdata/onlinelog/group_3.261.882674015Tue Jul 14 14:01:0...
【ORA】ORA-19504: failed to create file +DATA/orcl/controlfile/control01
debimeng
02-11 3610
ORA-19504: failed to create file "+DATA/orcl/controlfile/control01.ctl"场景：在单实例环境通过rman备份的控制文件，拷贝到rac下执行下面的还原语句RMAN> restore controlfile from '/oradata/CONTROL_0BSQVKUC_1_1'; Starting restore at 20...
RMAN备份时报“ORA-19504: failed to create file”和“ORA-27038: created file already exists”的一种情况和解决办法
t0nsha's Blog
06-02 1万+
版本：SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionPL/SQL
ftp出现150 Opening ASCII mode data connection for /bin/ls
奋斗鱼
04-28 2万+
出现此提示是在FTP连接时，因为服务端使用了主动模式。 此时客户端可以用账号密码正常登录，但在执行dir 或ls 显示文件列表目录时出现上述提示，命令卡在这里不动了。 服务端FTP的主动模式：客户端通过21端口PORT即主动模式连接服务端，连接并登录成功后，执行dir时，服务端会主动连接客户端的指定端口，如果客户端有防火墙或没有固定IP(也没做路由器映射)，就会出现上述问题。 被动模式：客户端通...
ftp错误150 Opening ASCII mode data connection for /bin/ls.
热门推荐
wxqian25的专栏
11-19 4万+
dos 下ftp默认为port主动模式，如果客户端pc所在网络有防火墙，则ftp server在数据传输时，就不能连接到client，会报 150 Opening ASCII mode data connection for /bin/ls. 解决： 改用passive模式进行数据传输。
oracle定时备份压缩的实现步骤
12-15
export ORACLE_HOME=$ORACLE_BASE/ora10gr2/db_1 # 根据实际路径修改 export PATH=$ORACLE_HOME/bin:$PATH d=$(date '+%d') # 获取当前日期的两位数表示 # 数据库用户metabase的导出 exp metabase/metabase@dskdb ...
Oracle RAC10gR2 安装
02-15
Oracle RAC 10gR2 (Real Application Clusters) 是一种高可用性和可扩展性的数据库解决方案，允许多个实例在共享存储上同时访问一个数据库，从而实现故障切换和负载均衡。John Lee作为合作伙伴销售顾问，提供了关于...
exp导出oracle数据库因为字符设置报错，解决方法。
风风羊
07-08 1682
 由于在安装oracle9i时不慎选错了字符集，然后手动update props$表修改了字符集（手动修改props$是oracle7的招数，在oracle8和oracle9中虽然也能修改，但是会留下修改不干净的隐患）首先，确认字符集是否修改的不彻底。用exp导出会出现错误如：[oracle@TestAs4 ~]$  exp system/XXXXXX wner=cwm file=1227.dmp...
ftp 上传文件
chichimanman的专栏
09-19 800
 Microsoft Windows [版本 6.1.7601] 版权所有 (c) 2009 Microsoft Corporation。保留所有权利。 C:\Users\Administrator>ftp ftp> open 173.1.3.87 连接到 173.1.3.87。 220 wmstest FTP server (Version 4.2 Wed Oct 1 09:40
ftp 150 Opening ASCII mode data connection for /bin/ls.
Tanbin_的博客
01-05 7561
用cmd命令窗口时，登录了ftp。但是用dir命令的时候，报了150的错。 C:\Users\20160920>ftp ftp> open 211.149.191.240 连接到 211.149.191.240。 220 Serv-U FTP Server v15.0 ready... 用户(211.149.191.240
解决FTPClient不能访问文件的问题150 Opening ASCII mode data connection
zll131609的专栏
07-17 3万+
问题描述 我使用的FTPClient：import org.apache.commons.net.ftp.FTPClient; java中下载FTP文件，但是 FTP登录成功，FTPClient访问文件，却卡住。 代码（伪代码）： boolean res = f.login(); FTPFile[] list = f.ftp.listFiles("/"); 打印日志： 22
exp-00056 exp-00000 导出终止失败的处理
02-28 968
C:\Users\dell>exp ufgov/ufgov@orcl file=d:\hddatabackup\ufgov_20130228.dmp log=d:\hddatabackup\ufgov_20130228.l...
10g的exp出数据出现“Export terminated successfully with warnings”
Focus on Minds
05-08 4080
1、导出exp用法[oracle@ocmserver]exp help=yExport: Release 10.2.0.1.0 - Production on Mon Nov 26 22:53:41 2012Copyright (c) 1982, 2005, Oracle.    All rights reserved.You can let Export prompt you for param
Oracle导入数据imp的时候：Import terminated successfully with warnings.
谢彬のCSDN专栏
11-13 1万+
今天用imp、导入数据的时候：提示Import terminated successfully with warnings. 然后检查语法什么的没什么问题，然后就是倒不进去 后面同事提醒了下，是不是表没有删除？ 所噶，恍然大悟。仅仅是truncate是不够的  解决办法：删除表
Oracle 10gR2在AIX 5L上详尽安装教程
Oracle 10gR2数据库在IBM AIX 5上的详细安装步骤指南深入探讨了如何在IBM AIX 5L操作系统环境下部署和配置Oracle 10.2.0.1版本的数据库。这份文档详细记录了一个实际工程实例，包括一系列关键步骤： 1. **系统准备*...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值