There are two ways to extend the system table space.1. Set the current datafile to AUTOEXTEND2. Add a new datafile1. Set the Current datafile to AUTOEXTENDSELECT 'ALTER database datafile ''' || file_name || ''' ' || ' AUTOEXTEND ON maxsize 2097152000;'FROM dba_data_filesWHERE tablespace_name = 'SYSTEM';ALTER database datafile '/u01/app/oracle/oradata/XE/system.dbf' AUTOEXTEND ON maxsize 2097152000;database datafile '/U01/APP/ORACLE/ORADATA/XE/SYSTEM.DBF' altered.2. Add a New datafilealter tablespace SYSTEM add datafile '/u01/app/oracle/oradata/XE/system2.dbf'...
-
Getting the java.sql.Connection object using Session: --------------------------------------------------------------------------- org.hibern...
-
In this post, we are going to learn how to integrate Spring4 MVC with Hibernate4 application with Maven build tool and will perform CRUD o... -
Example 1: given the below input the output will be 2+13+8+22=45 Given Input [2GSD#13x8xU343%^DGF1@22@] Expected output 45 Example 2: given ...
-
Exception in thread "main" java.lang.UnsupportedOperationException: The application must supply JDBC connections. Problem: whi... -
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.IllegalStateException: No data...
-
The major differences between Spring framework and Struts framework are : Spring Struts Spring is an application framework in which Spring ...
-
Creating a Custom Dialect in Hibernate: In order to create any new Dialect class we need to extends org.hibernate.dialect . Dialect class....
-
This post demonstrates the how to get the all table names using Hibernate. Configuration configuration = new Configuration () ; configura...
-
Setting the Classpath in Intellij IDEA: Way1 : Open Project Structure (either Ctrl+Alt+Shift+S or File > Project Structure) Select ...
-
In hibernate , there are two ways to get the org.hibernate. Session object. Using openSession() method Using getCurrentSession() method 1...