ORA-02216: tablespace name expected

Answers were Sorted based on User's Feedback



ORA-02216: tablespace name expected..

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

ORA-02216: tablespace name expected..

Answer / steve

Solution:
----------------------------------------------------------
define DEFAULT_TABLESPACE_TABLE = AAAAA;
define DEFAULT_TABLESPACE_INDEX = AAAAA;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

EXP-00047: Missing tablespace name(s)

1 Answers  


ORA-38458: invalid operation "string" for XPATH_FILTER_PARAMETERS

1 Answers  


RMAN-06082: datafilecopy tag string is ambiguous

1 Answers  


TNS-01408: Instance "string", status string, has string handler(s) for this service...

1 Answers  


ORA-38487: FUNCTION/PACKAGE/TYPE "string" not allowed in the expression

1 Answers  






ORA-13275: spatial index creation failure on unsupported type

1 Answers  


ORA-27080: too many files open

1 Answers  


ORA-09360: Windows 3.1 Two-Task driver unable to allocate context area

1 Answers  


ORA-15007: name is already used by an existing template

1 Answers  


ORA-32625: illegal dimension in cell reference predicate

1 Answers  


ORA-30464: no summaries exist

1 Answers  


ORA-33016: (XSAGDNGL07) In AGGMAP workspace object, workspace object is not a valid operator or variable name.

1 Answers  


Categories