Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02216: tablespace name expected
- 2 Answers
- 13846 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-00457: Comparison text of CONTINUEIF LAST must have length 1 not number
LPX-00105: element "~S" is not empty as required by the DTD
ORA-38456: The attribute set "string" is in an inconsistent state.
ORA-12570: TNS:packet reader failure
ORA-31053: The value of the depth argument in the operator cannot be negative
KUP-02005: token too big
ORA-12086: table "string"."string" is not an object table
ORA-12910: cannot specify temporary tablespace as default tablespace
ORA-36988: (XSRELGID06) The related dimension of relation workspace object must be of type NUMBER.
ORA-02789: Maximum number of files reached
ORA-09930: LUB of two labels is invalid
NNL-00418: Attributes Mapped: number
Oracle Errors 
