ºìÁªLinuxÃÅ»§
Linux°ïÖú

Oracle±í¿Õ¼äÕ¼Âú£¬µ¼ÖÂÎÞ·¨µ¼³öexpdp£¬µ¼Èëimpdp´íÎó

·¢²¼Ê±¼ä:2008-04-27 00:06:20À´Ô´:ºìÁª×÷Õß:chaian
µ±ÓÃexpdpµ¼³ö±¨µÄ´íÎ󣬺ó¹ûÊÇ£¬ÎÞ·¨µ¼³ö¡£

[oracle@orathiz dump]$ expdp shccb/shccb directory=dump_dir dumpfile=temp.dmp schemas=shccb

Export: Release 10.2.0.1.0 - 64bit Production on

All rights reserved.

Á¬½Óµ½: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options
ORA-31626: ×÷Òµ²»´æÔÚ
ORA-31633: ÎÞ·¨´´½¨Ö÷±í "SHCCB.SYS_EXPORT_SCHEMA_07"
ORA-06512: ÔÚ "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: ÔÚ "SYS.KUPV$FT", line 863
ORA-01658: ÎÞ·¨Îª±í¿Õ¼ä GLF2DATA ÖеĶδ´½¨ INITIAL Çø

¾­²é£ºÊÇÓÉÓÚ±í¿Õ¼äÎÞ·¨×Ô¶¯À©Õ¹£¬²¢ÇÒÒѾ­Õ¼Âú¡£ÈçÏ£¬×Ô¶¯À©Õ¹¹Ø±Õ״̬

CREATE TABLESPACE GLF2DATA DATAFILE
'/datas/apps/oracle/oradata/orathiz/GLF2DATA.dbf' SIZE 100M AUTOEXTEND OFF
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

½â¾ö·½·¨£º

1£ºÖ±½ÓÀ©´ó±í¿Õ¼ä±ä³É200M
ALTER DATABASE DATAFILE '/datas/apps/oracle/oradata/orathiz/GLF2DATA.dbf' RESIZE 200M;

2£º±í¿Õ¼ä¿ÉÒÔ×Ô¶¯À©Õ¹£¬Ã¿´ÎÔöÈݳߴçΪ50M£¬×î´óÀ©µ½1G
ALTER DATABASE DATAFILE '/datas/apps/oracle/oradata/orathiz/GLF2DATA.dbf' AUTOEXTEND ON NEXT 50M MAXSIZE 1G;

ÓÉÓÚÓм¸¸öÓû§Í¬ÓÃÕâ¸ö±í¿Õ¼ä£¬¹Ê¶ø£¬Ö±½ÓÔö´óÕâ¸ö±í¿Õ¼äÁË¡£
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 0 ÌõÆÀÂÛ