Urgent help needed!
in [Oracle Help]
|
From: rwking on 13 Sep 2006 22:20 Hi everyone, I have a project due in about an hour... one of the questions I have to answer is determining the physical size of the database. It's an Oracle 10 database. Actually, it's a small datawarehouse with 5 tables of raw data. I only have a SQL Plus interface, so some commands don't work. I can't find a query to get me the physical size anywhere on the net. If you have any ideas or input, PLEASE send me an email or respond to this post. I would greatly appreciate it. I hope someone is out there. Regards, Rich
From: IANAL_VISTA on 13 Sep 2006 22:31 rwking(a)gmail.com wrote in news:1158200438.844620.237050(a)m73g2000cwd.googlegroups.com: > Hi everyone, > > I have a project due in about an hour... one of the questions I have to > answer is determining the physical size of the database. It's an > Oracle 10 database. Actually, it's a small datawarehouse with 5 tables > of raw data. I only have a SQL Plus interface, so some commands don't > work. I can't find a query to get me the physical size anywhere on the > net. If you have any ideas or input, PLEASE send me an email or > respond to this post. I would greatly appreciate it. I hope someone > is out there. > > Regards, > > Rich > > With advice, you can have it good, fast or free. Pick any two, plz. >I only have a SQL Plus interface, so some commands don't work. Which commands do not work in SQL*Plus? The lack of planning on your part does not necessarily constitute an emergency on my part, SQL> DESC DBA_DATA_FILES SQL> DESC DBA_TEMP_FILES
From: rwking on 13 Sep 2006 22:33 I understand, and I appreciate your input. However, your query didn't work. Here's the response I got... ERROR: ORA-04043: object "SYS"."DBA_DATA_FILES" does not exist Any ideas? IANAL_VISTA wrote: > rwking(a)gmail.com wrote in > news:1158200438.844620.237050(a)m73g2000cwd.googlegroups.com: > > > Hi everyone, > > > > I have a project due in about an hour... one of the questions I have to > > answer is determining the physical size of the database. It's an > > Oracle 10 database. Actually, it's a small datawarehouse with 5 tables > > of raw data. I only have a SQL Plus interface, so some commands don't > > work. I can't find a query to get me the physical size anywhere on the > > net. If you have any ideas or input, PLEASE send me an email or > > respond to this post. I would greatly appreciate it. I hope someone > > is out there. > > > > Regards, > > > > Rich > > > > > > With advice, you can have it good, fast or free. Pick any two, plz. > > >I only have a SQL Plus interface, so some commands don't work. > Which commands do not work in SQL*Plus? > > The lack of planning on your part does not necessarily constitute an > emergency on my part, > > SQL> DESC DBA_DATA_FILES > SQL> DESC DBA_TEMP_FILES
From: IANAL_VISTA on 13 Sep 2006 22:39 rwking(a)gmail.com wrote in news:1158201209.657524.204770(a)p79g2000cwp.googlegroups.com: > I understand, and I appreciate your input. However, your query didn't > work. Here's the response I got... > > ERROR: > ORA-04043: object "SYS"."DBA_DATA_FILES" does not exist > > Any ideas? You did not pick your two choices. see below > > > > IANAL_VISTA wrote: >> rwking(a)gmail.com wrote in >> news:1158200438.844620.237050(a)m73g2000cwd.googlegroups.com: >> >> > Hi everyone, >> > >> > I have a project due in about an hour... one of the questions I >> > have to answer is determining the physical size of the database. >> > It's an Oracle 10 database. Actually, it's a small datawarehouse >> > with 5 tables of raw data. I only have a SQL Plus interface, so >> > some commands don't work. I can't find a query to get me the >> > physical size anywhere on the net. If you have any ideas or input, >> > PLEASE send me an email or respond to this post. I would greatly >> > appreciate it. I hope someone is out there. >> > >> > Regards, >> > >> > Rich >> > >> > >> >> With advice, you can have it good, fast or free. Pick any two, plz. >> >> >I only have a SQL Plus interface, so some commands don't work. >> Which commands do not work in SQL*Plus? >> >> The lack of planning on your part does not necessarily constitute an >> emergency on my part, >> >> SQL> DESC DBA_DATA_FILES >> SQL> DESC DBA_TEMP_FILES > > deserve to be ignored bottom up & read from the are folks who Top posters
From: rwking on 13 Sep 2006 22:43
I'm sorry, but I don't understand what I'm supposed to choose, and I also don't have time for games. Thank you for your first suggestion. IANAL_VISTA wrote: > rwking(a)gmail.com wrote in > news:1158201209.657524.204770(a)p79g2000cwp.googlegroups.com: > > > I understand, and I appreciate your input. However, your query didn't > > work. Here's the response I got... > > > > ERROR: > > ORA-04043: object "SYS"."DBA_DATA_FILES" does not exist > > > > Any ideas? > > > You did not pick your two choices. > see below > > > > > > > > > IANAL_VISTA wrote: > >> rwking(a)gmail.com wrote in > >> news:1158200438.844620.237050(a)m73g2000cwd.googlegroups.com: > >> > >> > Hi everyone, > >> > > >> > I have a project due in about an hour... one of the questions I > >> > have to answer is determining the physical size of the database. > >> > It's an Oracle 10 database. Actually, it's a small datawarehouse > >> > with 5 tables of raw data. I only have a SQL Plus interface, so > >> > some commands don't work. I can't find a query to get me the > >> > physical size anywhere on the net. If you have any ideas or input, > >> > PLEASE send me an email or respond to this post. I would greatly > >> > appreciate it. I hope someone is out there. > >> > > >> > Regards, > >> > > >> > Rich > >> > > >> > > >> > >> With advice, you can have it good, fast or free. Pick any two, plz. > >> > >> >I only have a SQL Plus interface, so some commands don't work. > >> Which commands do not work in SQL*Plus? > >> > >> The lack of planning on your part does not necessarily constitute an > >> emergency on my part, > >> > >> SQL> DESC DBA_DATA_FILES > >> SQL> DESC DBA_TEMP_FILES > > > > > > deserve to be ignored > bottom up & > read from the > are folks who > Top posters |