Re: Very New to ORACLE

I meant physical warehouses...

Anyway, i was thinking, abotu the design for a couple of days now.... Basically my company wants to have data separated for each fiscal year. In other words, a table for year 1998, another for 1999 etc.... So my first thought was to create tables named COMPANY_1998_TABLE1, COMPANY_1998_TABLE2, etc... and then according to the year the user chooses at logon, i assign aliases to these tables for example COMPANY_98_TABLE1 becomes TABLE1, and in my application i do my SQL based on the aliases....is this feaseable? is it a good approach? should i convince my company that there is not need ot separate the data?! I am no financial wizard, and when they tell me that the data should be separated in order to be able to close the fiscal year, i have no arguments against that...

Tarek

Pete Kolton wrote:

> Do you mean you want to design a data warehouse, or your company owns
> physical warehouses which you want to build a database system for? It makes
> a BIG difference.
>
> Also, as you will soon discover, a DBA course is not the one you wanted to
> do to learn how to design an application.
>
> --
> ========================================================
> Pete Kolton
> ORACLE Systems Consultant
> All reasonable offers considered :-)
>
> Pete_at_kolton.com
> http://www.kolton.com
> ========================================================
>
> Kifah Jaroudy wrote in message <38367B29.FF1CEA5D_at_cyberia.net.lb>...
> >Hi,
> >I am not sure if this is the right place to post this, so you can feel
> >free to direct me to the proper newsgroup.
> >I don;t have much experience in ORACLE. I took the ORACLE DBA course,
> >but never had the chance to put to test what i learned.
> >Now, i was asked to design a database for our warehouses... my previous
> >experience on the matter is ACCESS :)
> >To top things, the project manager, has no experience what so ever in
> >oracle. anyway to make a long story short. I was wondering if someone
> >would have the time and patience to guide me through basically designing
> >an ORACLE database!
> >
> >Tarek
> >
> >
Received on Mon Nov 22 1999 - 09:02:18 CST