06-24-2003
First, I'm not a Oracle expert (or even a DBA). But in working with them I've learned some things and I know when they do their exports (of an entire database) they need approximately the same space as the database is USING, not what it's set up to (as far as growth).
The same for exporting tables - if it's set up to be 200mb but is only using 25mb, then you would need 25 mb free to export it. Always add 5-10% to be sure and I also believe they compress it on the way out.
See the following info on determining the size of a table:
samoratech.com - table size
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello people,
Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Discussion started by: vinayagan
3 Replies
2. Shell Programming and Scripting
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies
3. Shell Programming and Scripting
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time then Go to sleep mode and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies
4. Shell Programming and Scripting
Hi,
I want to write a shell script which will export data from oracle table .
I don't want to save that data . I want the queries .
Right now i am right clicking on the table and clicking on export as to my desktop .
Please let me know if any one have any idea . (2 Replies)
Discussion started by: honey26
2 Replies
5. Shell Programming and Scripting
I need to write a unix shell script to connect to oracle database and retrieve data from a table, the script should count the total number of rows till date in that table
number of rows which are getting filled per hour on current day and the peak hour of the current day
number of rows which are... (5 Replies)
Discussion started by: PhAnT0M
5 Replies
6. UNIX and Linux Applications
hi,
i need to copy one table with data into another table,
right now am using
create table table1 as select * from table2
i want the constraints of table1 to be copied to table2 also , can anyone give me some solution to copy the constraints also, now am using oracle 10.2.0.3.0... (1 Reply)
Discussion started by: senkerth
1 Replies
7. Shell Programming and Scripting
Hello all,
Thank you in advance for reading my post and helping me..
Scenario:
I have 50 tables whose names are in a file export.sql, i use the below command to export all these tables one by one
cat export.sql|while read tn
do
echo "export to $tn.del of del select from... (7 Replies)
Discussion started by: family_guy
7 Replies
8. UNIX and Linux Applications
Good evening
I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus.
I tried to find out the user/passwd and service name by env variable and all Ive got is this:
ORACLE_SID_REPCOL=SCL_REPCOL
ORACLE_SID=xmeta
ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies
LEARN ABOUT DEBIAN
database
database(1grass) Grass User's Manual database(1grass)
GRASS GIS 6.4.2 Reference Manual
Geographic Resources Analysis Support System, commonly referred to as GRASS, is a <a href="http://en.wikipedia.org/wiki/Geographic_informa-
tion_system">Geographic Information System (GIS) used for geospatial data management and analysis, image processing, graphics/maps produc-
tion, spatial modeling, and visualization. GRASS is currently used in academic and commercial settings around the world, as well as by many
governmental agencies and environmental consulting companies.
This reference manual details the use of modules distributed with Geographic Resources Analysis Support System (GRASS), an open source (GNU
GPL'ed), image processing and geographic information system (GIS). Go back to help overview
database commands:
| db.columns | List all columns for a given table.
| db.connect | Prints/sets general DB connection for current mapset and exits.
| db.copy | Copy a table.
| db.describe | Describes a table in detail.
| db.drivers | Lists all database drivers.
| db.dropcol | Drops a column from selected attribute table
| db.droptable | Drops an attribute table.
| db.execute | Executes any SQL statement.
| db.in.ogr | Imports attribute tables in various formats.
| db.login | Sets user/password for driver/database.
| db.out.ogr | Exports attribute tables into various formats.
| db.select | Selects data from attribute table (performs SQL query statement(s)).
| db.tables | Lists all tables for a given database.
| db.test | Test database driver, database must exist and set by db.connect.
Full Index
(C) 2003-2011 GRASS Development Team
GRASS 6.4.2 database(1grass)