Export Oracle db schema only - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Export Oracle db schema only

Export Oracle db schema only# Database - 数据库

s*m2004-01-17 08:01

1 楼

I am trying to export a production oracle database schema of a tablespace to a
test system. However, I have limited space on test system. On production
system, many data files are created for different indexes and tables. These
datafile is created using large disk spaces. How can I export the production
tablespace schema but with smaller datafile size definition?
Thanks

n*a2004-01-17 08:01

2 楼

Schema shouldn't take up much space.
Just make sure that all you need
is schema, no data.
You could use exp/imp utilities.
exp with rows=n and then imp.
If you use indexfile option of imp,
you could get the sql script that
will generate the same schema.

a

【在 s***m 的大作中提到】

: I am trying to export a production oracle database schema of a tablespace to a
: test system. However, I have limited space on test system. On production
: system, many data files are created for different indexes and tables. These
: datafile is created using large disk spaces. How can I export the production
: tablespace schema but with smaller datafile size definition?
: Thanks

s*e2004-01-17 08:01

3 楼

do you mean you want to import full database to your test system, but the test
system space does not allow you do that? if so, I did a similar project before
and keep all the documentation. Let me know.

a

【在 s***m 的大作中提到】

s*e2004-01-17 08:01

4 楼

Schema did take space sometimes. especially tablespace.

to
These
production

【在 n********a 的大作中提到】

: Schema shouldn't take up much space.
: Just make sure that all you need
: is schema, no data.
: You could use exp/imp utilities.
: exp with rows=n and then imp.
: If you use indexfile option of imp,
: you could get the sql script that
: will generate the same schema.
:
: a

n*a2004-01-17 08:01

5 楼

How much as compared to data?
Add up the bytes taken by your SYSTEM tablespace.

【在 s*******e 的大作中提到】

: Schema did take space sometimes. especially tablespace.
:
: to
: These
: production

s*m2004-01-17 08:01

6 楼

Yes, I want to import full database schema from production system to test
system. However, I don't want to import any of the data. I just need the
tablespace definition, trigger, storedproc, functions and constraints. Owing
to the production system's size, at which many datafiles has been created for
userspace and index space, my export captures the size of the those index
datafiles. If you have a documention on how to do this, it will be very
helpful.
Thanks

test
before
to
These
production

【在 s*******e 的大作中提到】

: do you mean you want to import full database to your test system, but the test
: system space does not allow you do that? if so, I did a similar project before
: and keep all the documentation. Let me know.
:
: a

h*i2004-01-17 08:01

7 楼

EXPORT 的CONTROL FILE里不是有一个PARAMETER叫ROWS，假如你设为N的话，
那么你只EXPORT TABLE 的DEFINITION，而不会包含DATA？
你是想问这个吗？
OracleSQLPLUS的资料里有一章就叫EXPORT，做你读一下就全懂了。。。

for
tablespace

【在 s***m 的大作中提到】

: Yes, I want to import full database schema from production system to test
: system. However, I don't want to import any of the data. I just need the
: tablespace definition, trigger, storedproc, functions and constraints. Owing
: to the production system's size, at which many datafiles has been created for
: userspace and index space, my export captures the size of the those index
: datafiles. If you have a documention on how to do this, it will be very
: helpful.
: Thanks
:
: test

s*m2004-01-17 08:01

8 楼

I knew about rows parameter in exp command. The issue is different. I set to
export only table definition, however, all table definitions live on large
datafile. I don't want to export definition of large datafile. How can I do
that?

Owing
the
production

【在 h******i 的大作中提到】

: EXPORT 的CONTROL FILE里不是有一个PARAMETER叫ROWS，假如你设为N的话，
: 那么你只EXPORT TABLE 的DEFINITION，而不会包含DATA？
: 你是想问这个吗？
: OracleSQLPLUS的资料里有一章就叫EXPORT，做你读一下就全懂了。。。
:
: for
: tablespace

h*i2004-01-17 08:01

9 楼

这样的话，我能想到的就是每个TABLE 单独弄，然后设 WHERE ROWNUM<1
你最好去ORACLE 的网站问一下，那里都是专家。。。

test
created
index
project
tables.

【在 s***m 的大作中提到】

: I knew about rows parameter in exp command. The issue is different. I set to
: export only table definition, however, all table definitions live on large
: datafile. I don't want to export definition of large datafile. How can I do
: that?
:
: Owing
: the
: production