DZone Forums - Oracle http://forums.dzone.com en Sun, 22 Nov 2009 17:46:01 GMT vBulletin 60 http://forums.dzone.com/images/bluesaint/misc/rss.jpg DZone Forums - Oracle http://forums.dzone.com JD Edwards Data Archiving Solution http://forums.dzone.com/showthread.php?t=1939&goto=newpost Mon, 16 Nov 2009 08:20:29 GMT Organizations can mitigate the impact of data growth by running batch reports during downtimes, purchasing faster hardware or purge data from the... Organizations can mitigate the impact of data growth by running batch reports during downtimes, purchasing faster hardware or purge data from the application.

None of these strategies fully address the reality of application growth coupled with the need for long term data retention. To maintain performance of JD Edwards database, while ensuring compliance, organizations must Analyze JD Edwards data for a given module or the sum total of the Application database. ]]> Oracle debrah.h48 http://forums.dzone.com/showthread.php?t=1939 how to create a tablespace that consist a fix number of extents? http://forums.dzone.com/showthread.php?t=1935&goto=newpost Sun, 15 Nov 2009 16:53:34 GMT i wanted to create a locally managed tablespace with uniform allocation of extents. And also want my tablespace to consist only let say 5 extents. It... i wanted to create a locally managed tablespace with uniform allocation of extents. And also want my tablespace to consist only let say 5 extents. It will use only one data file.

here is what i know:

Code:

CREATE TABLESPACE TABLE1
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 64K
DATAFILE 'C:\ORACLE\ORADATA\MYDB\TABLE1.DBF'
SIZE 5M
AUTOEXTEND AUTO;
I tried maxextents but error. I seriously have no idea whether is it possible to have a fix number of extents? ]]> Oracle flaskvacuum http://forums.dzone.com/showthread.php?t=1935