Re: Copy tables from oracle 7 to oracle 9

A Schema is created when any new user is created ( maybe only if granted resource , not at my desk at the moment) so read up on creating new users..  

mdurliSPAMFILTER_at_hotmail.com wrote:

>
>>
>>What SQLServer refers to as a 'database' is generally referred to as a
>>'schema' in Oracle. What SQLServer refers to as an 'instance' is
>>generally referred to as a 'database' in Oracle.
>>
>
>Thank you now everything is more clear.
>
>>So, if you found the scott schema, you've found the database
>>(SQLServer sense) you're looking for.
>>
>Now I've created the two tables I need in the Scott schema to do my
>tests.
>
>But how can I create a new schema? Is not in Create menu, I found
>create tables and I can choose the schema and the tablespace.
>So I used the scott schema and system tablespace.
>But if I want to create a new schema, with my table?
>
>Thanks!

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Thu Sep 12 2002 - 09:33:07 CDT