User for Adding datafile User for Adding datafile DanAuber (IS/IT--Management) (OP) 19 Jun 00 05:40 which user should be used for adding a datafile - System ?? or the owner ? Dan AuberDanAuber@aol.comDan Auber's Home Page RE: User for Adding datafile ackelly (MIS) 19 Jun 00 07:45 All datafiles are ultimately owned by SYS who "owns" the database and the data dictionary. For this reason datafiles and tablespaces (which are composed of datafiles) never show "ownership" anywhere in the data dictionary. Either SYS or SYSTEM is appropriate for adding datafiles. I generally add tablespaces and datafiles as SYS.