Which schema oracle

Figure shows these links. Click the links in the Database Objects heading to see the objects in your database. You can also access any schema object from the Search section of any database object home page. As shown in Figure , you can search for objects by entering values in the Schema and Object Name boxes. You can also access other schema objects, including those with no direct link under the Database Objects heading.

To select a specific database object, select an option from the Object Type list. Every object in the database belongs to one schema and has a unique name within that schema. When you create an object, you must ensure it is in the schema where you intend to store it.

Generally, you place all of the objects that belong to a single application in the same schema. To create a schema in Oracle, you need to do the following steps:. Step 1 - Create a new user in Oracle In essence, a schema is created in Oracle when a user is created. Step 3 - Create objects in the schema Now that the schema called smithj has been created with the necessary privileges, you can create objects in the schema.

This can be done one of 2 ways: Executing individual SQL statements to create each object. Step 5 - Create Synonyms for Objects As a last step, you may want to create synonyms so that other schemas can access the new database objects ie: tables without having to prefix the object names with the schema name. Share on:. Improve this question. Community Bot 1 1 1 silver badge. Vipin Vipin 4, 3 3 gold badges 32 32 silver badges 55 55 bronze badges.

I don't think I understand what you mean with "schema useer". Show 8 more comments. Active Oldest Votes. Improve this answer. Danilo Piazzalunga Danilo Piazzalunga 7, 5 5 gold badges 46 46 silver badges 67 67 bronze badges. It gives same result as "select user from dual" , which is my read only user. Vipin user will give the person logged in but not the actual schema name. If you read the question, that will tell you logging with RO user but get the schema name.

Add a comment. Chewbacca17 63 5 5 bronze badges. Codo Codo How about the following 3 statements? Sign up or log in Sign up using Google. Sign up using Facebook.

Sign up using Email and Password.