Database Administration (MOSC)

MOSC Banner

ORA-01119 Partitioned Table

edited Nov 18, 2013 8:46AM in Database Administration (MOSC) 4 commentsAnswered
On our 10.2.0.4 instance, we have a nightly task that exports a table partition to a tablespace hosted on the windows file system.

However, for the past 3-4 nights the creation of one of these tablespaces has been failing with the message (it is the same tablespace each time).

ORA-1119 signalled during:
create smallfile tablespace xxxx datafile 'D:\xxxx\xxxxx' size 3000000m reuse
extent management local segment space management auto

It seems very unlikely that this is a permissions or a capacity issue as subsequent table partitions have exported successfully to a new tablespace with what seems to be the same SQL code.

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