How to import all the objects under an HR user into Oracle

First to create a AA user:

sys@orcl> create user AA identified by AA;

User created.

To view user rights with an HR user login:

Sys@orcl> Conn Hr/hr

Connected.

Hr@orcl> select * from Session_privs;

Privilege

----------------------------------------

CREATE session

ALTER session

Unlimited tablespace

CREATE TABLE

CREATE CLUSTER

CREATE synonym

CREATE VIEW

CREATE SEQUENCE

CREATE DATABASE LINK

CREATE PROCEDURE

CREATE TRIGGER

CREATE TYPE

CREATE OPERATOR

CREATE Indextype

Rows selected.

Hr@orcl>

Use the SYS user to assign these permissions to a AA User:

Sys@orcl> Grant CREATE session,alter session,unlimited tablespace,create table,create cluster,create View,create sequence,create DATABASE link,create procedure,create trigger,create type,create OPERATOR,CREATE INDEXTYPE to AA;

Grant succeeded.

Sys@orcl>

Create a table space for a AA user

sys@orcl> Create tablespace AA

2 datafile '/u01/app/oracle/oradata/orcl/aa01.dbf ' size 20m;

Tablespace created.

sys@orcl> alter user AA default tablespace AA quota unlimited on AA;

User altered.

Users are created and given permissions to start exporting data from an HR user:

[Oracle@oracle ~]$ exp hr/hr file=hr_aa_130906.dmp log=hr_aa_130906.log

Export:release 10.2.0.1.0-production on Sun Sep 8 15:13:57 2013

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

Connected to:oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options

Export done in Us7ascii character set and Al16utf16 NCHAR character set

Server uses Al32utf8 character set (possible charset conversion)

. Exporting Pre-schema procedural objects and actions

. Exporting foreign function library names for user HR

. Exporting public type synonyms

. Exporting private type synonyms

. Exporting object type definitions for user HR

About to export HR ' s objects ...

. Exporting database Links

. Exporting sequence Numbers

. Exporting cluster definitions

. About to export HR ' s tables via conventional Path ...

. . Exporting table COUNTRIES rows exported

Exp-00091:exporting questionable statistics.

. . Exporting Table Departments rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table EMPLOYEES rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table JOBS rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table Job_history rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table Locations rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table regions 4 rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. Exporting synonyms

. Exporting views

. Exporting stored Procedures

. Exporting operators

. Exporting referential integrity constraints

. Exporting triggers

. Exporting indextypes

. Exporting bitmap, functional and extensible indexes

. Exporting Posttables Actions

. Exporting materialized views

. Exporting snapshot logs

. Exporting job queues

. Exporting refresh groups and children

. Exporting dimensions

. Exporting Post-Schema procedural objects and actions

. Exporting statistics

Export terminated successfully with warnings.

[Oracle@oracle ~]$