All tables return with 0 records while unloading

Roads ? - where we're going, we don't need roads ...

All tables return with 0 records while unloading | ORA600

Blog Atom

Search

Submitted by kurtvm on Mon, 07/14/2008 - 05:53.

Toggle the ASSM parameter in the tablespace clause.

Most probably you defined your tablespace as ASSM=”true” but it was not created with “automatic segment space management”. (or vice versa)

Some tips : -

ASSM was introduced in 9i – so if you’re on 7,8.0 or 8i, always set ASSM=”false” (default)
SYSTEM never uses ASSM
It’s not necessary to drop and recreate the blockmap of a tablespace after you've toggled ASSM

Bookmark/Search this post with:

Howto's

See DUDE primer for info

Get Support

Europe

Belgium :
Kurt Van Meerbeeck
ORA600 bvba
E-mail
dude@ora600.be
Cell : +32 495 580714

Denmark :
Henrik Bjerknæs Rasmussen
Service & Support Manager
Miracle AS
E-mail :
hra@miracleas.dk
Cell: +45 53 747 110

North America

USA :
Tim Gorman
Evdbt Inc
E-mail
tim@evdbt.com
Cell : +1 303 885 4526

USA :
Daniel Fink
OptimalDBA
E-mail
daniel.fink@optimaldba.com
Cell : +1 303 808 32 82

Canada :
Pythian
E-mail
dude@pythian.com
Contact

Latin America

Brazil :
HBtec
E-mail
dude@hbtec.com.br
Cell : +55 47 88497639
Contact

Africa

South Africa :
Kugendran Naidoo
NRG Consulting
E-mail
k@nrgc.co.za
Cell : +27 82 7799275

East Asia Pacific

Australia
Alex Gorbachev
Pythian Australia
E-mail
dude@pythian.com
Cell : +61 2 9844 5431