Re: Copy tables from oracle 7 to oracle 9

From: <mdurliSPAMFILTER_at_hotmail.com>
Date: Thu, 12 Sep 2002 12:57:32 GMT
Message-ID: <fj31ou8kpv4iah24mq1pl5qit79rrb4i2s@4ax.com>

>
>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! Received on Thu Sep 12 2002 - 07:57:32 CDT