Topics | Search Log Out | Register | Edit Profile
Hide Clipart | Banned/Unbanned User Log | Moderator Login History | Thread Delete/Move Log | Last 30 mins | 1 | 2
Oracle PDB question very urgentttt

Chalanachithram.com DB » New TF Industry Related » Archive through July 19, 2015 » Oracle PDB question very urgentttt « Previous Next »
Author Message
 

Driverramudu
Hero
Username: Driverramudu

Post Number: 13615
Registered: 02-2009
Posted From: 166.137.246.96

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, July 18, 2015 - 09:12 pm:       

Sri Angi

PDB ==> Pluggable Database

New feature in Oracle 12c

As I am trying to create new PDB but with sys user credentials
All the objects granted to system automatically coming to this new
PDB as well

So this time I created new user first at CDB lever
And I tried to create new PDB but it's not allowing me
On top of it it's says my user is not admin etc
But I gave necessary privileges to new user while I am creating

Roles Connect , DBA, CDB_DBA and PDB_DBA etc

System privileges create and alter session

But when I try to give sysdba but it's not allowing me to create user
So I did not give that
Driving is my PASSION.
Ball or Bimmer does not matter.
 

Sri_anji
Hero
Username: Sri_anji

Post Number: 12486
Registered: 02-2008
Posted From: 107.77.70.60

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, July 18, 2015 - 08:57 pm:       


Driverramudu:




Just a regular schema? PDB ante?
The best Odarpu
 

Driverramudu
Hero
Username: Driverramudu

Post Number: 13614
Registered: 02-2009
Posted From: 166.137.246.96

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, July 18, 2015 - 08:18 pm:       

Bump for oracle DBAs or Xperts

I tried my best in googling it
But never seen right article to match my requirement
Driving is my PASSION.
Ball or Bimmer does not matter.
 

Driverramudu
Hero
Username: Driverramudu

Post Number: 13613
Registered: 02-2009
Posted From: 166.137.246.96

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, July 18, 2015 - 08:12 pm:       

I am able to create new PDB using SQLDeveloper

But I see many database objects in it

As I am using sys user name and password
Is that is the reason ?

My intention is to create blank or empty PDB
So that I would want create module specific objects in to respective PDB

Can any one help me out
Appreciate in advance
Driving is my PASSION.
Ball or Bimmer does not matter.

Add Your Message Here
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image HASH(0x9e9b27c){Movie Clipart}
Show / hide regular icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Show / Hide Filmy icons selection options

Click on following links to open cliparts by Alphabetical Order

  A   B   C   D   E   F   G   H   I   J   K   L   M  

N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Username: Posting Information:
This is a public posting area. Enter your username and password if you have an account. Otherwise, enter your full name as your username and leave the password blank. Your e-mail address is optional.
Password:
E-mail:
Options: Enable HTML code in message
Automatically activate URLs in message
Action: