I'm Top Oracle DBA

For many Types of Database files, sometimes I feel more confused, but you have to be aware of block size, decomposite, and increment like my command. ***note*** before you’ll use my command. Please read to understand. —– Those commands are separated into 4 types —– 1st —> for tablespace autoextend is NO and tablespace size […]

User Oracle Database doesn’t drop users whose schemas contain objects unless you specify CASCADE. CASCADE Specify CASCADE to drop all objects on the user’s(schemas) before dropping the user. You must specify this clause to drop a user whose schema contains any objects. If the user’s schema contains tables, then Oracle Database drops the tables and […]