How to create the OEM repository

Create a tablespace USERS locally managed with autoincrease to hold permanent database objects.
expdat.dmp.gz use this valid export file for import

CREATE USER "REPOSITORY"  PROFILE "DEFAULT" 
    IDENTIFIED BY "repository" DEFAULT TABLESPACE "USERS" 
    QUOTA UNLIMITED 
    ON "USERS" 
    ACCOUNT UNLOCK;
GRANT CREATE TABLE TO "REPOSITORY";
GRANT CREATE PROCEDURE TO "REPOSITORY";
GRANT CREATE TRIGGER TO "REPOSITORY";
GRANT CREATE TYPE TO "REPOSITORY";
GRANT EXECUTE ANY PROCEDURE TO "REPOSITORY";
GRANT EXECUTE ANY TYPE TO "REPOSITORY";
GRANT SELECT ANY DICTIONARY TO "REPOSITORY";
GRANT SELECT ANY TABLE TO "REPOSITORY";
GRANT "CONNECT" TO "REPOSITORY";
GRANT "SELECT_CATALOG_ROLE" TO "REPOSITORY";
GRANT CREATE SEQUENCE TO "REPOSITORY";
GRANT CREATE VIEW TO "REPOSITORY";

Launch Enterprise Manager and launch an application requiring the repository, for example SQL Analize, it will create the repository automatically

Clean up repository tables

Log in as repository user:
SELECT 'drop table ' || table_name || ';'
  FROM user_tables
 WHERE table_name LIKE '%TMP%'