Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Can't add user to my oracle support

emersoklFeb 19 2010 — edited Feb 19 2010
I thought creating a service request stinked but tryiing to add a new user to our oracle account isn't working for me. I can verify under settings that I am the admin of our account and I can view the other users of the account but can't for the life of me find where to add a new user.

Has any oracle admin tried to add a new oracle dba user to their oracle account? if so, what apge do you add them on?

Thanks,
kathie

Comments

621707
Actually that was my mistake....
I specified the wrong clause.

oracle@NOBASE-oracle:~> imp system/manager@ora01 file=/home/oracle/FULL_EXP_BACKUP/imp_pipe log=/home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136.log FROMUSER=NOBASE,GBADM00301,NOBASEXML,DUMMYCONNECT,SPOTLIGHT2,SPOTLIGHT,SPOT1,TIMEREG,TDCH,ERWIN,IX,MTSSYS TOUSER=NOBASE,GBADM00301,NOBASEXML,DUMMYCONNECT,SPOTLIGHT2,SPOTLIGHT,SPOT1,TIMEREG,TDCH,ERWIN,IX,MTSSYS

Import: Release 10.2.0.1.0 - Production on Wed Mar 4 22:22:10 2009

Copyright (c) 1982, 2005, 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

Cannot proceed from last 25 minutes

My /home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136.dmp.gz file is of 17G
Why is it so?

Please help

Edited by: user618704 on Mar 4, 2009 10:39 PM

Edited by: user618704 on Mar 4, 2009 10:41 PM
Anand...
HI..

The file to be imported i suppose is FILE=/home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136.dmp.gz and when it will be unzipped the file name will be */home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136.dmp* until unless not altered.

SO,where does file=/home/oracle/FULL_EXP_BACKUP/imp_pipe comes from. Which file is imp_pipe.I think your imp command must be

oracle@globase-oracle:~> imp system/manager@ora01 file=/home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136.dmp log=/home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136_imp.log FROMUSER=GLOBASE,GBADM00301,GLOBASEXML,DUMMYCONNECT,SPOTLIGHT2,SPOTLIGHT,SPOT1,TIMEREG,TDCH,ERWIN,IX,MTSSYS TOUSER=GLOBASE,GBADM00301,GLOBASEXML,DUMMYCONNECT,SPOTLIGHT2,SPOTLIGHT,SPOT1,TIMEREG,TDCH,ERWIN feedback=100000 buffer=30000000 ignore=y


HTH
Anand
621707
I used below script on new terminal and it works :)

mknod /home/oracle/FULL_EXP_BACKUP/imp_pipe p
gunzip < /home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136.dmp.gz > /home/oracle/FULL_EXP_BACKUP/imp_pipe &
imp system/manager@ora01 file=/home/oracle/FULL_EXP_BACKUP/imp_pipe log=/home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136.log FROMUSER=NOBASE,GBADM00301,NOBASEXML,DUMMYCONNECT,SPOTLIGHT2,SPOTLIGHT,SPOT1,TIMEREG,TDCH,ERWIN,IX,MTSSYS TOUSER=NOBASE,GBADM00301,NOBASEXML,DUMMYCONNECT,SPOTLIGHT2,SPOTLIGHT,SPOT1,TIMEREG,TDCH,ERWIN,IX,MTSSYS


Thanks
Maran Viswarayar
Anand

This is compression on the fly in unix, You have to create a pipe and it will be redirected to write in a compressed format .Z or GZ where by the resultant dump will be in the compressed format at the end of export.

Similialy you have import using the same
Maran Viswarayar
Metalink 274109.1 has something for you

try deleting and recreate the pipe
Anand...
Hey Maran,

Thanks a lot for the info... :) I haven't worked much on unix platform.But it was nice to know this.Just wanted to clarify that is it redirected automatically to write in a compressed format.

Thanks
Anand
Maran Viswarayar
mknod /home/oracle/FULL_EXP_BACKUP/imp_pipe p
This creates the pipe
gunzip < /home/oracle/FULL_EXP_BACKUP/FullDbexp_20090302_0136.dmp.gz > /home/oracle/FULL_EXP_BACKUP/imp_pipe &
This (>) redirects the output to FullDbexp_20090302_0136.dmp.gz file with gunzip

Best Regards
Maran
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 19 2010
Added on Feb 19 2010
#general-database-discussions
2 comments
3,419 views