I want to have an account that will never expire. I want to do this without creating a profile. Looks like the below command works in Oracle 9 but not in Oracle 8. Any recommendations for an ALTER USER command in Oracle 8 that will give me the option to set an expire date?
ALTER USER test VALID UNTIL 'Jan 31 2340'
ALTER USER test VALID UNTIL 'infinity';