Database Administration (MOSC)

MOSC Banner

ORA-03237: Initial Extent of specified size cannot be allocated in tablespace (JAD

edited Jun 15, 2018 2:46PM in Database Administration (MOSC) 4 commentsAnswered
  When we try to move AI_AP_RGM_PAYMENTS to another table space or try to import this table to new create table space we got error

my step

exp userid=system/system TABLESPACES=JAD  file=/prodct/jad.dmp log=jad.log

ALTER USER ja  QUOTA UNLIMITED ON jax; ===> give only if not there

ALTER USER ja  QUOTA 0 on JAD;

alter tablespace JAD offline;

drop tablespace jad including CONTENTS and datafiles;

CREATE TABLESPACE JAD DATAFILE
  '/proddata1/proddata/jad01.dbf' SIZE 228m AUTOEXTEND ON NEXT 8K MAXSIZE UNLIMITED,
  '/proddata2/proddata/jad02.dbf' SIZE 228m AUTOEXTEND ON NEXT 8K MAXSIZE UNLIMITED,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center