Issues when importing databases

Applies to: On premises

When you import the IBM OpenPages® database during an upgrade or migration, you might see an error as a result of the default data file size.

If an error occurs, increase the default data file size as follows.

  1. On a computer that has SQL*Plus, log on as a user, such as SYSTEM, who has database administration permissions.
  2. Run the following SQL statements: 
    ALTER TABLESPACE INDX ADD DATAFILE
	'C:\app\Administrator\oradata\OP\INDX02.DBF'
	SIZE 128 M AUTOEXTEND ON NEXT 128 M MAXSIZE 34359721984;

	Alter database datafile 'C:\app\Administrator\oradata\OP\AURORA.DBF'
  resize 2000m;