Load data from flat file into oracle table
According to your question you have data in the flat file and you want to access it or can load to another table. Basically you are talking about external tables. You want to read more on it. Here is the Oracle Documentation link: External Tables Concepts.

Here is the example how I loaded your data into my external table and created another table from it.

[oracle@testsrv1 Desktop]$ cat user.tbl 
 1|john|email@email.com|active
[oracle@testsrv1 Desktop]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 3 06:45:26 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL&gt; create user user1 identified by user1;

User created.

SQL&gt; create directory user_dir as '/home/oracle/Desktop';

Directory created.


SQL&gt; grant resource, connect to user1;

Grant succeeded.

SQL&gt; grant read, write on directory user_dir to user1;

Grant succeeded.

SQL&gt; conn user1/user1
Connected.

SQL&gt; create table user_load(user_id number, name varchar2(20), email varchar2(50), status varchar2(10))
organization external
(default directory user_dir
access parameters
(fields terminated by '|')
location('user.tbl')
);   

Table created.

SQL&gt; select * from user_load;

   USER_ID NAME          EMAIL                  STATUS
---------- ----------   -------------------    ----------
     1 john         email@email.com        active


SQL&gt; create table final as select * from user_load;

Table created

SQL&gt; select * from final;

   USER_ID NAME          EMAIL                  STATUS
---------- ----------   -------------------    ----------
     1 john         email@email.com        active