REP-0004: Warning: Unable to open user preference file.

Enter Password:
REP-0004: Warning: Unable to open user preference file.

=======================================================================
Cause:

Your local (customized) Oracle Reports preference file could not be opened.
This is just a warning, so the product will continue to run even if this occurs.
The possible causes of this error include the following:

Action:

You can take the following actions to rectify this error:

Case 1: Make sure the file prefs.ora is located in your "home" directory.

Case 2: Make sure that you have the privileges necessary to access the file. If you don't, change your privileges accordingly.

Case 3: Consult your operating system documentation or contact your system administrator.

Solution :-


Check whether u have prefs.ora file in your application user's home

[applmgr@sujeet scripts]$ locate prefs.ora
/u01/apps/tech_st/10.1.2/inventory/Templates/tools/admin/prefs.ora
/u01/apps/tech_st/10.1.2/tools/admin/prefs.ora

How to add a datafile to a bigfile tablespace in Oracle 23ai Database.

  Syntax for Bigfile Tablespace: SQL > ALTER TABLESPACE tablespace_name ADD DATAFILE SIZE 10G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED; Ho...