Generating CREATE scripts for Oracle

Hello all,
My supervisor asked me to generate create scripts of one of our clients DB
objects. Apparently they use Oracle, so I need the scripts that SQL Server
2005 creates to be compatible with the SQL that Oracle uses. I know
absolutely nothing about Oracle-have no experience with it.
I went through the Generate SQL Server Scripts Wizard to create the scripts.
Scripts were created for 3 user-defined functions, 13 tables, and 20 views.
One thing that jumps to mind is SQL Server defaults to square brackets ([])
around object names. Will Oracle recognize square brackets? I think I read
somewhere once that some DB systems don't like square brackets, and quotes
("") should be used instead of square brackets. Is this something I need to
be concerned with?
Is there anything else that anyone can think of that I need to be concerned
with?
Thanks for any help anyone can provide,
Conan KellyOn Sep 14, 12:43 pm, "Conan Kelly"
<CTBarbarinNOS...@.msnNOSPAM.comNOSPAM> wrote:
> Hello all,
> My supervisor asked me to generate create scripts of one of our clients DB
> objects. Apparently they use Oracle, so I need the scripts that SQL Server
> 2005 creates to be compatible with the SQL that Oracle uses. I know
> absolutely nothing about Oracle-have no experience with it.
> I went through the Generate SQL Server Scripts Wizard to create the scripts.
> Scripts were created for 3 user-defined functions, 13 tables, and 20 views.
> One thing that jumps to mind is SQL Server defaults to square brackets ([])
> around object names. Will Oracle recognize square brackets? I think I read
> somewhere once that some DB systems don't like square brackets, and quotes
> ("") should be used instead of square brackets. Is this something I need to
> be concerned with?
> Is there anything else that anyone can think of that I need to be concerned
> with?
> Thanks for any help anyone can provide,
> Conan Kelly
I'd rather use Oracle Migration Workbench