Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Schema and tablespace
This is a discussion on Schema and tablespace within the Database Design forums, part of the Databases category; Hi, i have created a schema name "abcd" & have created a tablespace "efgh" using sysdba user. Sql> alter user abcd default tablespace efgh; "user altered" i have given dba ...
|
|||||||
| Database Design Disucss if you have any issues with Database Design and Concepts |
 |
| LinkBack | Thread Tools | Display Modes |
11-20-2008
|
|||
|
|||
Schema and tablespace
Hi, i have created a schema name "abcd" & have created a tablespace "efgh" using sysdba user.
Sql> alter user abcd default tablespace efgh; "user altered" i have given dba and sysdba grants to the schema "abcd". If i try to access table(password) under "efgh" tablespace using "abcd" schema i am getting the follwing error. Sql> select * from password; select * from password * error at line 1: ora-00942: table or view does not exist. Last edited by kamesh_1902; 11-20-2008 at 09:50 PM. 
|
| Sponsored Links |
|
11-21-2008
|
|||
|
|||
|
Re: Schema and tablespace
Do you have table named password created??
|
|
11-21-2008
|
|||
|
|||
|
Re: Schema and tablespace
yes.The table name is password.
|
|
11-24-2008
|
|||
|
|||
|
Re: Schema and tablespace
CAN YOU TELL ME the user from where you are running your query?
Print the output of the below query here: 1. SELECT USER from DUAL 2. SELECT * FROM all_objects where object_name like 'PASSWORD'
|
|
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| dictionary managed tablespace | kenith_shah01 | Database Design | 1 | 08-30-2009 12:57 AM |
| Locally managed tablespace | jkrish.sharma | DB2 | 0 | 07-27-2008 08:01 AM |
| How to extend tablespace in SAP R/3 using brtools | debiprasad2008 | SAP R/3 | 0 | 06-27-2008 05:02 AM |
| Can exp just export a tablespace | orion42 | Oracle | 1 | 09-26-2007 01:55 PM |
| Examples for Star Schema & Snow flake schema | Geek_Guest | Data Warehousing | 2 | 09-23-2007 02:39 PM |
All times are GMT -4. The time now is 09:47 AM.
