 | |
#1
 
| |||
| |||
|
Copy schema without data -
08-26-2008
, 06:08 PM
#2
| |||
| |||
|
|
Hi all Probably an easy question for an oracle dba or even power user: I would like to copy the data warehouse schema on my laptop for testing and developing our application. - Unfortunately I have a 80GB HD and the DWH contains a few 'tera'. - Fortunately, I don't need the data (ok perhaps a few master data). I need only the schema to avoid 'table not found' errors and so on. How can I copy all the tables (mat. views to be correct) without the data from our dwh? But please don't tell me to dump the whole thing and delete the data. DWH and networking team would kill me. Good news: no indices, no constraints, just 1 to 1 raw data dumped out of our business solution environment. But I only have access to mat. views and not to the tables directly. I tried a create table from select... that did the job more or less but I guess I can't trust it (do mat views identify their underlaying schema correctly?) Forgive a spoiled ms developer and thank you in advance Raoul |
#3
| |||
| |||
|
|
Hi all Probably an easy question for an oracle dba or even power user: I would like to copy the data warehouse schema on my laptop for testing and developing our application. - Unfortunately I have a 80GB HD and the DWH contains a few 'tera'. - Fortunately, I don't need the data (ok perhaps a few master data). I need only the schema to avoid 'table not found' errors and so on. How can I copy all the tables (mat. views to be correct) without the data from our dwh? But please don't tell me to dump the whole thing and delete the data. DWH and networking team would kill me. Good news: no indices, no constraints, just 1 to 1 raw data dumped out of our business solution environment. But I only have access to mat. views and not to the tables directly. I tried a create table from select... that did the job more or less but I guess I can't trust it (do mat views identify their underlaying schema correctly?) Forgive a spoiled ms developer and thank you in advance Raoul |
#4
| |||
| |||
|
|
Hi all Probably an easy question for an oracle dba or even power user: I would like to copy the data warehouse schema on my laptop for testing and developing our application. - Unfortunately I have a 80GB HD and the DWH contains a few 'tera'. - Fortunately, I don't need the data (ok perhaps a few master data). I need only the schema to avoid 'table not found' errors and so on. How can I copy all the tables (mat. views to be correct) without the data from our dwh? But please don't tell me to dump the whole thing and delete the data. DWH and networking team would kill me. Good news: no indices, no constraints, just 1 to 1 raw data dumped out of our business solution environment. But I only have access to mat. views and not to the tables directly. I tried a create table from select... that did the job more or less but I guess I can't trust it (do mat views identify their underlaying schema correctly?) Forgive a spoiled ms developer and thank you in advance Raoul |
#5
| |||
| |||
|
|
Hi all Probably an easy question for an oracle dba or even power user: I would like to copy the data warehouse schema on my laptop for testing and developing our application. - Unfortunately I have a 80GB HD and the DWH contains a few 'tera'. - Fortunately, I don't need the data (ok perhaps a few master data). I need only the schema to avoid 'table not found' errors and so on. How can I copy all the tables (mat. views to be correct) without the data from our dwh? But please don't tell me to dump the whole thing and delete the data. DWH and networking team would kill me. Good news: no indices, no constraints, just 1 to 1 raw data dumped out of our business solution environment. But I only have access to mat. views and not to the tables directly. I tried a create table from select... that did the job more or less but I guess I can't trust it (do mat views identify their underlaying schema correctly?) Forgive a spoiled ms developer and thank you in advance Raoul |
#6
| |||
| |||
|
|
Hi all Probably an easy question for an oracle dba or even power user: I would like to copy the data warehouse schema on my laptop for testing and developing our application. - Unfortunately I have a 80GB HD and the DWH contains a few 'tera'. - Fortunately, I don't need the data (ok perhaps a few master data). I need only the schema to avoid 'table not found' errors and so on. How can I copy all the tables (mat. views to be correct) without the data from our dwh? But please don't tell me to dump the whole thing and delete the data. DWH and networking team would kill me. Good news: no indices, no constraints, just 1 to 1 raw data dumped out of our business solution environment. But I only have access to mat. views and not to the tables directly. I tried a create table from select... that did the job more or less but I guess I can't trust it (do mat views identify their underlaying schema correctly?) Forgive a spoiled ms developer and thank you in advance Raoul |
sorry for my smal english
you can use under linux or unxi the comandline with EXP or in oracle
10.x. in commandline the expdp
in all using help can you see with exp help=y oder expdp help=y
if you ar user with privileg FULL_EXPORT_DATABASE or so ... the tje user
can make an export follow
exp userid=name/pasword FILE=filname-of-the-exportfile.dmp
LOG=name-of-the-logfile.log USER=name-from-the-user who sould export
FULL=n
please look at teh command detailed. i havent an manuell in front of
me.
ist used the filedirektory where you actuell are standing.
thast all
have a good time
#7
| |||
| |||
|
|
Hi all Probably an easy question for an oracle dba or even power user: I would like to copy the data warehouse schema on my laptop for testing and developing our application. - Unfortunately I have a 80GB HD and the DWH contains a few 'tera'. - Fortunately, I don't need the data (ok perhaps a few master data). I need only the schema to avoid 'table not found' errors and so on. How can I copy all the tables (mat. views to be correct) without the data from our dwh? But please don't tell me to dump the whole thing and delete the data. DWH and networking team would kill me. Good news: no indices, no constraints, just 1 to 1 raw data dumped out of our business solution environment. But I only have access to mat. views and not to the tables directly. I tried a create table from select... that did the job more or less but I guess I can't trust it (do mat views identify their underlaying schema correctly?) Forgive a spoiled ms developer and thank you in advance Raoul |
sorry for my smal english
you can use under linux or unxi the comandline with EXP or in oracle
10.x. in commandline the expdp
in all using help can you see with exp help=y oder expdp help=y
if you ar user with privileg FULL_EXPORT_DATABASE or so ... the tje user
can make an export follow
exp userid=name/pasword FILE=filname-of-the-exportfile.dmp
LOG=name-of-the-logfile.log USER=name-from-the-user who sould export
FULL=n
please look at teh command detailed. i havent an manuell in front of
me.
ist used the filedirektory where you actuell are standing.
thast all
have a good time
#8
| |||
| |||
|
|
Hi all Probably an easy question for an oracle dba or even power user: I would like to copy the data warehouse schema on my laptop for testing and developing our application. - Unfortunately I have a 80GB HD and the DWH contains a few 'tera'. - Fortunately, I don't need the data (ok perhaps a few master data). I need only the schema to avoid 'table not found' errors and so on. How can I copy all the tables (mat. views to be correct) without the data from our dwh? But please don't tell me to dump the whole thing and delete the data. DWH and networking team would kill me. Good news: no indices, no constraints, just 1 to 1 raw data dumped out of our business solution environment. But I only have access to mat. views and not to the tables directly. I tried a create table from select... that did the job more or less but I guess I can't trust it (do mat views identify their underlaying schema correctly?) Forgive a spoiled ms developer and thank you in advance Raoul |
sorry for my smal english
you can use under linux or unxi the comandline with EXP or in oracle
10.x. in commandline the expdp
in all using help can you see with exp help=y oder expdp help=y
if you ar user with privileg FULL_EXPORT_DATABASE or so ... the tje user
can make an export follow
exp userid=name/pasword FILE=filname-of-the-exportfile.dmp
LOG=name-of-the-logfile.log USER=name-from-the-user who sould export
FULL=n
please look at teh command detailed. i havent an manuell in front of
me.
ist used the filedirektory where you actuell are standing.
thast all
have a good time
#9
| |||
| |||
|
|
Hi all Probably an easy question for an oracle dba or even power user: I would like to copy the data warehouse schema on my laptop for testing and developing our application. - Unfortunately I have a 80GB HD and the DWH contains a few 'tera'. - Fortunately, I don't need the data (ok perhaps a few master data). I need only the schema to avoid 'table not found' errors and so on. How can I copy all the tables (mat. views to be correct) without the data from our dwh? But please don't tell me to dump the whole thing and delete the data. DWH and networking team would kill me. Good news: no indices, no constraints, just 1 to 1 raw data dumped out of our business solution environment. But I only have access to mat. views and not to the tables directly. I tried a create table from select... that did the job more or less but I guess I can't trust it (do mat views identify their underlaying schema correctly?) Forgive a spoiled ms developer and thank you in advance Raoul |
sorry for my smal english
you can use under linux or unxi the comandline with EXP or in oracle
10.x. in commandline the expdp
in all using help can you see with exp help=y oder expdp help=y
if you ar user with privileg FULL_EXPORT_DATABASE or so ... the tje user
can make an export follow
exp userid=name/pasword FILE=filname-of-the-exportfile.dmp
LOG=name-of-the-logfile.log USER=name-from-the-user who sould export
FULL=n
please look at teh command detailed. i havent an manuell in front of
me.
ist used the filedirektory where you actuell are standing.
thast all
have a good time
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.