Home » RDBMS Server » Server Administration » How can I export users table schema to a file.
How can I export users table schema to a file. [message #52805] Wed, 14 August 2002 20:14 Go to next message
Jack Hu
Messages: 2
Registered: October 2001
Junior Member
Dear Sir:
How can I export users all table schema or package to a file?
thanks
Jack Hu

Report message to a moderator

Re: How can I export users table schema to a file. [message #52808 is a reply to message #52805] Wed, 14 August 2002 20:20 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Create exp.par file as:

userid=/
file=
log=
owner=<schema_name>
feedback=y
buffer=1000000
consistent=y

Then run:

$exp parfile=exp.par

For more export/import tips check Here

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Re: How can I export users table schema to a file. [message #52812 is a reply to message #52805] Thu, 15 August 2002 04:49 Go to previous messageGo to next message
Roar Jorstad
Messages: 1
Registered: August 2002
Junior Member
This script will list all column with datatype
and length for the table STRM_PERIOD_STATUS.

[[.... Start script ....]]
set linesize 9000
set trimspool on

column owner format a10
column table_name format a20
column column_name format a20
column data_type format a20

spool c:temptable.txt

select owner, table_name, column_name, data_type, data_length
from all_tab_columns
where table_name = 'STRM_PERIOD_STATUS'
order by owner, table_name, column_name ;

spool
spool off

Report message to a moderator

Re: How can I export users table schema to a file. [message #52818 is a reply to message #52808] Thu, 15 August 2002 08:41 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
That is a bit more specific. In this case follow This Link.

It has links to tools and ways to extract DDL for any object in the Oracle DB into flat text file.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Recovering the data
Next Topic: MTS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 13:59:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.