Oracle SQL Developer [message #477553] |
Fri, 01 October 2010 13:24 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
newbie3
Messages: 23 Registered: September 2010
|
Junior Member |
|
|
Hello Guys,
I am working on the data modeling for an obiee project. I have all the tables in my BI Database(using oracle sql developer). My main schema is there in this database. I logged in with my username and password and I have read/write access to my area and read access to the main schema. I was asked to copy all the tables from the main schema and create it in my area and then load data from those tables(main schema) to tables in my area. When I try to create the table it says that I do not have enough privileges. I do not know whether am doing the right thing. I am supposed to work in my area where I have all the access but am not able to find how I do it in my area.
Can you guys please help me figuring this out.
Thank You.
|
|
|
|
Re: Oracle SQL Developer [message #477555 is a reply to message #477553] |
Fri, 01 October 2010 13:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I'm not familiar with OBIEE terminology, so I don't know what "my area" is. I think that this might be a "schema" (i.e. nothing special), but I'm not sure.
Anyway: if I was right, in order to create a table in your schema, you need CREATE TABLE privilege. This, as well as any other privileges, you can get from a privileged user (such as SYS, for example).
On the other hand, doing that (creating tables and loading data) the way you described is, well, not the best way. I'd rather try with export and import utilities. They are used at operating system command prompt. If this is an option, here's the documentation.
In a few words: you'd first export "main schema" and then import it into your own schema:
exp main_schema_user/pwd file=main_schema.dmp
imp your_schema/pwd file=main_schema.dmp
There are MANY other options which you can learn by reading the documentation.
If I'm wrong, could you explain it once again, please?
|
|
|
|
Re: Oracle SQL Developer [message #477560 is a reply to message #477555] |
Fri, 01 October 2010 14:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
newbie3
Messages: 23 Registered: September 2010
|
Junior Member |
|
|
Thanks for responding so fast guys. I am very new to this so am not able to ask the questions in the right way. I apologise for that.
The information you provided helped. Thank You once again.
|
|
|
|
|