Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 390 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
Space Issue in oracle installed on linux

Hello
my oracle database server installed on Linux Redhat machine and app server installed on win server 2008
when it starts scheduler to prune data
I got following errors
"Error executing the procedure PrePruningProcess."
"Oracle error: Error In Making Prog Table"
"Please allocate more space or prune back the data."
my question is how to determine how much space does particular oracle instance get while starting the database.
Is there any way to increase this space.
Answers
-
So you are deleting data (ie pruning), but you need more storage space.
Doesn't make alot of sense - unless the program is copying data to a new then truncatng from the original table.
You should check if the storage is really full, or if the tablespaces can not extend anymore.
-
Hi,
there is No ORA-XXX error messages in your logs ?
did you check your current tablespace size for the schema of your application ?
Regards,