to drop all the tablespaces and then recreate?
> > I also run this: > > SQL> show parameter cache; > > Name Type > Value > > db_16k_cache_size big integer > > 36M > db_cache_advice string > ON > object_cache_optimal_size integer > 102400 > > All of the rest has a value of “0”. > > I tried to change the “db_16k_cache_size” to 100M, however I got > “ORA_02097: parameter cannot be modified because specified value is > invalid ORA-00384 : Insufficient memory to grow cache” error. > > Please excuse me if I asked really rudimentary questions. I am kind of > new to the Oracle stacks as I said. > > Thanks again!! > > Zara > > Alan Cuartero wrote: > >> Zara, >> >> You may have run out of space. Its been my experience that the default >> tablespace data files are a little undersized for the import. Check >> > your log > >> for the first occurrence of an ORA-01658 error all the subsequent >> > errors > >> would be a result of that initial one. If you have it try adding a >> > datafile > >> to the tablespace in question. Another possible solut
