ORA-02216: tablespace name expected
- 2 Answers
- 14021 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Cause: A tablespace name is not present where required by
the syntax for one of the following statements: CREATE/DROP
TABLESPACE, CREATE TABLE, CREATE INDEX, or CREATE ROLLBACK
SEGMENT.
Action: Specify a tablespace name where required by the syntax.
Please add more information about this Error
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / steve
Solution:
----------------------------------------------------------
define DEFAULT_TABLESPACE_TABLE = AAAAA;
define DEFAULT_TABLESPACE_INDEX = AAAAA;
| Is This Answer Correct ? | 0 Yes | 0 No |
SQL*Loader-00950: Error shipping data structures across 2-task
ORA-22921: length of input buffer is smaller than amount requested
ORA-25530: FAST_START_MTTR_TARGET is not specified
EXP-00021: can only perform incremental export in Full Database mode
ORA-16047: DGID mismatch between destination setting and standby
PLS-00462: nested subprogram 'string' has to be REPEATABLE
ORA-09808: Could not obtain user clearance.
ORA-24760: invalid isolation level flags
EXP-00089: invalid FILE_FORMAT specification
ORA-13221: unknown geometry type in the geometry object
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
ORA-22167: given trim size [string] must be less than or equal to [string]
Oracle Errors 
