Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02216: tablespace name expected
- 2 Answers
- 13713 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 |
LFI-00140: Invalid option string were specified on input-output file.
ORA-30012: undo tablespace 'string' does not exist or of wrong type
ORA-31492: could not set session parameters for LogMiner session
NID-00335: The following datafiles are not consistent:
SQL*Loader-00126: Invalid read size
ORA-29291: file remove operation failed
ORA-36160: (XSMXAGGR04) You may not use AGGREGATE on scalar VARIABLE workspace object.
LFI-00139: Option string cannot be used with option string in calling string.
TNS-04209: Trace Assistant Internal ERROR: Type Error
ORA-02829: No segment of the proper size is available
ORA-01286: start interval required
DRG-12408: invalid variable reference: string.string
Oracle Errors 
