Database Administration (MOSC)

MOSC Banner

alter system_1.dbf as data file

in Database Administration (MOSC) 5 commentsAnswered ✓

Hello,

We have modified system_1.dbf using

alter database datafile ‘C:\ORACLE\ORADATA\ADVA\SYSTEM_1.DBF’ resize 768M;

Is this correct way to increase size of SYSTEM_1.dbf, about 768M;


If not which is the correct way, kindly provide a sample command.

Also can we create another System_2.dbf file and set it as default, would that work?


Also provide any suggested practice for handling SYSTEM_x.DBF files.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center