µ±ÓÃ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;
ÓÉÓÚÓм¸¸öÓû§Í¬ÓÃÕâ¸ö±í¿Õ¼ä£¬¹Ê¶ø£¬Ö±½ÓÔö´óÕâ¸ö±í¿Õ¼äÁË¡£