Hi,
You can do a USER Level export and import them to another schema. If the
names are different you may have to use FROMUSER TOUSER during the import.
Oracle Utilities Manual will have more information.
Best Regards,
K Gopalakrishnan
(408) 934 9310
-Original Message-
[EMAIL
Use this.
exp scott/tiger tables=(t1,t2,t3) Owner=scott
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 7456019
-Original Message-
Sent: Monday, December 10, 2001 12:35 PM
To: Multiple recipients of list ORACLE-L
Hi list.
I
You can export the tables in Table level export and then import it to the
target database. As suggested by GopalKrishnan, if the names are different
you may have to use FROMUSER TOUSER during the import.
-Original Message-
Gopalakrishnan
Sent: Monday, December 10, 2001 2:45 PM
To:
Thanks. Still have another questions.
- When importing can I change the original tables name?
- I try exp80imp80 and besides the tables I saw that the import tool get
the constraints related to those tables. Can I import only the
structeuredata of the table without indexes and any other objects
Yes, you can import without constraints / indexes. exp80 help=y, imp80
help=y will give you a list of the valid command-line options for export
and import.
[EMAIL PROTECTED] wrote:
Thanks. Still have another questions.
- When importing can I change the original tables name?
- I try
Use the fromuser touser parameters. Better yet, read a manual.
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, December 10, 2001 12:35 AM
To: Multiple recipients of list ORACLE-L
Hi list.
I have 3 tables in a schema and I want to export them to another schema in
another database.