Welcome to the Oracle Community Forum, interact with 2 million technical staff to enter the Oracle certification qualification exam: Oracle tablespace debugging vagvac1, TEMPORARY-DATA-DATAFILES-D: ORANT2, ROLLBACK-DATAUNLIMITEDAPPLY3, SYSTEM-DATAFILES-D: ORANTUNLIMITEDAPPLY4, SYSTEM-ROLL
Welcome to the Oracle Community Forum, interact with 2 million technical staff> enter Oracle certification qualification exam: Oracle tablespace debugging vag vac 1, TEMPORARY-DATA-DATAFILES-D: ORANT 2, ROLLBACK-data unlimited apply 3, SYSTEM-DATAFILES-D: orant unlimited apply 4, SYSTEM-ROLL
Welcome to the Oracle community forum and interact with 2 million technical staff> enter
Oracle certification qualification exam: Oracle tablespace debugging
Vag
Vac
1. TEMPORARY-DATA-DATAFILES-D: ORANT
2. ROLLBACK-DATA UNLIMITED APPLY
SYSTEM-DATAFILES-D: ORANT UNLIMITED APPLY
4. SYSTEM-rollback segaments RB_TEMP UNLIMITED APPLY
Vac Add User
Uppercase
*
*
Import
Imp80 userid = system/manager fromuser = * touser = * commit = y buffer = 4096000 file = g:/*. dmp
Export
Exp80 userid = */* file = e: \ 2011.dmp log = e: \ 2011.log
When the tmp error occurs, appropriately expand the created tablespace.