Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-03221: Temporary tablespaces and temporary segments must
have standard block size



ORA-03221: Temporary tablespaces and temporary segments must have standard block size..

Answer / guest

Cause: An attempt was made to do one of the following : (1)
create a temporary tablespace with a non-standard block size
or, (2) alter an existing permanent tablespace of
non-standard block size to a temporary tablespace or, (3)
issue a DDL statement that would result in the creation of a
temporary segment in a tablespace of non-standard block size.

Action: (1) If creating a temporary tablespace, do not
specify a block size different from the standard block size.
(2) If altering an existing permanent tablespace to a
temporary tablespace, ensure that it is of standard block
size. (3) Ensure that the user's temporary tablespace is a
tablespace having the standard block size.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31069: Cannot apply typed changes to non-schema-based XMLType nodes

1 Answers  


ORA-19019: Invalid context passed to DBMS_XMLGEN.GETXML

1 Answers  


ORA-31491: could not add logfile to LogMiner session

1 Answers  


IMG-00523: invalid process verb

1 Answers  


ORA-01630: max # extents (string) reached in temp segment in tablespace string

1 Answers  


IMP-00074: The constraints flagged by ALL_CONSTRAINTS.BAD will break in 2000 A.D.

1 Answers  


ORA-31113: XDB configuration may not be updated with non-schema compliant data

1 Answers  


ORA-09945: Unable to initialize the audit trail file

1 Answers  


QSM-00770: the specified workload string is already referenced by task string

1 Answers  


DRG-51200: open keymap failed for index id = string

1 Answers  


ORA-28238: no seed provided

1 Answers  


ORA-30034: Undo tablespace cannot be specified as temporary tablespace

1 Answers  


Categories