OraFAQ Forum: Unix » new dba has some question , need help

Home » Infrastructure » Unix » new dba has some question , need help (ORACLE, 9i,10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

new dba has some question , need help [message #579387]

Tue, 12 March 2013 01:23

sureshs
Messages: 2
Registered: March 2013
Location: India

Junior Member

NEW TO DBA WORLD SO HAVE SOME QUESTION AND DOUBT HELP ME FRIENDS TO EXCEL
1. how to create a user exactly similar to that of another user?
2.how to refresh a schema from one db to another database using both R-MAN and expdp/impdp
3.IF db is up and running someone deleted your controlfile , what will happen to your database
i) one of the controlfile is deleted?
ii) whole controlfile is deleted?
4.if online redo logs are accidently got deleted, how to manage it?
5. how to drop default temporary tablespace ?

friends atleast members checkout my questions ans one of those

Report message to a moderator

Re: new dba has some question , need help [message #579400 is a reply to message #579387]

Tue, 12 March 2013 02:16

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1. There is no direct way to do it but many tools provide it; I advice you to NOT do this, a user should be created with a list of its parameters, not like another user that may have been modified and contain some things you actually don't want to give to the new one.
2. Use Data Pump, RMAN is not made for this
3. You can download for free Oracle XE and try it yourself.
4. This is explained in details in Database Backup and Recovery Advanced User's Guide
5. We do not do homework for you, study your course materials and come back with your own answers, we will then tell you if you are correct or not and help you to go further.

Regards
Michel

Report message to a moderator

Re: new dba has some question , need help [message #579414 is a reply to message #579400]

Tue, 12 March 2013 02:47

sureshs
Messages: 2
Registered: March 2013
Location: India

Junior Member

Thanks MICHEl
1. to create a new user same as old user what are the parameters v need to check other than Default_tablespace, temp_tablespace, profile , privileges and quotas

Report message to a moderator

Re: new dba has some question , need help [message #579420 is a reply to message #579414]

Tue, 12 March 2013 02:56

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Resource manager parameters.

Regards
Michel

Report message to a moderator

Re: new dba has some question , need help [message #583551 is a reply to message #579414]

Wed, 01 May 2013 14:46

niranjan.a.88@gmail.com
Messages: 2
Registered: May 2013

Junior Member

to create a copy of a user use package
dbms_metadata.get_ddl
dbma_metadata.get_granted_ddl

get the encoded password of user from dba_users & :- (select username,password from dba_users)
create user usr_name identified by values 'encoded password';

Get DDL of user to be created:
select dbms_metadata.get_ddl('USER','<USERNAME>') from dual;

Get all their roles and grants as well:-

SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT','<USERNAME>') FROM DUAL;
SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','<USERNAME>') FROM DUAL;
SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','<USERNAME>') FROM DUAL;

hope this helps u!! Smile

regards, niranjan

[Updated on: Thu, 02 May 2013 00:35] by Moderator

Report message to a moderator

Re: new dba has some question , need help [message #583584 is a reply to message #583551]

Thu, 02 May 2013 00:36

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You still do not get resource manager parameters with that.

Regards
Michel

Report message to a moderator

Re: new dba has some question , need help [message #583597 is a reply to message #583584]

Thu, 02 May 2013 02:44

niranjan.a.88@gmail.com
Messages: 2
Registered: May 2013

Junior Member

Hi Michel

are u telling about "resource_manager_plan" parameter.... i have no knowledge about this. Confused

regards, niranjan

Report message to a moderator

Re: new dba has some question , need help [message #583599 is a reply to message #583597]

Thu, 02 May 2013 03:14

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I'm talking about initial resource consumer group for instance (see DBA_USERS).

Regards
Michel

[Updated on: Thu, 02 May 2013 03:14]

Report message to a moderator

Previous Topic:	Significant virtual memory paging was detected on the host operating system.
Next Topic:	Snap Management Utility, DB Cloning,

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 17:11:24 CST 2024